Excel Advanced
This course is to give the user the advanced principles of using Excel 2007. Can be preceded by the two one day courses entitled Excel 2007 Foundation and Excel 2007 Intermediate.
Click on a location to see available dates, read more details and to register your interest:
Course outline
Working with Lists
Sort data; Query from a list; List functionality; Extract data; Use filters; Use data validation; Use conditional formatting; Perform multi-level sorts; Database functions.
Analysing Data
Consolidate multiple lists; Use Goal Seek and Scenarios.
Auditing Worksheets
Check and review data; Find cells that are referred to in a specific formula; Find formulas that refer to a specific cell; Find errors.
Customising Reports
Use PivotTables; PivotChart reports.
Importing and Exporting Data
Import from other applications; Export to other applications.
Templates
Work with existing templates; Create templates; Edit templates.
Macros
Create and modify simple macros.