Microsoft Excel Advanced (1 day recommended)

Our advanced Excel course will show experienced Excel users how to work with lists (databases), create macros and user-defined functions, perform what-if analysis, use advanced analysis tools and work with external data.

The course is suitable for those with a good knowledge of all of Excel's basic and intermediate features and shortcuts.

Course outline

Working with Lists

Creating a List
Maintaining a List
Editing Records Using the Data Form
Filtering a List
Using Subtotals in a List

Working with Macros and User Defined Functions

Recording and Using Macros
Assigning Macros
Using User Defined Functions

Using Basic Analysis Tools

Performing “What If” Analyses
Working with Scenarios
Assignment

Using Advanced Analysis Tools and External Data

Querying a Database
Importing and Exporting Files
Protecting Data
Using Data Validation
Using Worksheet Protection
Password Protecting a Workbook

Back to top