This page provides summary information on the following Microsoft Excel courses:
For more detailed information on any course, click a link above.
This course is an introduction to the most widely used spreadsheet program.
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.
This is an intermediate level course on Excel.
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.
This is an advanced level course on Excel.
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.
This course is an introduction to programming with VBA in Excel.
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.