CONTENT
Review and Refreshing
Conditional Formatting
Charts - Creation/Customisation
Database and List Management
Building and Maintaining a List
Using Form to Add, Change & Delete Records
Sorting Lists
Use Filters to Analyse a List
Use Sub-totals
Introduction to MS Query
Data Sources and Tables
Choosing and Arranging Fields
Sorting the Result Set
Filtering
Performing Calculations
Joining Tables
Using the Pivot Table Wizard
Pivot Table basics
Hiding & Showing Details
Grouping Items
Grand Totals, Subtotals
Analysing Data
Functions
The Scenario Manager
Goal Seek
Solver
Printing and Presenting
Advanced Printing
Using Report Manager
Workbooks and Windows
Working with Workbooks
Linking
| 