Instructor-led training - excel 2007 advanced 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 AdvancedForumHints 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 Advanced Course

London and UK wide

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

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 Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

Prerequisites

A working knowledge of Excel or our Excel Intermediate course.

Benefits

At the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.

Course Syllabus

Using logical functions
Naming ranges
- Creating named ranges
- Using named ranges in formulas
The IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions

Working with lookups
The VLOOKUP function
The HLOOKUP function

Advanced list management
Using data validation
- Setting criteria for entry of text, values and dates
- Creating a dropdown list
Using database functions
- Setting up criteria
- DSUM
- DAVERAGE
- DCOUNT

PivotTables and PivotCharts
Using the PivotTable Wizard
Rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts

Using analytical options
Using Goal Seek
Using the Solver add-in
Working with scenarios
- Creating and saving scenarios
- Viewing scenarios

Macros
Creating macros
Using the macro recorder
Viewing and editing macro VBA code

Public Schedule - Pricing and Availability

Excel Advanced 2007 1 day course List price £245
Version Date Location Places
available
Book Next place rate:
Card Invoice
2007 2008 May 20 Tue Bloomsbury 7 book now £218 £240
2007 2008 Jun 20 Fri Bloomsbury 3 book now £240 £245
2007 2008 Jun 27 Fri Bloomsbury 8 book now £201 £240
2007 2008 Jul 9 Wed Bloomsbury 5 book now £235 £240
2007 2008 Jul 30 Wed Bloomsbury 7 book now £207 £240
2007 2008 Aug 13 Wed Bloomsbury 5 book now £218 £240
2007 2008 Sep 29 Mon Bloomsbury 6 book now £75 £240
2007 2009 Jan 14 Wed Bloomsbury 8 book now £75 £240
2007 2009 Feb 11 Wed Bloomsbury 8 book now £75 £240
2007 2009 Mar 11 Wed Bloomsbury 8 book now £75 £240
2007 2009 Apr 15 Wed Bloomsbury 8 book now £75 £240
2007 2009 May 13 Wed Bloomsbury 8 book now £75 £240
2007 2009 Jun 10 Wed Bloomsbury 8 book now £75 £240
2007 2009 Jul 15 Wed Bloomsbury 8 book now £75 £240
2007 2009 Aug 12 Wed Bloomsbury 8 book now £75 £240
2007 2009 Sep 16 Wed Bloomsbury 8 book now £75 £240
2007 2009 Oct 14 Wed Bloomsbury 8 book now £75 £240
2007 2009 Nov 11 Wed Bloomsbury 8 book now £75 £240

"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