Microsoft Power BI

    Excel Topic 1: Macros - An Introduction

    Course Duration: 90 Minutes

    Target Audience:

    This session is intended for Excel users who wish to record and run macros in Excel to automate certain processes.

    Course Objectives:

    This session will show you how to create and edit keystroke macros. The purpose of this session is to identify for the user’s opportunities to automate mundane repetitive tasks in Excel thus bringing new efficiencies to the day to day activities.

    Course Outline:

    Course Introduction

    What is a Macro and When to Use a Macro

    Where Macros are Stored or Saved

    Creating a Macro

    Running a Macro

    Editing a Macro

    Understanding the Visual Basic Editor Window

    Adding Comments to a Macro

    Adding a Macro to the Toolbar and to a Button in a Worksheet

    Discussion and Question Time

    View Schedule
    Contact Us