Excel Level 1, Level 2 and Level 3 and Excel VBA Programming summary
Sage software logo

This page provides summary information on the following Microsoft Excel courses:

Excel Level 1
Excel Level 2
Excel Level 3
Excel VBA Programming

For more detailed information on any course, click a link above.

Excel Level 1

This course is an introduction to the most widely used spreadsheet program.

Course Content:

Spreadsheet terminology; Getting help; Navigating workbooks; Entering and editing text, values and formulas; Working with pictures; Saving and updating workbooks; Moving and copying data and formulas; Absolute and relative cell references; Inserting and deleting ranges, rows and columns; Using functions; Formatting text, rows, columns and numbers; Conditional formatting; Additional formatting options; Preparing to print; Page Setup options; Printing worksheets; Chart basics; Formatting charts.


Excel Level 2

This is an intermediate level course on Excel.

Course Content:

Viewing and printing large worksheets; Multiple worksheets; Linking worksheets with 3D formulas; Using multiple workbooks; Linking workbooks; Special number formats; Using functions to format text; Styles and themes; Other advanced formatting; Outlining and consolidating data; Creating subtotals; Creating and using names; Managing names; Sorting and filtering data; Advanced filtering; Tables; Saving workbooks as Web pages; Hyperlinks; Sharing workbooks; Auditing features; Comments in cells and workbooks; Protection; Workgroup collaboration; Application settings; Built-in templates; Creating and managing templates.


Excel Level 3

This is an advanced level course on Excel.

Course Content:

Advanaced functions; Array formulas; Lookup functions; MATCH and INDEX; Creating data tables; Validating cell entries; Advanced filtering; Advanced charting; Chart formatting options; Combination charts; Graphic elements; PivotTables; Rearranging PivotTables; Formatting PivotTables; PivotCharts; Exporting and importing text files; Getting external data; Goal Seek and Solver; Scenarios; Running and recording a macro; Working with VBA code.


Excel VBA Programming

This course is an introduction to programming with VBA in Excel.

Course Content:

The Visual Basic Editor; Visual Basic for Applications; Object Programming; The Object Browser; Data Basics; Scope of Variables; Scope of Procedures; Design Structures; Loop Structures; Custom Dialog Boxes; User Forms; Events; Errors; Debugging; Error Handling.


Study Methods

Individual Tuition
Group Training
Distance Learning


Further Information

Enquiry Form