Microsoft Excel training courses from beginner to advanced level
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, please click a link above.
Excel Level 1
An introduction to the most popular 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 TuitionGroup Training
Distance Learning