What you’ll learn

Understanding Excel's elements

• Workbooks, worksheets, cells, formula bar etc.

Editing techniques

• Cells selection
• Data entry
• To insert a row
• To delete a row
• Undo
• copying a range of cells
• Moving a range of cells
• Using paste special
• Clearing cell contents

Writing formulas

• Constructing formulas
• Using operators (+,-,x, ¸,etc...)
• Using references
• Tips on entering formulas

File operations

• Saving workbooks
• Save as...
• Save
• Closing workbooks
• Deleting workbooks

Printing worksheets

• Using print preview
• Page setup
• Header and footer settings
• Margin settings
• Turning the gridlines on or off
• Turn the row/column heading on or off
• Auto scaling printout
• Setting manual page breaks
• Setting row or column titles
• Setting print area

Useful functions

• SUM( )
• AVERAGE( )
• MAX( )
• MIN( )
• IF()
• Count()

Tips in editing a worksheets

• Paste insert row/column
• Drag and drop
• Autofill
• Fill down
• Fill right

Understanding address notations

• Relative address
• Absolute address

Polishing worksheets

• Adding border
• Adjusting row heights and column widths manually
• Adjusting row heights and column widths automatically
• Setting text alignments ( horizontal and vertical )
• Setting text orientations
• Shading cell background
• Font settings

Number format

• Adding thousand separator
• Adding currency sign number
• Adding decimal points
• Creating a master spreadsheet
• Creating document templates
• Using document templates

Exchange files with other applications

• Understanding various Excel file formats
• Saving workbook for backward compatibility
• Exporting excel workbook for other software

Styles

• Creating styles
• Using styles
• Editing styles
• Merging styles from other workbooks

Managing Records

• Sorting Records
• Filtering records

Drawing

• Inserting shapes
• Drawing lines, rectangles, ovals etc.

Charting

• Inserting various kinds of chart – column, line, bar and pie chart
• Adding and modifying chart’s elements
• Chart title, Legend, Axis, Grids, Data table, Data label
• Polishing charts
• Adding special effects to chart elements
• Filling charts with gradients or pictures

Creating a 3D chart

• 3D Chart
• Constructing 3D charts
• Formatting 3D charts
• Changing 3D view