|
|
|
|
EXC103I: Microsoft Excel Advanced
|
|
|
|
|
Tuition:
$245.00 per student |
Length: 1 day |
|
|
Synopsis:
Hands-on course covers advanced-level features and functions of Microsoft Excel. Students will learn how to create nested functions, export/import data, perform what-if analyses, create pivot tables, use the Goal Seek and Solver utilities, record and run macros. Comes with a companion CBT program. Students should have taken EXC102i Excel Intermediate or have equivalent experience. Excel 2003 and Excel 2007 versions available.
|
|
Formats:
Corporate groups (min. 2 students) at your facility or ours in San Juan Capistrano, Orange County, California. Single individuals may arrange a 5 hour private class for $295. Pre-scheduled classes are not available.
|
|
Scheduling:
Classes flexibly scheduled by arrangement.
|
|
Group
Discounts:
Yes - see FAQ's.
|
|
|
|
| Session 1 | Course Topics | 3.0 Hours | | |
- Working with advanced formulas
- Using names
, Using decision-making functions
, Creating nested functions
, Using financial functions
- Lookups and data tables
- Working with lookup functions
, Using MATCH and INDEX
, Creating data tables
- Advanced list management
- Creating subtotals
, Validating cell entries
, Exploring database functions
, Working with data forms
- Working with PivotTables and PivotCharts
- Working with PivotTables
, Rearranging PivotTables
, Formatting PivotTables
, Working with PivotCharts
| | | Session 2 | Course Topics | 3.0 Hours | | |
- Exporting and importing
- Exporting and importing text files
, Exporting and importing XML data
, Querying external databases
- Using analytical options
- Working with Goal Seek and Solver
, B: Working with the Analysis ToolPak
, C: Working with scenarios
, D: Working with views
- Working with macros
- Running and recording a macro
, Working with VBA code
, Function procedures
- Interactive Web pages
- Creating interactive Web spreadsheets
, Publishing PivotTables on the Web
| |
|
|
Materials:
Student manual plus CD with companion CBT, training certificate.
|
|
Location:
Classes can be taught on-site at your facilities
or at our location in San Juan Capistrano, Orange
County. We also travel beyond Southern California.
|
|
|
|
