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
Single Input Data Tables
Double Input Data Tables

Working With Pivot Tables

Creating a Pivot Table
Setting Row and Column Fields
Setting Page Fields
Setting Data Fields
Pivoting a Pivot Table
Data Analysis Options
Filtering Pivot Data
Creating Pivot Charts

Working With External Data

Querying a Database
Importing and Exporting Files
Importing Data via ODBC
Using SQL Statements
Importing and Exporting XML Data
Protecting Data
Using Data Validation
Using Worksheet Protection
Password Protecting a Workbook

Back to top