Google Sheets in Depth
Signature Course No. 581 — A Signature AI Socratic Coaching Course.
For confident spreadsheet users — your coach starts where you are.
AI-built course structure. Socratic coaching that builds mastery, not just completion.
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 Google Sheets in Depth 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.
In Sheets, the file is not a copy of the work — the file is where the work lives. A desktop spreadsheet is a thing you hold: open it, change it, save it, send a copy on. A Sheets file is a room you enter: one live source, everyone with access standing in it, watching the figures change as colleagues work. That is a change of physics, not a convenience. Divergence ends — and every error is live too. This course teaches the Sheets-native craft that follows: structure that protects the shared parts, views that let each person look without disturbing others, and formulas built for whole columns instead of copied cells.
It runs on one stipulated case. An operations analyst at a regional food-service distributor — head office, three depots, about 140 people, roughly 2,400 product lines — owns an estate of shared workbooks that goodwill can no longer hold together: an order sheet in a thicket of personal copies, depot stock files that disagree with each other and with the physical counts, prices looked up from whichever copy is open, and a Monday margin report assembled by hand in about three hours that has already been wrong twice in ways customers noticed first. Every concept works on that estate; both capstones rebuild it.
It starts with the model itself. The live file as the default condition; structure before formulas — one row, one record, with raw, working, and reporting layers kept apart; references that travel — relative, anchored, and named; the array habit of one formula serving a whole column; lookups with proof and aggregation by criteria; the text and dates real people type; and errors read as messages instead of hidden.
It works in two movements. First, Module 1 — One File, Many Hands: The Sheets Model — work through Concepts 1–9, finishing with The Depot Stock Sheet, Rebuilt; then, Module 2 — Depth: Power, Connection, and Governance — work through Concepts 10–18, finishing with The Monday Margin Board.
Both capstones produce real artifacts — a rebuild specification for a shared depot stock sheet: the starting file audited in structural terms, its layers and references designed, its calculations specified with their failure behaviour stated, and its week reconciled to the case — expected 7,795 cases, counted 7,763, a variance of −32 cases valued at 688.00 that the sheet is forbidden to hide; and a governed Monday reporting board design: the estate drawn, its standing questions stated with their reconciliations, its borders guarded, and its governance written so a successor could run it.
The honesty standard is part of the course. Depth here means judgment, not inventory: which construct, for which shape of problem, at what cost in clarity, speed, and fragility. The course gives no click-paths and no feature tour, and it fences the perishable facts — product limits, import ceilings, and tier specifics change as the product changes, so where a limit matters the course teaches the design judgment and sends you to the source for the current figure. Every worked number in the course recomputes exactly, because spreadsheet work lives or dies on arithmetic.
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.
Google Sheets in Depth is part of The Lighthouse Signature Series — the online counterpart to the one-day, in-person learning Cognosco Learning delivers.
Course Facts
One full concept, coached end to end — free: verify your email and we’ll send you a link to start.
AI-built course structure with Socratic coaching that builds mastery, not just completion.
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 shared workbook you touch most. How many copies or near-copies of it exist, that you know of — and when two of them disagree, which one wins, and how does anyone know? When you need to look at shared data your own way, do you change the shared range, or take a view that leaves it untouched? And which figure in your shared files could anyone in the room overwrite by typing — and who would notice, and when? 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 Depot Stock Sheet, Rebuilt for Module 1 and The Monday Margin Board for Module 2 — that pull the whole course together, and earn the certificate.
What You'll Learn
One file, one truth. A workbook earns trust when there is one live source, structured so that everyone touching it can see what a number is and where it came from. Formulas are judgment: a construct is a choice with a price — in clarity, in speed, in fragility, in what it does when the data misbehaves. Depth is knowing the price before you pay it, not knowing more function names than your neighbour.
Module 1 — One File, Many Hands: The Sheets Model — teaches the model: The File Is the Room; Structure Before Formulas; References That Travel; The Array Habit; Lookups With Judgment; Conditions That Count; Text Is Data Too; Dates Are Numbers; and Errors Are Messages — the Sheets-native grammar every shared workbook stands on.
Module 2 — Depth: Power, Connection, and Governance — teaches the depth: QUERY; Pivots; Imports That Behave; The Estate Around the Sheet; Guardrails for Many Hands; Color That Means Something; Charts That Tell the Truth; When the Sheet Gets Slow; and The Governed Workbook — questioning, grouping, importing, and governing at the level a depended-upon board demands.
And it holds its boundary throughout. This course teaches one spreadsheet, at depth, in its own terms — not a set of equivalents to another product's features. Habits imported from a desktop spreadsheet are addressed directly, because some of them are the misconceptions this course exists to correct: saving a personal copy is not prudence in the live model, it is the first step of divergence.
What you will learn
- Work the live file as the default: one shared source, many hands, no version chaos — and design for simultaneous use instead of suffering it
- Structure data so it can be trusted: one row, one record; raw, working, and reporting layers kept apart
- Write references that travel — relative, anchored, and named — so a formula says what it means and survives being copied, sorted, and shared
- Think in arrays: one formula serving a whole column, chosen deliberately over fill-down copying, with its costs understood
- Look values up with proof, and aggregate by criteria, so totals reconcile and missing keys announce themselves instead of passing silently
- Handle the real inputs: text people actually type, and dates as the numbers they are, calculated with rather than wrestled
- Read errors as messages, and decide — case by case — when handling an error is honest repair and when it is concealment
- Question and group data at depth: QUERY and pivots chosen against each other and against helper columns, imports between files that behave, and the connected estate worked as one system
- Govern the shared workbook: guardrails, honest colour and charts, performance by design, and the ownership, version, and handover discipline that lets a file outlive its author
Everything in the course
- All 18 concepts of Google Sheets in Depth, 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 Depot Stock Sheet, Rebuilt and The Monday Margin Board
- 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 the people the database quietly landed on
Analysts and operations staff whose Sheets workbooks other people depend on — reports, trackers, stock and order files — and who need them to be right, fast, and survivable; and team leads and coordinators who inherit or commission shared sheets and must judge whether a workbook is sound, and what to ask for when it is not.
Finance, logistics, and administrative professionals in Google-estate organisations who have outgrown the copied-formula, file-per-person way of working and want the native way instead; and confident spreadsheet users arriving from another product who keep reaching for habits that do not fit this one, and want the Sheets-native move named, once, clearly. The course assumes working familiarity with a spreadsheet — entering and editing data, simple formulas, ordinary formatting — and no programming.
Prefer to learn live and in person? The same material anchors Cognosco's one-day programs — browse the in-person catalog.
Start with The File Is the Room
$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.
Independently verified before publication — structure, claims, and sources checked; tested end to end as a learner takes it.
More Signature Courses are coming
Google Sheets in Depth is Signature Course No. 581. Leave your email and we'll send you news of future Signature Courses and Lighthouse updates as they are announced — nothing else.