Excel Course – Level 1 

• Excel basics
• Working with formulae
• Autosum function
• Average function
• Automatically fill a range
• Move and copy cell entries
• Insert new rows and columns into a worksheet
• Formatting cells
• Add a border and shading to a worksheet
• Change the page setup and preview a worksheet
• Headers and footers

Excel Course – Level 2 

• Shortcuts
• Work with absolute cell references
• Percentage formula
• More functions
• Enter a formula to link related worksheets
• Create links between workbooks
• Charts
• Hiding rows and columns
• Sort database records
• Filter database records
• Use the subtotal feature
• Controlling the screen
• Conditional formatting

Excel Course – Level 3

• Define a range name

• Advanced functions

• Lookup tables

• Outline a worksheet

• Create and display a view

• Protecting a workbook

• Protecting part of a workbook

• Goal seek

• Scenarios

• Create a pivot table

• Macros