Learning Outcomes
By the end of this course students will be able to:

Report on data in a list
Edit and analyse complex data using productivity features
Incorporate complex built-in functions into a worksheet
Record macros to automate standard procedures

Method
This course is provided as hands on and includes and extensive workshop manual and data disk for use during the course.

Section One

Create a spreadsheet with data tracking
Reporting on lists using Pivot Tables
Applying Excel functions: IF, SUMIF, COUNTIF, AND, OR, ISBLANK, ISERROR, VLOOKUP, HLOOKUP, MATCH, ISTECT

Section Two

Creating and using names
Storing sets of data as scenarios
Manipulating data using outlining
Storing different data displays using views
Printing your scenarios and views

Section Three

Recording and running a macro
Attaching macros to buttons, toolbars and menu's
Solving "What If" problems using Goal Seek, Solver
Data tables

Appendix

Map data
Extracting data from a list or database using Microsoft Query
Add-ins manager
Array Formulae
More functions explained:
Database functions
Statistical functions
Analysis Toolpak
Tips when using Excel