Microsoft Excel Macros Training Courses in Manchester

Excel Macros training courses onsite at your own offices anywhere in Manchester

Course Objectives

This course covers automation and the customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items.

Who Should Attend

Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users’ work) in the application using macros.

Previous Excel Experience

Delegates should have a good grounding in Excel (any version) and be familiar with absolute Vs relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage. However, those wishing to learn or practice VBA itself should seek our 2 day Visual  Basic course.

Course Contents

Introduction and the Macro Recorder:

  • Introduction
  • Demonstration
  • Recording a macro
  • Recording a macro with absolute references
  • The personal macro workbook
  • Assigning shortcut keys
  • Deleting macros
  • Recording a macro with relative references

Objects and Dialog Boxes:

  • Introduction to objects
  • The object browser
  • Using the object browser and searching it
  • Built-in dialog boxes
  • User defined dialog boxes (message boxes and input boxes)

Introduction to Controls:

  • Worksheet controls
  • User forms

VBA Procedures Used:

  • IF…THEN…ELSE (Conditional Control Structure)
  • SELECT CASE (Branching)
  • The DO…LOOP control structure
  • The FOR…NEXT control structure

For more information on Excel Macros training courses in Manchester, you can call free on 0800 2922842. Alternatively please contact us using the quick form at the top of the page.