Designed for those already familiar with basic Excel concepts and spreadsheet use.
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
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
Creating scenarios
Scenario summary reports
Protecting scenarios
Using Goal Seek
Using the Solver
Working with views
Overview of PivotTables
The PivotTable Wizard
Formatting PivotTables
Rearranging PivotTables
Sorting data
Grouping data
Using AutoShow
Overview of PivotCharts
The PivotChart Wizard
Recording a Macro
Running a Macro
Macro buttons
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