COURSE DETAILS - EXCEL - About | Intro | Adv | VBA1 | VBA2 | VBA3
My Basket | My Account |    

Download Macresource Course Directory 2009
Download our
course directory

 

Microsoft Excel icon

Add EXL2 to my courses MS Excel 2007 Advanced (1 day)

Look for available dates for this training course

Designed for those already familiar with basic Excel concepts and spreadsheet use.
Data manipulation
  Automatic outlining
Group and ungroup
Filtering data
Advanced filtering
Sorting data
Inserting Subtotals
Creating an Advanced Filter
Single input data tables
Double input data tables
Formulas and functions
  Complex If statements
Using nested functions
Using named regions
Using lookup functions
Using database functions
The DSUM Function
The DAVERAGE Function
The DCOUNT Function
The DGET Function
The DMIN Function
The DMAX Function
Tools
  Creating scenarios
Scenario summary reports
Protecting scenarios
Using Goal Seek
Using the Solver
Working with views
What-if analysis
  Overview of PivotTables
The PivotTable Wizard
Formatting PivotTables
Rearranging PivotTables
Sorting data
Grouping data
Using AutoShow
Overview of PivotCharts
The PivotChart Wizard
Macros
  Recording a Macro
Running a Macro
Macro buttons
Collaboration
 

Working with Shared Workbooks
Reviewing Workbooks
Sending Workbooks
Tracking changes
Resolving conflicts
Merging Workbooks