Microsoft Excel Level 5

Course Outline

A 1 day Introduction to Microsoft Excel Macros

  • What is a Macro?
  • Recording a Macro
  • Running a Macro
  • Relative References
  • Assigning a Macro to a Button on a Worksheet
  • Assigning a Macro to a Button on a Toolbar
  • Button Image Editor

Editing Macros

  • The Visual Basic Editor
  • The Project Explorer
  • The Code Window
  • Procedures
  • Inserting Comments
  • Printing a Visual Basic Module

The Range Object

  • What is the Range Object?
  • The Cells Property
  • The Range Property
  • Flexible Ranges
  • Range Contents

Workbooks and Sheets

  • Activating a Workbook
  • Activating a Worksheet

Debugging and Error Trapping

  • What are Errors?
  • Types of Error
  • Break Mode
  • Instant Watch

Objects, Properties and Methods

  • Controlling Objects with their Properties
  • Performing Actions with Methods
  • Performing Multiple Actions on an Object

Variables and Constants Control Structures

  • Conditional Control Structures
  • Looping Control Structures
  • Non-Structured Statements
  • Subprocedures

Controls, Dialogue Boxes and Forms

  • Built-In Dialogue Boxes
  • Predefined Dialogue Boxes
  • Toolbars and Display

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh

For a more comprehensive range of Visual Basic Training courses please visit www.visualbasictraining.co.uk

We have a range of specialist Excel Programming training options over one or two days for varying levels of experience.

Click here for more details.

“Professional Microsoft Excel Training in Scotland”