Training Calendar

Advanced Excel

Instructor: Computer Training of America
Fee: $242.10

Date: Time: Code: Location:  
Aug 23, 2018 9:00am - 4:00pm PD007.180823CTAAE Palmer, MA REGISTER NOW


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
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

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