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

Free Training Materials
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
Web Design
& SEO
Graphic Design   Prices 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 2010, 2007, 2003, XP and earlier)

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 manuals and practise, 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.