Course Name

Microsoft Excel 2016: Amazing Macros

  • Duration: 1 Day(s)
  • Date: 27 Sep, 2024
  • Price: R1, 643.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

This one-day course introduces Microsoft Excel users to creating and managing Excel macros. You will learn how to record macros, execute macros in variety of different methods, editing macros and creating a control button to activate the macros.

Course Objectives

You will:

  • Write a new macro.
  • Editing macro commands.
  • Create a custom button.
  • Using relative references.
  • Moving and sizing a macro button.
  • Assign a shortcut key to pasted macro

Course Content

  • Module 1 – Using Macros
    • Topic A: Define Macros
    • Topic B: Opening a Workbook Containing Macros
    • Topic C: Running a Macro Using a Shortcut Key
    • Topic D: Opening the Visual Basic Editor Window
    • Topic E: Using the Visual Basic Editor Window
  • Module 2 – Recording Macros
    • Topic A: Recording a Macro
    • Topic B: Assigning a Shortcut Key
    • Topic C: Using Relative References
    • Topic D: Deleting a Macro
  • Module 3 – Editing Macros
    • Writing a New Macro
    • Entering Macro Comments
    • Copying Macro Commands
    • Editing Macro Commands
    • Typing Macro Commands
    • Running a Macro from the Code Window
    • Using the Debugger
  • Module 4 – Custom Button in Quick Access Toolbar
    • Create a Custom Button
    • Adding a Button to Quick Access Toolbar
    • Change a Button Image
    • Delete a Custom Button
  • Module 5 – Adding Form Controls to Control Worksheet
    • Create a Macro Button
    • Copy a Macro Button
    • Assign Macro to Pasted Macro
    • Format a Macro Button
    • Rename a Macro Button
    • Moving/Sizing a Macro Button
    • Deleting a Macro Button
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

This one-day course introduces Microsoft Excel users to creating and managing Excel macros. You will learn how to record macros, execute macros in variety of different methods, editing macros and creating a control button to activate the macros.

Course Objectives

You will:

  • Write a new macro.
  • Editing macro commands.
  • Create a custom button.
  • Using relative references.
  • Moving and sizing a macro button.
  • Assign a shortcut key to pasted macro

Course Content

  • Module 1 – Using Macros
    • Topic A: Define Macros
    • Topic B: Opening a Workbook Containing Macros
    • Topic C: Running a Macro Using a Shortcut Key
    • Topic D: Opening the Visual Basic Editor Window
    • Topic E: Using the Visual Basic Editor Window
  • Module 2 – Recording Macros
    • Topic A: Recording a Macro
    • Topic B: Assigning a Shortcut Key
    • Topic C: Using Relative References
    • Topic D: Deleting a Macro
  • Module 3 – Editing Macros
    • Writing a New Macro
    • Entering Macro Comments
    • Copying Macro Commands
    • Editing Macro Commands
    • Typing Macro Commands
    • Running a Macro from the Code Window
    • Using the Debugger
  • Module 4 – Custom Button in Quick Access Toolbar
    • Create a Custom Button
    • Adding a Button to Quick Access Toolbar
    • Change a Button Image
    • Delete a Custom Button
  • Module 5 – Adding Form Controls to Control Worksheet
    • Create a Macro Button
    • Copy a Macro Button
    • Assign Macro to Pasted Macro
    • Format a Macro Button
    • Rename a Macro Button
    • Moving/Sizing a Macro Button
    • Deleting a Macro Button

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US