Personal Effectiveness & Well-Being

Excel VBA & Macros: Automate Your Spreadsheets

Instructor: Cognosco Learning · Duration: Full Day, 9:00 AM–5:00 PM · In-Person
One-day, in-person course — $795 per person · 3–4 seats save 10% · 5+ seats save 20%

Excel VBA & Macros: Automate Your Spreadsheets

About This Course

Some spreadsheet work should be done by hand, once, with your full attention. And some of it should never be done by hand again: the same header formatted the same way every Monday, the same forty rows checked against the same rule every Friday, the same summary copied to the same sheet every month-end.

This course teaches you to hand that work to Excel itself, through macros and the Visual Basic for Applications (VBA) language they are written in. You will record macros, open the editor where their code lives, read and rewrite that code, and then write your own — procedures that decide, repeat, ask, recover from errors, and run at the click of a button you placed on the sheet yourself.

What You'll Learn

What you will learn

  • Record, run, save, and re-find macros, in workbooks that keep their code
  • Work inside the VBA editor and read recorded code well enough to edit it with confidence
  • Use variables, constants, and data types so code works with named values instead of fixed ones
  • Refer to cells, ranges, worksheets, and workbooks in code, precisely and without relying on what happens to be selected
  • Write decisions and loops so one procedure does the checking and repeating you used to do by hand
  • Build procedures and custom functions that divide big jobs into named, reusable steps
  • Handle errors and debug code systematically instead of by guesswork
  • Give macros a usable face — buttons, messages, and simple questions — and automate workbooks that react when they open
  • Organise, document, and share macro workbooks, and judge macro security and trust with clear eyes

What's Included

  • A full day of in-person learning — 9:00 AM–5:00 PM, seven learning hours — led by a Cognosco Learning instructor
  • A printed participant manual for every attendee
  • All course materials, exercises, and practice scenarios
  • Guided practice and small-group work throughout the day
  • Group savings built in: 3–4 seats save 10%, 5+ seats save 20%

How the Day Runs

1

9:00 AM – 5:00 PM

A full day in the room — seven learning hours — led by a Cognosco Learning instructor.

2

Practice, not lectures

Guided practice and small-group work throughout the day, with all course materials, exercises, and practice scenarios provided.

3

Take it with you

A printed participant manual for every attendee — yours to keep, and to keep working from after the day.

Who It's For

Individuals who want to work, and live, with more focus, resilience, and intention.

Your session’s location, date, and start time are set by Cognosco and confirmed with you after registration — the scheduling is handled for you.

Looking to bring learning to a whole team? See corporate learning →

Enroll in This Course

In-person · Full day · Taught by Cognosco Learning instructors

Number of seats1

Add 2 more seats to save 10%.

$795.00 × 1 seat$795.00
Total$795.00

No account required · Secure checkout

What happens next

  1. Choose your seats and enroll — no account required.
  2. Cognosco sets your session location, date, and start time, and confirms them with you.
  3. Check out securely; your confirmation is sent immediately.
Also Available · The Lighthouse Coach

Prefer to learn at your own pace?

Excel VBA & Macros: Automate Your Spreadsheets is also a Signature AI Socratic Coaching Course — the same material, taught one learner at a time by the Lighthouse Coach, whenever it suits you. Introductory price $195.

See the AI Course — $195 →Try a Free Preview

Finish the AI course and you earn a completion certificate that anyone can verify online.

Questions

Before You Enroll

What's included in a course day?

A full day of in-person learning — 9:00 AM–5:00 PM, seven learning hours — led by a Cognosco Learning instructor, a printed participant manual for every attendee, and all course materials and exercises. One flat rate per person — no proposal required.

How are the location, date, and start time set?

They are set by Cognosco. When you register, we confirm your session’s location, date, and start time with you directly — you don’t need to propose or hold dates on your own.

How do the group savings work?

Automatically, at registration: 3–4 seats save 10%, and 5 or more seats save 20% off the $795 per-person rate. The discount is applied in the seat selector before you check out — no code, no negotiation.

Can we bring learning to a large group or a whole department?

Yes. Online registration handles up to 50 seats per course. For a larger group, a multi-course plan, or sessions across several locations, email us at hello@cognoscolearning.com and we’ll plan it with you.

What if we need to change our date?

Email us at hello@cognoscolearning.com as soon as you know — we’ll work with you to move your session to a date that works.