Instructor-led training - Excel Windows London course
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Windows Excel course London & UK wide

Microsoft Excel 2000 Intermediate

Microsoft Excel 1 day instructor-led. Courses never cancelled: Guaranteed. From £75 (list price £225)

Training formats available

Who is this training course suitable for?

Our Microsoft Excel 2000 Intermediate course is suitable for those with a good basic knowledge of Excel's spreadsheets and features.

Prerequisites

Previous experience of working with Excel to create basic spreadsheets and make basic calculations or our Excel Introduction course.

Benefits

This course is designed for those users who need to expand their knowledge of Excel beyond the most basic functions and to understand and use some of the more complex features. By the end of this course you will be able to create, edit, and format large or multiple spreadsheets. Delegates will learn how to perform calculations and functions within a workbook, manipulate data lists and create custom charts. You will be able to make your spreadsheets easy to use, navigable and presentable.

After completing this course you will be prepared to attend the Excel Advanced training course.

Course Syllabus

Working with Large Worksheets
Viewing options
Hiding and displaying data
Printing large worksheets

Working with Multiple
Worksheets and Workbooks

Using multiple worksheets
Linking worksheets by using 3-D formulas
Consolidating data
Linking workbooks
Managing workbooks

Customising Excel
Changing options
Customising toolbars and menus

Advanced Charting
Chart formatting options
Creating combination charts
Using graphic elements Advanced Formatting
Borders and shading
Using special number formats
Working with dates
Working with styles
Other advanced formatting

List Management
Working with lists
Sorting and filtering lists
Advanced filtering

Documenting and Auditing
Comments and text boxes
Auditing features
Protection
Workgroup collaboration

Using Templates
Built-in templates
Creating and managing templates

Public Schedule - Pricing and Availability

Excel Intermediate 1 day course
Version Date Location Places
available
Book Next place rate (£)
Pay by
Card
Pay by
Invoice
2007 Mon 22 Mar 2010 Limehouse 3 Book now £224 £225
2003 Tue 23 Mar 2010 Southwark 5 Book now £199 £204
2007 Thu 25 Mar 2010 Rochester (Hoo) 0 FULL    
2003 Fri 26 Mar 2010 Limehouse 4 Book now £224 £225
2007 Tue 30 Mar 2010 Southwark 5 Book now £199 £204
2003 Thu 1 Apr 2010 Bloomsbury 4 Book now £207 £212
2003 Wed 7 Apr 2010 Limehouse 4 Book now £224 £225
2007 Thu 8 Apr 2010 Bloomsbury 5 Book now £199 £204
2003 Mon 12 Apr 2010 Southwark 7 Book now £187 £192
2007 Thu 15 Apr 2010 Limehouse 4 Book now £212 £217
Full Schedule: See all 77 Excel Intermediate course dates.
Bookings currently available until 23rd December 2010.

"What do I get on the day?"

What is Microsoft Excel?

Microsoft Excel is a popular computer program that allows you to create and edit spreadsheets. These are used to store information in columns and rows that can then be organised and/or processed. Spreadsheets are designed to work well with numbers but often include text.


Rate this page:
3.8/5 (8 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Association of Computer Trainers verified by visa, mastercard securecard