Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London
 
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

On Site Training

 
 
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, 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, e-learning, Worthing, 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.
 
 
 
Home On-site Training   Prices Client Feedback Software Shop About Contact  
Expertly tailored Microsoft Office training courses: Brighton, Worthing, Portsmouth, Chichester, Sussex, Surrey and London
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

Microsoft Excel Advanced Course

Microsoft Excel Advanced Course Overview

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 aquired 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 Beginner's 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 practice, step-by-step exercises. This will provide an excellent source of information and on-going self study once the training has been completed.

For pricing click here

To return to the application overview page click here

 
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 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

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