Excel VBA & Macros: Automate Your Spreadsheets

A coach that teaches by asking — not by lecturing

The Lighthouse Coach is an AI Socratic coach built on Cognosco Learning's Excel VBA & Macros: Automate Your Spreadsheets course, in the Personal Effectiveness & Well-Being category. It does not play videos at you.

It holds a conversation: it asks you a question, listens to your answer, names the misconception it hears, affirms what you got right, and asks the next question — the way a great coach works in the room. You work in your own workbook alongside the Coach throughout: you type every code listing yourself, run it, and check its result against your own screen.

This is the course for office and operations staff who run the same reports, cleanups, and checks on a cycle, analysts and finance staff who already live in Excel, small-business owners and managers who depend on a handful of key workbooks, and team leads who inherit other people's macro workbooks and need to read, repair, and share them safely.

It works in the order the work itself runs: first, Module 1 — From Recording to Writing — work through Concepts 1–9, finishing with The Weekly Pack, Automated; then, Module 2 — Automation a Team Can Trust — work through Concepts 10–18, finishing with The Shared Routine.

You finish by proving the whole course — in The Weekly Pack, Automated and in The Shared Routine. You can type your answers, or talk out loud: the Voice Coach speaks its questions and listens to your spoken replies, hands-free. The course is self-paced and always on — roughly 30 minutes per concept, about 9 hours in full, taken in as many sittings as you like. Learners who already know the material can test out concept by concept.

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 rows checked against the same rule every Friday, the same summary copied to the same sheet every month-end. Done by hand, that work is slow, dull, and quietly error-prone — not because the person doing it is careless, but because repetition is where care goes to die.

You start where every working macro writer starts: the recorder, which watches what you do and writes the code for you. You learn where that code lives, how to read it, and how to cut the recorder's waste out of it until it says only what you meant. Then you write code the recorder never could — code that stores values in named variables, chooses between actions, repeats an action across every row you have, asks the person at the keyboard a question and acts on the answer, and survives a mistake without dying silently.

Every code listing in the course is meant to be typed and run — complete enough to do exactly what the text around it says it does, with its inputs and results stated so you can check the course against your own screen.

Both capstones produce real artifacts — a cleaned, hand-finished automation pack for a weekly workbook, and a shared, secured, documented routine a whole small team can run — not just ideas about automation.

This is the one hundred and eighty-eighth course in The Lighthouse Signature Series — the online counterpart to the one-day, in-person learning Cognosco Learning has delivered since 2002.