 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel XP 2002 Level 2; Intermediate
Course Aims
Microsoft Excel XP combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Readers will learn how to use multiple sheets and workbooks, work with charts, and learn about advanced functions and advanced formatting in MS Excel XP. |
Assumed Knowledge
Familiarity with basic features of MS Excel is required, gained either by previous experience or by reading our "Microsoft Excel XP 2002 Level 1; Introduction" course. |
Course Audience
Recent users of MS Excel 2002 (XP) who want to gain a good understanding of the software in a short space of time. |
|
Table of Contents
|
Using Multiple Sheets and Workbooks
|
Using Multiple Worksheets
|
|
Viewing and Arranging Multiple Worksheet Windows
|
|
Navigating in Multiple Workbooks
|
|
Selecting and Viewing Multiple Workbooks
|
|
Creating and Opening a Workspace
|
|
Managing Multiple Worksheets and Workbooks
|
|
Selecting Multiple Worksheets
|
|
Moving and Copying Data between Worksheets
|
|
Linking Data Between Worksheets
|
|
|
|
Charting
|
Specifying the Chart Source Data
|
|
Selecting a Chart Location
|
|
Moving and Resizing Chart Objects
|
|
Adding Data Series’ and Objects to a Chart
|
|
|
Advanced Functions
|
Creating and Using Functions
|
|
Working with Arguments: The PMT Function
|
|
Using Dates in Calculations
|
|
Identifying the Auditing Commands
|
|
Tracing and Correcting Worksheet Errors
|
|
|
|
Advanced Formatting
|
Using Comments in a Worksheet
|
|
Reviewing, Showing, and Hiding Comments
|
|
Redefining and Modifying Existing Styles
|
|
Creating Custom Number Formats
|
|
Applying a Conditional Format
|
|
|
|
|
|
