Blue Pecan Logo
 
 
Microsoft
Office Training
Excel Training Office 2010 Training Project Training Prices Client Feedback Contact
 
0800 612 4105 mail: info@bluepecan.co.uk
 
Onsite Microsoft Excel Training - we come to you!
Microsoft Office Training > Excel Training > Excel Intermediate Course
Excel 2010

Excel Intermediate Course

 

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.

The outline is only a suggestion and can be tailored to your business needs. To accompany the instructor lead training, each delegate will receive class notes that will provide an excellent source of information and on-going self study once the training has been completed. For pricing click here

Course Outline
Formulae
  • Conditional Functions
    • IF
    • Nested IF
    • SUMIF
    • COUNTIF
    • SUMIFS
    • COUNTIFS
  • Lookup Functions
    • VLOOKUP
    • HLOOKUP
  • Using Text Functions to clean and manipulate data
    • TRIM
    • TEXT
    • RIGHT
    • LEFT
    • MID
    • CONCATENATE
    • VALUE
  • TIME AND DATE Functions
    • DATE
    • NOW
    • DAY
    • MONTH
    • YEAR
    • NETWORKDAYS
  • Conditional 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
  • 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