Masters in Training - computer training in Bradford, West Yorkshire, England
   Masters in Training provides a wide range of both Microsoft applications training and technical training
*
You must have Java enabled to view these news headlines
Masters in Training provides a wide range of both Microsoft applications training and technical training
Back to our Home Page
Check out details of all our courses - both applications training and technical training
Here's the timetable for all of our applications training courses
Details of our Partners
All about Masters in Training - meet the team, find out where we are located
Use our handy online contact form. Plus all our other contact details
Links to other useful web sites to help you plan and manage your training activities
Hints and tips to make your training management more productive

  

 

Excel 2000 Charting & Organising

Duration: 1 day

Overview
Students will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel 2000. This course meets the Microsoft Proficiency Guidelines for Excel 2000 at the Expert level.

Prerequisites: Windows 98: Introduction and Excel 2000: Worksheets, or equivalent knowledge.

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  1. Create charts that graphically represent worksheet data.
  2. Modify charts.
  3. Customize charts by applying formatting.
  4. Enhance worksheets and charts by using the drawing tools to add graphic objects.
  5. Sort information in a list by using the Data, Sort command.
  6. Locate information quickly in a list that meets specified conditions by using the
  7. Advanced filter feature.

Course Content

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

 

Click here to return to Application Training

 

 
  *  
   


[Home | Courses | Course Calendar | Our Partners ]
[ About us | Contact Us | Useful Web Links | Useful Info ]

Masters in Training Techniques Ltd
Merchants House, 19 Peckover Street, Little Germany, Bradford BD1 5BD, England

Email: admin@masters-in-training.co.uk
© 2001 Masters in Training Techniques Ltd.

Carefully crafted by Ian Traynor of Business Link for West Yorkshire