Training Calendar

Advanced Excel

Instructor: Computer Training of America
Fee: $242.10

Advanced Excel will cover the following:

Logical and statistical functions:
Logical functions
Math and statistical functions

Financial and date functions:
Financial functions
Date and time functions
Array formulas
Displaying and printing formulas

Lookups and data tables:
Using lookup functions
Using MATCH and INDEX
Creating data tables

Advanced data management:
Validating cell entries
Exploring database functions

Exporting and importing:
Exporting and importing text files
Exporting and importing XML data
Getting external data

Analytical tools:
Goal Seek and Solver
The Analysis ToolPak
Scenarios

Macros and custom functions:
Running and recording a macro
Working with VBA code
Creating functions

Please contact Michele Jackson at 877-662-6444 ext. 3004 for scheduling information