Computer Tutoring Logo
Est. 2002
Menu Button

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

Testimonials

Keronite PLC

"Great!!! Learned lots."

DHL Exel Supply Chain

"Training was delivered well and all my questions were answered very well."

Norfolk County Council

"Excellent."

Viridor Waste Ltd

"It was very good, I felt relaxed and was able to proceed at my own pace."

Microsoft Excel 2002 Training Course Intermediate

This Microsoft Excel training course will expand upon the skills you learned in the introduction training day and will give you an opportunity to work with some more advanced features of Excel, including templates; sorting and filtering; importing and exporting; advanced formulas; analysis tools; and collaboration.

Other Excel training courses

Course Duration: 1 Day

Course Outline

Working with Templates in Microsoft Excel 2002

  • Create a Workbook from an Excel Template
  • Create a Template
  • Create a Graphic
  • Create a Workbook from a User-defined Template

Sorting and Filtering Data with Excel 2002

  • Sort Data
  • Add Subtotals to a Worksheet
  • Filter Lists
  • Create and Apply Custom Filters

Importing and Exporting Data using Excel 2002

  • Import Data from the Web
  • Import Data from an External Source
  • Export Data
  • Save a Worksheet as a Web Page
  • Publish a Worksheet to the Web

Working with Advanced Formulas in Excel 2002

  • Share Data Among Worksheets
  • Create a Name for a Range of Cells
  • Use Functions to Create Advanced Formulas
  • Trace Cell Precedents
  • Trace Cell Dependents
  • Locate Errors in Formulas

Analyzing Data using Excel 2002

  • Create a PivotTable Report
  • Create a PivotChart Report
  • Create Scenarios
  • Use Solver
  • Use Goal Seek

Collaborating using Excel 2002

  • Insert and Edit a Hyperlink
  • Add and Edit Comments in a Worksheet
  • Create Discussion Comments
  • Respond to Discussion Comments

Intermediate Excel Prices from:

If you are interested in this course but want to know the price beforehand then use the the following form to calculate how much.

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.



Microsoft Excel 2002 Training Course Intermediate