This one-day Excel 2010 Advanced course builds on the
skills and concepts taught in Excel 2010: 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.
Contact us for further details.
After completing this course, students will know how to:
PivotTables
and PivotCharts
Working with PivotTables
Rearranging
PivotTables
Formatting PivotTables
PivotCharts
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
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 2010: Basic and Excel 2010:
Intermediate.
You should have some
experience with Excel 2010 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 2010: Basic, Excel 2010:
Intermediate, and Excel 2010: Advanced.
Beyond
Advanced
Microsoft Excel 2010 Power User
Excel VBA
Expert and specialised courses and
consultancy sessions can include many topics ranging
from business modelling to arrays to Monte Carlo
simulation