Skip to main content
by learnformula
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
  1. Courses
  2. /Office Productivity
  3. /MS Excel

Level Up Your Excel Skills: Macros

Stop wasting time on repetitive tasks by building your own Excel robots to automate your daily workflow.

Created byBilly Wigley
BeginnerUpdated Oct 27, 2026
Level Up Your Excel Skills: Macros

What You'll Learn

  • check_circleExplain how macros and VBA automate repetitive Excel tasks.
  • check_circleRecord and save a macro in an XLSM working copy.
  • check_circleRun macros using a keyboard shortcut, shape, Form Control button, and Quick Access Toolbar.
  • check_circleDistinguish between absolute and relative macro recording.
  • check_circleInsert AI-generated VBA into a module and edit a worksheet reference and RGB fill values.
  • check_circleRecord a formatting macro that reproduces the supplied customer-sheet example.

About This Course

Learn to automate repetitive Excel tasks with recorded macros, then explore a practical introduction to AI-assisted VBA. Billy “Mr. Aloha” Wigley guides you through recording a macro, saving your working file, assigning macros to shapes, buttons and the Quick Access Toolbar, and using relative references.

In the bonus demonstration, you generate a small VBA procedure with ChatGPT and edit its worksheet reference and fill color. Practice throughout with one master workbook, then apply your skills to the supplied customer-data formatting project. The course contains approximately 50 minutes of video, plus your own practice time.

Topics Covered:

  • Macro recording and execution
  • Visual Basic for Applications basics
  • Developer tab configuration
  • Absolute versus relative macro references
  • Macro assignment to interface elements
  • VBA code generation with artificial intelligence
  • Macro-enabled workbook file formats

Audience:

Excel users who want to automate routine tasks and are comfortable navigating and formatting worksheets.

Your Instructor

Billy Wigley

AI & Excel Productivity Expert

menu_book2 courses

Billy “Mr. Aloha” Wigley is a practical AI and Excel productivity expert, Microsoft Certified Trainer, and the educator behind DontGetMadGetSkills.com. Teaching online since 2013, Billy helps individuals and businesses turn learning into practical skills they can use at work. His warm Aloha spirit, clear explanations, and hands-on approach make learning approachable and engaging. Through Don’t Get Mad…Get Skills!, he helps learners work smarter, build confidence, and achieve their potential through careful planning, training, and inspiration.

Credit Information

What Students Are Saying

0.0 out of 5
Student's Choice
0 reviews

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(581 reviews)
    2.5 CPD hrs
  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(497 reviews)
    2 CPD hrs
  • Ethics: Ethics for Accountants

    AI, Ethics, and the Professional Accountant 2025

    starRated4.9out of 5,(2342 reviews)
    3 CPD hrs