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 (690 ratings)
12,270 students
How to Record and Run a Macro in 4 Easy Steps
Rating: 4.1 out of 5 (690 ratings)
12,270 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
    Course content
    7 sections • 14 lectures • 36m total length
    • Introduction
      01:19
    • Recording a Macro
      02:43
    • Enabling the Developer Tab
      00:39
    • Step 1: Clicking Record
      02:47
    • Step 2: Recording your Macro
      03:41
    • Step 3: Clicking Stop and Saving your Macro
      00:50
    • Step 4: Running Your Macro
      01:54
    • Where to use a Macro?
      02:05
    • Create a Macro Example - Formatting a Report
      08:17
    • Create a Macro Example - Filtering Data
      02:44
    • Where to from here?
      02:31
    • Test your Excel macros knowledge!
      4 questions
    • Bonus Lecture: User Defined Functions Intro
      00:48
    • Bonus Lecture: User Defined Functions Walkthrough
      02:44
    • Introducing the Excel Object Model
      03:42

    Instructor
    Entrepreneur | Engineer | CFA® charterholder
    Matthew Bernath
    • 4.1 Instructor Rating
    • 1,280 Reviews
    • 21,618 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.