 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2002 (XP) Professional
Course Aims
This course will give readers the ability to analyze and manipulate data and to share workbooks in a team workgroup environment. Readers will learn how to audit and analyze data using outlines, PivotTables, Goal Seek, Solver and Scenario Manager and to use the workgroup features of Excel 2002. |
Assumed Knowledge
Readers should have the ability to create, format and print workbooks incorporating advanced formulae and custom formatting and be able to import and export data in different formats. |
Course Audience
Users with a basic understanding of Microsoft Excel 2002 who want to consolidate and expand on their knowledge of the basic features in a short space of time. |
|
Table of Contents
|
Auditing a worksheet
|
Apply data validation rules and display user prompts
|
|
Work with the Auditing toolbar
|
|
Trace precedents and dependants
|
|
Use the Formula Error Checker
|
|
Use the Formula Evaluator to obtain results in part of a formula
|
|
Use the Watch Window to view results in cells
|
|
Display formulae in worksheet cells
|
|
|
|
Working with data lists
|
Perform single and multi-level sorts
|
|
Apply a filter to a data list
|
|
Use a form to view, sort and enter records
|
|
|
|
Data management
|
Extract data using advanced filters
|
|
Group and subtotal data using the outlining tools
|
|
Use Dfunctions to perform calculations on a data list
|
|
Understand and work with a data source
|
|
|
|
PivotTables and PivotTable Charts
|
Analyse data using a PivotTable
|
|
Create a PivotChart report
|
|
Use PivotTable AutoFormat
|
|
Create PivotTable Lists for the web
|
|
Add fields to a PivotTable using a web browser
|
|
|
Using analysis tools
|
Use one- and two-input data tables to resolve What-If? calculations
|
|
Solve a problem using Goal Seek
|
|
Use Solver to calculate complex problems
|
|
Create What-If analyses using the Scenario Manager
|
|
|
|
Sharing workbooks
|
Create, edit and remove a comment
|
|
Apply and remove worksheet and workbook protection
|
|
Apply and remove file passwords
|
|
Track changes and resolve conflicting changes
|
|
Route a workbook by email for review
|
|
|
|
Creating diagrams in Excel
|
Build an organisation chart
|
|
Modify an organisation chart
|
|
Create and modify a diagram
|
|
|
|
|
Glossary
|
|
|
|
|
