Microsoft Excel 2000 Charting & Organising Data Course
Course Description
Students will probably get the most out of this course if they want to learn the skills and concepts necessary to begin using the charting and list-management capabilities of Excel 2000 or if they need to create charts to graphically represent worksheet data or to maintain and manage lists at their workplace. Students should have a basic knowledge of the concepts involved in using Excel 2000 worksheets. For example, they should be familiar with data types (text, numbers, and formulas) and the use of the menu system for copying data and for opening and saving files.
Students will learn how to represent data graphically and maintain and manage lists.
Course pre-requisites:
Students enrolling in this course should understand data types (text, numbers, and formulas) and the use of the menu system for copying data and for opening and saving files.
To ensure students’ success with this course, we recommend that they first take the following PTR courses or have equivalent knowledge:
Excel 2000: Worksheets
Topics covered on the 1 day Microsoft Excel 2000 Charting & Organising Data course
Creating Charts
Creating a Chart Sheet
Creating an Embedded Chart
Comparing Chart Sheets with Embedded Charts
Modifying Charts
Chart Types
Modifying Embedded Charts
Adding and Deleting Chart Items
Moving and Sizing Chart Items
Formatting a Chart
Formatting Chart Text
Formatting Labels
Formatting the Chart
Printing a Chart Sheet
Using Graphic Objects
Adding Graphic Objects
Formatting Graphic Objects
Using Graphic Objects to Enhance Worksheets and Charts
Sorting Data
Single-level Sorting
Multiple-level Sorting
Sorting Options
Importing Data
Design Considerations
Filtering Data
Filtering a List
Custom Criteria
Multiple-condition Criteria
Managing a Filtered List
Course Classification:
Course Fee = £250 (excl.VAT)
Scheduled course dates
| September 2010 | October 2010 | November 2010 | December 2010 | January 2011 |
| | | | |
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Excel Training and bespoke Microsoft Excel courses
Overview of Microsoft Excel