Site Network: Main Site | Client Login | Trainer Login

Your Shopping Cart is Empty.
  

1 day course

Excel 2000 Intermediate

Further data entry techniques

  • Creating and editing a comment
  • The AutoComplete feature
  • Using data validation

Additional formatting techniques

  • Using conditional formatting
  • Shrinking text

Customising the work area

  • Working with existing toolbars
  • Using custom toolbars
  • Creating and using styles
  • Using templates

Formula construction

  • Using names
  • The IF function COUNTIF

Pivot tables

  • Creating and working with pivot tables
  • Grouping and summarizing data in a pivot table

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 and numbers
  • Formatting labels
  • Formatting the chart
  • Printing a chart sheet

Sorting data

  • Single-level sorting
  • Multiple-level sorting
  • Sorting options
  • Design considerations

Filtering data

  • Filtering a list
  • Custom criteria

Overview

Students will learn the skills and concepts necessary to work with intermediate features of Excel 2000.

Prerequisites

Excel 2000 Introduction, or equivalent knowledge.

Benefits

Students will learn how to validate data, customise toolbars, use advanced formulas, create pivot tables, create charts from spreadsheet data, and sort and filter data.

Target student

Students should already understand the basic concepts involved in using Excel 2000. For example, students should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.

What's next

Excel 2000 Advanced is the third course in this series.

Private Training Courses

We offer private training courses which may be delivered at our training centre or at your premises on dates to suit you and your delegates. Course content can follow the standard course material as listed in the course outline, or can be tailored to your specific requirements at no extra cost.

For a single company private course we normally recommend that any class does not exceed 8 delegates in order to ensure that the learning objectives are met.

Total price per day (ex-Vat)
Number of delegates 1 2 3 4 5 6 Extra Person
At our Reading Training Centre £495 £545 £595 £645 £695 £745 £50
On your premises £445 £495 £545 £595 £645 £695 £50

 

For on-site courses only:

  • Notebook computer hire is £40 per computer per day. Savings can be made for block bookings of 2 or more days, please ask for details.
  • Trainer travel and accomodation is charged at cost and we can give you a fixed price quote for this prior to booking.

Course fees are payable in advance and are listed exclusive of VAT.