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

Anixter Ltd

"Very good, enjoyed the course!" "Interesting and enjoyable"

Bokomo Foods (UK) Ltd

"Informative & engaging" "Very good & well presented"

Bokomo Foods Ltd

"Very good, the trainer kept our attention throughout"

Car Shop Ltd

"It was very good & covered a number of areas relevant to my role"

"Very good, informative and fun!"

Microsoft Excel 2002 Training Course Advanced

You already know the basic operations in Excel. This Microsoft Excel advanced training course will introduce you to even more Excel functions, including conditional formatting and exporting Excel data as XML.

Other Excel training courses

Course Duration: 1 Day

Course Outline

Customizing your Workbook in Microsoft Excel 2000

  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Customize Menus
  • Customize Toolbars
  • Create a Macro
  • Edit a Macro
  • Group and Outline Structured Data

Working with Multiple Data Sources in Excel 2000

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links
  • Export Excel Data as XML
  • Import XML Data into Excel
  • Create a Web Query

Collaborating with Others Using Workbooks in Excel 2000

  • Protect your Worksheets
  • Protect Your Workbook
  • Share Your Workbook
  • Revise Tracking
  • Merge Workbooks
  • Track Changes

Enhancing Your Worksheet Using Charts in Excel 2000

  • Chart Non-adjacent Data
  • Modify Chart Items
  • Create a Trendline

Using Graphic Objects to Enhance your Worksheets in Excel 2000

  • Create Graphic Objects
  • Resize, Move, and Copy Graphic Objects
  • Change the Order of Graphic Objects
  • Group Graphic Objects
  • Format Graphic Objects
  • Insert Clip Art
  • Modify Clip Art

Advanced 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 Advanced