Instructor-led training - excel 2007 intermediate course
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in
Home Course details Training formats Pricing FAQ Clients Book online Online schedule (live) Forum Contact us
 
spacer Customer account
At a glance
 
spacer New booking
Choose courses
 
spacer Enquiries
Contact usTraining vacancies
 
spacer Information
Pricing and availabilityExcel 2007 IntermediateForumHints and tipsLocation/map/parking
 
spacer Training
Public schedule On-site training Closed company E-Learning
 
spacer Pricing
Public schedule On-site training Closed company E-Learning

Excel 2007 Intermediate Course

London and UK wide

Microsoft Excel 1 day instructor-led, courses never cancelled, from £75 (list price £225)

Training formats available

Currently demand for public schedule is growing slowly and dates will be scheduled accordingly.

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

Excel Intermediate 2007 1 day course List price £225
Version Date Location Places
available
Book Next place rate:
Card Invoice
2007 2008 May 19 Mon Bloomsbury 0 FULL    
2007 2008 Jun 19 Thu Bloomsbury 1 book now £224 £224
2007 2008 Jun 26 Thu Bloomsbury 5 book now £212 £224
2007 2008 Jul 8 Tue Bloomsbury 4 book now £224 £224
2007 2008 Jul 29 Tue Bloomsbury 7 book now £185 £224
2007 2008 Aug 12 Tue Bloomsbury 6 book now £185 £224
2007 2008 Sep 26 Fri Bloomsbury 7 book now £75 £224
2007 2009 Jan 13 Tue Bloomsbury 8 book now £75 £224
2007 2009 Feb 10 Tue Bloomsbury 8 book now £75 £224
2007 2009 Mar 10 Tue Bloomsbury 8 book now £75 £224
2007 2009 Apr 14 Tue Bloomsbury 8 book now £75 £224
2007 2009 May 12 Tue Bloomsbury 8 book now £75 £224
2007 2009 Jun 9 Tue Bloomsbury 8 book now £75 £224
2007 2009 Jul 14 Tue Bloomsbury 8 book now £75 £224
2007 2009 Aug 11 Tue Bloomsbury 8 book now £75 £224
2007 2009 Sep 15 Tue Bloomsbury 8 book now £75 £224
2007 2009 Oct 13 Tue Bloomsbury 8 book now £75 £224
2007 2009 Nov 10 Tue Bloomsbury 8 book now £75 £224

"What do I get on the day?"

  • Microsoft certified 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.

Institute of IT Training - Accredited Training Provider Institute of IT Training - Accredited Training Provider Prodigy Platinum Learning Partner Microsoft Office Specialist Authorised Testing Centre

Microsoft Registered Partner
microsoft office
ms office project server

Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
microsoft+access+training · access courses in london

Training Information