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

Microsoft Excel Advanced Training

Microsoft Office Training > Excel Training > Excel Advanced Training Training

Microsoft Excel Advanced Training Overview (Excel 2010, 2007, 2003, XP and earlier)

This 1 day Microsoft Excel advanced course is designed for those that need to automate aspects of Excel's functionality with the use of Macros. 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 Interemdiate 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 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 the Excel 2007 Advanced Training Course

For pricing click here

To return to the application overview page click here

Excel Training in Sussex, Surrey, Hampshire and London

 
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
 Introduction to VBA
  • Navigating the VB editor
  • Creating procedures
  • Copying code between macros
  • Calling macros in a separate procedure
  • User defined functions
  • Userforms
  • Message boxes
  • Input Boxes
  • IF structures
  • Select Case structures

 

   

Home |   On-site Training  |   Prices   |   Client Feedback  |   About Us |   Contact Us  | UK Photography & Sussex Photography | Sitemap

Copyright (c) 2010 Blue Pecan. All rights reserved.