Training Calendar

Advanced Excel

Instructor: Computer Training of America
Fee: $242.10

Date: Time: Code: Location:  
Jun 05, 2019 9:00am - 4:00pm PD007.190605CTAAE Palmer, MA REGISTER NOW
Jun 24, 2019 9:00am - 4:00pm PD007.190624CTAAE Palmer, MA REGISTER NOW
Jul 01, 2019 9:00am - 4:00pm PD007.190701CTAAE Palmer, MA REGISTER NOW
Jul 22, 2019 9:00am - 4:00pm PD007.190722CTAAE Palmer, MA REGISTER NOW
Jul 31, 2019 9:00am - 4:00pm PD007.190731CTAAE Palmer, MA REGISTER NOW
Aug 15, 2019 9:00am - 4:00pm PD007.190815CTAAE 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