AI for Excel & Spreadsheet Work
Signature Course No. 273 — A Signature AI Socratic Coaching Course.
No experience needed — your coach starts where you are.
A New Kind of Learning
Socratic coaching, delivered by an agentic AI coach.
Not a course you watch. An AI coach you work with.
The Lighthouse Coach begins by discovering how you think about the subject, teaches what is missing, and gives you realistic practice before asking you to prove that you can use it. You may test out of concepts you already understand, while capstones turn the learning into a practical plan, decision, conversation, or other real-world result.
The curriculum is deliberately authored; the AI delivers it through coaching. It is not an AI randomly generating lessons.
A coach that teaches by asking — not by lecturing
The Lighthouse Coach is an AI Socratic coach built on Cognosco Learning's AI for Excel & Spreadsheet Work course, in the AI at Work 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 already live in spreadsheets. The spreadsheet did not go away when AI arrived — it became the place where AI help is most useful and most dangerous at the same time. An assistant inside the sheet can write a formula in seconds and clean a thousand rows in a minute. It can also write a formula that looks right, points at the wrong range, and quietly misstates a margin for three months.
This course teaches the analyst's discipline end to end. How to brief an assistant in six parts so it can help, how to read the formulas it writes the way you would read a sentence in a contract, how cleaning, lookups, totals, dates, and error handling work when a machine does the typing — and the hand-check discipline that makes all of it safe: every result checked against something you computed yourself.
Then it teaches the working analyst's craft. Tables and pivots with grain, population, and aggregation decided by you; what-if work with break-evens solved by hand; forecasts extended by two methods, back-tested, and reported as ranges; models built in four zones and audited without mercy; charts whose geometry tells the truth and commentary that stays inside the checked numbers.
It works in two movements. First, Module 1 — Brief It, Build It, Check It: Formulas and Data You Can Defend — work through Concepts 1–9, finishing with The Month-End Pack; then, Module 2 — Models, Answers, and Sign-Off: Analysis Worth Presenting — work through Concepts 10–18, finishing with The Board Workbook.
Both capstones produce real artifacts — a month-end pack footed against the ledger anchor of $184,250 and closed with its sign-off note; and the checked workbook pack this course exists to leave you with: a model, its audit sheet, and its sign-off note, built to the standard your next reviewer will thank you for.
The honesty discipline is part of the course. The checking spine is absolute: every AI-written formula in the course is checked against a hand-computed result, worked by ordinary arithmetic from the same source figures. Product facts are framed verify-current, no feature is invented, and the course makes no speed or accuracy promise for your workplace — it promises a method: brief, build, read, hand-check, sign off.
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. You can type your answers, or talk out loud: the Voice Coach speaks its questions and listens to your spoken replies. Learners who already know the material can test out concept by concept.
AI for Excel & Spreadsheet Work is part of The Lighthouse Signature Series — the online counterpart to the one-day, in-person learning Cognosco Learning has delivered since 2002.
Course Facts
One full concept, coached end to end — free: verify your email and we’ll send you a link to start.
Already enrolled? Enter the course →
Diagnose → Learn & Practice → Prove → Capstone
Every learner moves through the same discipline a Cognosco instructor would insist on in the room.
Diagnose
The Coach starts where the course starts: with the brief. Before any formula is written, settle the question, the layout, the definition, the output form, the edge cases, and the check you will run — because everything downstream is only as good as the brief that produced it. Every concept opens with three questions that locate where you actually stand, and your answers shape how deeply the Coach works the concept with you. Everyone begins with Module 1 — no skipping the foundations you only think you have.
Learn & Practice
Work each concept in conversation with the Coach — spoken or written — then practice it against realistic situations until it holds up.
Prove
Every concept ends in proof: answer the check cold and demonstrate the skill. Know it already? Test out and take credit immediately.
Capstone
Finish with two capstones — The Month-End Pack for Module 1 and The Board Workbook for Module 2 — that pull the whole course together, and earn the certificate.
What You'll Learn
Brief it before you build it. Every job stated in six parts — question, layout, definition, output, edge cases, and the check you will run — so the assistant executes your judgment instead of guessing at it.
Module 1 builds the foundation. The brief, the read-aloud, range truth, cleaning under rules, exact lookups, totals that foot by two routes, dates and text with their disguises off, errors guarded with markers — and the hand check over all of it.
Module 2 builds the craft. Pivots reconciled to their source, break-evens solved by hand, forecasts carrying a passport, models built in four zones and audited by family, charts and commentary held inside the evidence, and arrays verified by key.
And it leaves you a pack. A checked workbook pack — model, audit sheet, and sign-off note — closed to the analyst's standard, defensible by a stranger three months later.
What you will learn
- Brief an AI assistant for spreadsheet work and read, govern, and correct the formulas it writes
- Clean, match, total, and transform data with AI help — and prove each result by hand check
- Build and audit spreadsheet models with an assistant, run what-if and forecast work honestly, and present results in truthful charts and verified commentary
- Close every job to a sign-off standard: what was AI-drafted, what was hand-checked, and what remains uncertain
Everything in the course
- All 18 concepts of AI for Excel & Spreadsheet Work, in 2 modules
- A starting-point check first — the Coach finds where you actually stand before teaching
- Learn, Practice, Prove for every concept — no passive video watching
- A test-out on every concept: prove you know it and move on
- The Voice Coach: talk with the Coach out loud — it speaks, listens, and replies
- A personal Learner Record of your work across the course
- Two capstone exercises: The Month-End Pack and The Board Workbook
- A printable session summary whenever you pause
- The Lighthouse Coach completion certificate (Signature Series)
- Your progress is saved as you go — stop anytime, resume where you left off
Built for people whose numbers must be right
Financial and operations analysts — who build, inherit, and defend spreadsheet models and need AI help without AI risk.
Accountants, bookkeepers, and finance-team members — whose reconciliations, schedules, and reports must foot exactly.
Operations, supply, and commercial staff, and managers who review spreadsheets — who clean lists, match records, and summarise data every week, or sign numbers other people built and need to know what a checked number looks like. The course assumes basic spreadsheet fluency and access to, or the expectation of, an AI assistant for spreadsheet work.
Prefer to learn live and in person? The same material anchors Cognosco's one-day programs — browse the in-person catalog.
Start with The Month-End Pack
$195 — introductory price. One payment. No subscription, no password to manage.
Here is exactly what happens when you enroll:
- Pay securely with Stripe — you are taken straight into the course
- Create your learner profile and begin the Module 1 starting-point check
- Save the access key you are given — it restores your enrollment on any device
- Learn at your pace; your progress is stored in your browser on your device
For the full voice experience, use Chrome and allow the microphone when asked. Typing your answers works everywhere, all the time. Questions before you enroll? Email hello@cognoscolearning.com.
Before you enroll
What is a Socratic coaching session?
A conversation, not a video. Your coach asks a question; you answer — out loud by voice, or by typing — and the coach responds to what you said: naming the misconception it hears, affirming what you got right, and asking the next question. You advance only when you have mastered each concept, so a finished course means the learning held.
How long does it take — and how long do I have?
About 30 minutes per concept. Learn in sittings of any length; your progress is saved as you go. You have a full year from purchase to finish, and you can revisit and retake within that year.
What does the certificate verify?
That you completed every concept and both capstones of this course. Anyone can confirm a Cognosco certificate online — enter its certificate ID on our verification page.
What if it isn't for me — what are the refunds?
If you have not started, cancel for a full refund within seven days of purchase. Once you have started, there is no cash refund — stop before finishing and we credit the full amount you paid toward any other course in the library (credit valid one year from your original purchase). Once you complete the course, no refund or credit applies.
More Signature Courses are coming
AI for Excel & Spreadsheet Work is Signature Course No. 273. Leave your email and we'll send you news of future Signature Courses and Lighthouse updates as they are announced — nothing else.