Blue Pecan Logo
Office Training
Excel Training Office 2010 Training Project Training Prices Client Feedback Contact
0800 612 4105 mail:
Onsite Microsoft Excel 2007 Training - we come to you!

Microsoft Office Training > Office 2007 Training > Excel 2007 Intermediate

Excel 2007

Excel 2007 Intermediate Training


This Microsoft Excel course is designed to offer training for those that know the basics of Microsoft Excel (see beginners' course), but want to fill in the gaps in their knowledge. The outline is only a suggestion and can be tailored to your business needs.

To accompany the instructor lead training, each delegate will receive course notes which will provide an excellent source of information and on-going self study once the training has been completed.

To view the Office 2007 shared features topics click here.
To view Excel 2007 upgrade topics click here.

For pricing click here

Course Outline
  • Conditional Functions
    • IF
    • Nested IF
    • SUMIF
    • SUMIFS
  • Lookup Functions
  • Using Text Functions to clean and manipulate data
    • TRIM
    • TEXT
    • RIGHT
    • LEFT
    • MID
    • VALUE
  • TIME AND DATE Functions
    • DATE
    • NOW
    • DAY
    • MONTH
    • YEAR
  • Conditional formatting using formulae
Workbook Consolidation
  • Using 3D formulae
  • Using data consolidation
  • Worksheet protection
  • Workbook protection
  • Data validation
  • Form controls
  • Creating a template
Database Work
  • Autofilters
  • Advanced filter
  • Pivot tables
  • Subtotals
  • SUBTOTAL function
  • Database Functions - DSUM, DAVERAGE etc
  • Custom views


Onsite Microsoft Office Training

Microsoft Office Computer Training Courses throughout Surrey, Sussex, Hampshire, Kent, Essex, Berkshire, Buckinghamshire, Dorset, Hertfordshire, Oxfordshire, Wiltshire and London including Crawley, Brighton, Portsmouth, Southampton, Winchester, Farnham, Guildford, Basingstoke, Salisbury, Bournemouth, Poole, Dorchester, Tunbridge Wells, Ashford, Canterbury, Maidstone, Gravesend, Croydon, Kingston-upon-Thames, Reading, Newbury, Oxford, Watford, Hemel Hempstead, Dartford, Stevenage, Milton Keynes, Basildon, Chelmsford, Southend on Sea and Colchester.



Copyright (c) 2013 Blue Pecan. All rights reserved. Sitemap