Training Calendar

Advanced Excel

Instructor: Computer Training of America
Fee: $242.10

Date: Time: Code: Location:  
Jan 26, 2018 9:00am - 4:00pm PD007.180126CTAAE Palmer, MA REGISTER NOW
Feb 07, 2018 9:00am - 4:00pm PD007.180207CTAAE Palmer, MA REGISTER NOW
Feb 22, 2018 9:00am - 4:00pm PD007.180222CTAAE Palmer, MA REGISTER NOW
Mar 07, 2018 9:00am - 4:00pm PD007.180307CTAAE 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
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