Excel 2007 Intermediate Course

Testimonials

Some feedback from courses in the last 18 months:

Very good helpful course

Heather Dentoom
Mitsui & Co Energy Risk Management Ltd
Excel Intermediate

Trainer extremely friendly, course excellent.

C.C
Excel Intermediate

The trainer was very helpful and patient with the group, going over things which people didn't understand. The course was easy to follow.

Amit Shah
Primelocation.com
Excel Intermediate

London and UK wide

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

Training formats available

on a public schedule at one of our London training venues
on-site at your company office UK wide
closed group at one of our London training venues
near-site at a location close to you
bespoke one-to-one basis
tailored training courses to your requirements

Who is this training course suitable for?

Our Microsoft Excel 2007 Intermediate course is suitable for those with a basic working knowledge of Excel.

Prerequisites

A working knowledge of Excel or our Excel Introduction course.

Benefits

This course is designed for those users who wish to step up their current knowledge of Excel to take advantage of the more complex features. To be able to create, edit and format large or multiple spreadsheets. Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment.

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

Course Syllabus

Working with Large Worksheets
Viewing options
- Adjusting zoom
- Using Freeze Panes
- Using Split Window
Hiding and displaying data
- Hiding rows and columns
- Creating an outline
Printing large worksheets
- Page Break preview
- Working with page breaks
- Printing multiple sheets

Working with Multiple
Worksheets and Workbooks
Using multiple worksheets
- Navigating between sheets
- Moving and copying sheets
Linking worksheets
- Creating 3-D formulas
- Consolidating data
Linking workbooks
- Creating a formula to link workbooks
- Using the Paste Link option
- Maintaining links

Working with dates
Entering date functions
- TODAY function
- NOW function
Date and time formats
Using dates in formulas

Conditional formulas and formatting
The IF function
Conditional formatting
- Based on a cell value
- Based on a formula
- Identifying cells with conditional formatting
- Copying conditional formats

List Management
Working with lists
- Structure of a list
Sorting and filtering lists
- Simple sorting
- Sorting by multiple columns
- Using AutoFilter
Advanced filtering
- Using custom filter
- Using Advanced Filter
Adding subtotals to a list

Documenting and Auditing
Comments
- Viewing, adding, editing and deleting comments
Auditing features
- Tracing formula errors
Protection
- Protecting a worksheet
- Protecting cell ranges

Using Templates
Built-in templates
- Accessing and using Excel’s templates
Creating and managing templates
- Creating, using and modifying a custom template file

Public Schedule - Pricing and Availability

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 2007 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Thu 18 Mar 2010	Bloomsbury	1		£224	£225
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2007	Tue 30 Mar 2010	Southwark	7		£193	£198
2007	Thu 8 Apr 2010	Bloomsbury	6		£192	£197
2007	Thu 15 Apr 2010	Limehouse	4		£212	£217
2007	Tue 20 Apr 2010	Bloomsbury	7		£207	£212
2007	Mon 26 Apr 2010	Bloomsbury	8		£172	£177
2007	Thu 6 May 2010	Bloomsbury	8		£202	£207
2007	Fri 14 May 2010	Bloomsbury	7		£167	£172
2007	Mon 24 May 2010	Southwark	6		£172	£177
2007	Tue 1 Jun 2010	Limehouse	8		£110	£115
2007	Thu 3 Jun 2010	Bloomsbury	9		£110	£115
2007	Fri 11 Jun 2010	Bloomsbury	6		£110	£115
2007	Thu 17 Jun 2010	Limehouse	8		£75	£80
2007	Wed 23 Jun 2010	Bloomsbury	8		£85	£90
2007	Tue 29 Jun 2010	Bloomsbury	9		£85	£90
2007	Tue 6 Jul 2010	Bloomsbury	6		£110	£115
2007	Thu 15 Jul 2010	Bloomsbury	8		£75	£80
2007	Fri 23 Jul 2010	Southwark	9		£75	£80
2007	Mon 2 Aug 2010	Bloomsbury	9		£75	£80
2007	Mon 9 Aug 2010	Bloomsbury	10		£75	£80
2007	Mon 16 Aug 2010	Bloomsbury	10		£75	£80
2007	Mon 23 Aug 2010	Bloomsbury	10		£75	£80
2007	Tue 31 Aug 2010	Bloomsbury	10		£75	£80
2007	Fri 10 Sep 2010	Southwark	10		£75	£80
2007	Fri 17 Sep 2010	Bloomsbury	10		£75	£80
2007	Mon 27 Sep 2010	Bloomsbury	10		£75	£80
2007	Thu 7 Oct 2010	Bloomsbury	9		£75	£80
2007	Fri 15 Oct 2010	Bloomsbury	8		£75	£80
2007	Mon 25 Oct 2010	Bloomsbury	10		£75	£80
2007	Wed 3 Nov 2010	Bloomsbury	10		£75	£80
2007	Fri 12 Nov 2010	Bloomsbury	10		£75	£80
2007	Mon 22 Nov 2010	Bloomsbury	10		£75	£80
2007	Mon 29 Nov 2010	Bloomsbury	10		£75	£80
2007	Tue 7 Dec 2010	Bloomsbury	10		£75	£80
2007	Wed 15 Dec 2010	Bloomsbury	10		£75	£80
2007	Thu 23 Dec 2010	Bloomsbury	10		£75	£80

"What do I get on the day?"

Microsoft qualified trainers with industry relevant experience
Modern air conditioned training suite, flat screen PC's, 1 per delegate
Lunch provided in a comfortable and relaxed setting
Comprehensive course material and files to take away
What do I get on the day? - More information

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.