Microsoft Power BI

    Excel Topic 2: Next Steps with Macros Part 1

    Course Duration: 90 Minutes

    Target Audience:

    This session is intended for Excel users who wish to use VBA code to refine or adapt macros.

    Course Objectives:

    A macro is a recording of a step or a series of steps that can be run as many times as required. Use VBA to refine or adapt macros in order to suit specific requirements. Participants should have attended the Introduction to Macros webinar prior to attending.

    Course Outline:

    Course Introduction

    Recap on Introduction to Macros

    Using the VBA Editor

    Recognising Different Objects in VBA

    Using Dim to Define Objects

    Using Message Boxes to Prompt Users and Display Data

    Using Input Boxes to Capture Data

    Understanding the Visual Basic Editor Window

    Managing Program Control Statements

    Creating Iterative Loops

    Saving a File Using a Macro

    Discussion and Question Time

    View Schedule
    Contact Us