Excel advanced
Short course
In Abingdon
Description
-
Type
Short course
-
Location
Abingdon
-
Duration
1 Day
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.
Facilities
Location
Start date
Start date
Reviews
Course programme
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.
Excel advanced