|
|
EXC103I: Microsoft Excel Training Part 3
|
Book List |
Course Links
|
|
Tuition: $195.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. Students should have taken Microsoft Excel Part 2 or have equivalent experience. When taken on a private basis, class content can be tailored to your needs.
|
Formats:
Corporate groups (min. 3 students) at your facility only.
|
Scheduling:
Classes may be scheduled to suit the convenience of your group in as little as 2 to 3 weeks.
|
Group
Discounts:
2-4 students 20%, 5-8 30%, >8 quote
|
|
|
|
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
, Working with the Analysis ToolPak
, Working with scenarios
, 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, training certificate.
|
Location:
Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.
|
Related Services |
Need
help with a project? We may also provide programming
and consulting services covering the above material. See
Programming and Consulting for more information.
|
|
|
|