Microsoft Excel 2016
Course Code: AD806

This is a specialised course on the use of Macros within Microsoft Excel.  It is for experienced Excel users who want to produce professional spreadsheets using the most advanced features of the program.

After completing the course, participants will be able to:

  • Record, edit and run personal and workbook macros

  • Use absolute and relative references in Macros

  • Create a macro toolbar icon and add a macro button to a worksheet

  • Display Data Prompts

  • Use a conditional statement and a control loop in a macro

  • Place a drop-down list box and a check box on a worksheet

  • Use Visual Basic to Write Macros

What you will learn
Topics covered by this course include:

Creating and Using Personal Macros

  • Recording & Running a Personal Macro

  • Displaying Macro Instructions

  • Editing a Macro

  • Using Absolute & Relative References

Creating and Using Workbook Macros

  • Recording & Running a Workbook Macro

  • Adding a Macro Button to a Worksheet

Using Visual Basic to Write Macros

  • Opening a New Module in the Visual Basic editor

  • Displaying a Data Prompt

  • Using a Conditional Statement

  • Using a Control Loop in a Macro

  • Additional Control Statements

Placing Controls on a Worksheet

  • Placing a Combo Box List and Check Box on a Worksheet / Linking a Control to Data

Creating a Macro Toolbar Icon

  • Adding a Button to the Quick Access Toolbar

  • Assigning an image to a Macro Toolbar Button

Visual Basic Tips and Techniques

  • Using Copy and Paste procedures

  • Dealing with Errors

Course participants should have completed Excel 2016 Part 3 (or equivalent).

Dates and times
Please refer to your Fourth R centre for dates and times.

Copyright The Fourth R

 [Back to MS Office Training Courses]