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

Excel Advanced Course


This 1 day Microsoft Excel advanced course is designed for those that need to explore functions to a more in depth level and also need to automate aspects of Excel's functionality with the use of Macros. Some basic computer programming skills will be acquired during this course so a very good level of computer literacy is needed together with a good grasp of the Excel themes covered in the Beginners' and Intermediate Excel courses.

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
Advanced Functions
  • IF OR and IF AND
  • Two way look ups using VLOOKUP and MATCH
  • Combining IF and VLOOKUP
Pivot Tables
  • Preparing data
  • Understanding a Pivot Table layout
  • Formatting data
  • Grouping items
  • Filtering data in the PivotTable
  • Inserting calculated fields
  • Changing calculation options
  • Creating PivotCharts
  • Use Slicers (Excel 2010)
What is a Macro?
  • Command macros
  • Function macros
  • Recorded macros
  • Written macros
Good Practise
  • Good practise
  • Naming a macro
  • Macro security
  • Macro storage
  • Editing a recorded macro using VBA
  • Relative vs absolute recording mode
 Running a Macro
  • Shortcut keys
  • Macro button
  • Custom Toolbar
  • Custom Menu
  • Automatically on workbook opening/closing


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