Microsoft Office Courses, Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London
 
Microsoft Office Courses, Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London

On Site Training
 
Microsoft Office Courses, Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London

Web design

 

If you like this site, let us create a web site for you.

Contact us for a quote.
 
 
 
Microsoft Office Courses, Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London

Corporate portraits
 
Portraits for promotional material, web sites or just to decorate your office walls. See Kate's recent commissions.
 
 
 
Microsoft
Office Training		 SEO & Social Media Training   On-site Training Prices   Free Training
Materials 		Client Feedback About Contact
Microsoft Office Training throughout West Sussex & East Sussex, Surrey and Hampshire: Horsham, Brighton, Burgess Hill, Chichester, Crawley, Eastbourne, East Grinstead, Haywards Heath,, Lewes, Littlehampton, Dorking, Farnham, Godalming, Guildford,Redhill, Reigate, Weybridge Woking, Havant, Petersfield, Portsmouth, Southampton, Winchester, Tonbridge & Tunbridge Wells.
Microsoft Office Courses, Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London

Excel Intermediate Training
Microsoft Office Training > Excel Training > Excel Intermediate Training

Excel Intermediate Training Overview (Excel 2007, 2003, XP and earlier)

This Microsoft Excel Intermediate training course is designed to offer training for those that have know the basics of Microsoft Excel (see Basic Excel Training 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 manuals and practice, step-by-step exercises. This will provide an excellent source of information and on-going self study once the training has been completed.

Upgrade with Excel 2007 Intermediate Training

For pricing click here

To return to the Excel overview page click here

Excel Training in Sussex, Surrey, Hampshire and London
Formulae
  • Conditional Functions
    • Nested IF
    • IF OR
    • IF AND
    • SUMIF
    • COUNTIF
  • Lookup Functions
    • VLOOKUP
    • HLOOKUP
    • MATCH
    • INDEX
  • Condtional formatting using formulae
Workbook Consolidation
  • Using 3D formulae
  • Using data consolidation
Forms/Templates
  • Worksheet protection
  • Workbook protection
  • Data validation
  • Form controls
  • Creating a template
Database Work
  • Autofilters
  • Advanced filter
  • Pivot tables
  • Subtotals
  • SUBTOTAL function
  • Database Functiions - DSUM, DAVERAGE etc
  • Custom views

 
   

Home |   On-site Training  |   Prices   |   Client Feedback  |   About Us |   Contact Us  | UK Photography & Sussex Photography | Sitemap
Copyright (c) 2010 Blue Pecan. All rights reserved.