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.
I would like to receive training special offer emails
I would like to be notified about free software hints and tips

Testimonials

Motorplus

"Good fun easy to learn and great trainer very friendly and approachable"

Julian Support

"Thought the training from Alan at Computer Tutoring was excellent. The pace of the training was perfect and very relaxed and the content just right. We covered a lot of information during the Introduction Training Course on Microsoft Excel during the day but I didn't feel overloaded at anytime. I already use excel on a regular basis but have never had any formal training and picked up a lot of tips on how to do tasks in a much more efficient way as well as learning some things I didn't know at all! Thanks very much!"

Seven Telematics

"Informative, clear, precise, good instruction. It was broken down in to easy bite sized chunks."

Frutarom UK Ltd

"Excellent training, very patient and informative. A structured approach and easy to follow manual."

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.

I would like to receive training special offer emails
I would like to be notified about free software hints and tips





Microsoft Excel 2002 Training Course Intermediate