How to Record and Run a Macro in 4 Easy Steps

Harness the power of automation in Excel by recording a Macro in 4 easy steps!
Rating: 4.1 out of 5 (609 ratings)
11,673 students
How to Record and Run a Macro in 4 Easy Steps
Rating: 4.1 out of 5 (610 ratings)
11,673 students
How to record and run a macro
When and why macros don’t always work
How to resolve basic macro issues
Why macros can save time, reduce errors and automate basic tasks
How macros can be used to send emails, create PowerPoint presentations and even write Word reports
Why macros can also be very dangerous and what to be careful of when using macros

Requirements

  • Have basic Excel knowledge
Description

Learn how to harness the power of automation in Excel by recording a Macro in 4 easy steps!

Learn:

  • How to record and run a macro
  • When and why macros don’t always work
  • Why macros can save time, reduce errors and automate basic tasks
  • Why macros can also be very dangerous and what to be careful of when using macros



    Who this course is for:
    • Anyone who wants to learn how Macros in Excel are recorded and run
    Curriculum
    7 sections • 14 lectures • 36m total length
    • Introduction
    • Recording a Macro
    • Enabling the Developer Tab
    • Step 1: Clicking Record
    • Step 2: Recording your Macro
    • Step 3: Clicking Stop and Saving your Macro
    • Step 4: Running Your Macro
    • Where to use a Macro?
    • Create a Macro Example - Formatting a Report
    • Create a Macro Example - Filtering Data
    • Where to from here?
    • Test your Excel macros knowledge!
    • Bonus Lecture: User Defined Functions Intro
    • Bonus Lecture: User Defined Functions Walkthrough
    • Introducing the Excel Object Model

    Instructor
    Entrepreneur | Engineer | CFA® charterholder
    Matthew Bernath
    • 4.2 Instructor Rating
    • 1,150 Reviews
    • 20,367 Students
    • 4 Courses

    Matthew is an entrepreneur, engineer, CFA® charterholder, trainer and Excel addict with a love for finance, data science, process optimisation, data visualisation and building businesses.

    As a qualified engineer, Matthew has consulted to five of the largest South African banks and numerous corporates and parastatals on a number of technology, dashboard, strategy, risk, training, financial modelling and process re-engineering engagements. He has provided Excel and Financial Modelling training to four of the largest banks in South Africa, and runs regular, highly rated in-house and public Excel, VBA, Financial Modelling and Dashboards training courses. With practical insight and a broad client base, Matthew has never been rated less than 5 out of 5 for subject matter expertise.