This one-day course builds on the skills and
concepts taught in Excel 2007: Intermediate.
Students will work with advanced formulas, as well as
lookup functions such as VLOOKUP, MATCH, and INDEX. In
addition, students will learn about data validation and
database functions such as DSUM. They will learn how to
work with PivotTables and PivotCharts, how to import and
export data, and how to query external databases.
Finally, students will learn about the analytical
features of Excel (such as Goal Seek and Solver),
running and recording macros, and sharing Excel data via
the Web. Designated as Approved Courseware. For
comprehensive certification training, students should
complete Excel 2007: Basic, Intermediate, and Advanced.
Contact us for further details.
After completing this course, students will know how to:
Advanced functions
Logical
functions
Math and statistical functions
Financial
functions
Displaying and printing formulas
Lookups
and data tables
Using lookup functions
Using MATCH
and INDEX
Creating data tables
Advanced list
management
Validating cell entries
Exploring
database functions
PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
PivotCharts
Exporting and
importing
Exporting and importing text files
Exporting and importing XML data
Querying external
databases
Analytical options
Goal Seek and Solver
The Analysis ToolPak
Scenarios
Views
Macros
and custom functions
Running and recording a macro
Working with VBA code
Creating functions
Conditional formatting and SmartArt
Conditional
formatting with graphics
SmartArt graphics
Before taking this course, you
should be familiar with personal computers and the use
of a keyboard and a mouse. Furthermore, this course
assumes that you've completed the following courses or
have equivalent experience: Excel 2007: Basic and Excel
2007: Intermediate.
Youshould have some experience
with Excel 2007 and should be familiar with
intermediate-level tasks, such as sorting data, linking
worksheets, and outlining and consolidating data. You'll
get the most out of this course if your goal is to
become proficient in performing advanced tasks, such as
creating nested functions, working with data tables,
exporting and importing data, performing what-if
analyses, and recording macros.
For comprehensive training,
you should complete all of the following courses: Excel
2007: Basic, Excel 2007: Intermediate, and Excel 2007:
Advanced.
Beyond Advanced
Microsoft Excel 2007 Power User
Excel VBA