Add EXL2 to my courses Excel Advanced (1 day - £245, plus VAT)

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

What-if analysis

Creating scenarios
Scenario summary reports
Protecting scenarios
Using Goal Seek
Using the Solver
Working with views

Pivot tables

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

Back to top

Macresource Business SoftWare Training Courses
Access training | Excel training | Access VBA training | Excel VBA training
Project training | Visio training | Outlook training | Windows XP training
FileMaker training | MySQL training | PowerPoint training | Word training
Free computer software tutorials | London computer training room hire

© Copyright, Macresource 2011