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

The Frank Lee Centre

"Really Good. I felt very at ease and comfortable considering it was only me, and I actually enjoyed it!"

EasyJet Airline Company

"Very helpful."

"Excellent course- Well prepared, well delivered."

Lotus Cars

"Great- would Recommend."

Greenfinch

"A very flexible course, the trainer adapted the course to our specific needs."

Microsoft Excel 2003 Training Course Intermediate

Can you use Excel for a Database? How do I create different types of charts? What do I need to so to link them to Microsoft Word or Microsoft PowerPoint?

In the Introduction training course to Excel 2003, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Other Excel training courses

Course Duration: 1 Day

Course Outline

Creating and Applying Templates using Microsoft Excel 2003

  • Create a Workbook from a Template
  • Create a Custom Template
  • Working with Comments
  • Create a Hyperlink
  • Use Web-based Research Tools

Creating and Modifying Charts with Excel 2003

  • Create a Chart
  • Format Chart Items
  • Change the Chart Type
  • Create a Diagram

Working with Graphic Objects in Excel 2003

  • Insert Graphics
  • Create AutoShapes
  • Format Graphic Objects
  • Change the Order of Graphic Objects
  • Group Graphic Objects
  • Move, Copy, and Resize Graphic Objects

Calculating with Advanced Formulas in Excel 2003

  • Create and Apply a Name for a Range of Cells
  • Calculate Across Worksheets
  • Calculate with Date and Time Functions
  • Calculate with Financial Functions
  • Calculate with Statistical Functions
  • Calculate with Lookup and Reference Functions
  • Calculate with Logical Functions

Sorting and Filtering Data using Excel 2003

  • Sort Data Lists
  • Filter Data Lists
  • Create and Apply Advanced Filters
  • Calculate with Database Functions
  • Add Subtotals to a Worksheet

Using Excel 2003 with the Web

  • Export Excel Data
  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query

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 2003 Training Course Intermediate