01
Numbers you can trust
A short review routine, clean data and readable formulas catch the slips that would otherwise reach a report.
Camderson Academy · CA-TD-002
Formulas you can check. Pivot tables that answer. Dashboards people trust.
An advanced, self-paced course for people who use spreadsheets every week. Prevent errors, structure and clean data, build conditional totals and reliable lookups, create pivot tables with the right measures, design honest dashboards with slicers and hand them over so others can run them.
About 6 hours · 12 lessons · Advanced · For every department · Self-paced · Tools you keep · 30-day money-back guarantee
Reliable analysis comes from a few steady habits.
02
Answers on demand
Conditional totals, reliable lookups and pivot tables turn a monthly scramble into a quick, repeatable answer.
03
Dashboards that get used
Dashboards built around a decision, with honest charts and a handover pack, serve the people who act on them.
Learning outcomes
What you will be able to do
Practical outcomes, each practiced in an exercise and checked in the final assessment or the capstone.
- Explain how spreadsheet errors happen and use a review routine to prevent them.
- Build conditional totals, reliable lookups and readable formulas.
- Build pivot tables that answer a question, with correct measures, refreshed and reconciled.
- Design dashboards around a decision and charts that are honest and readable by everyone.
- Add interaction and maintain a dashboard so others can run it.
- Assemble a handover pack so your analysis can be trusted and repeated.
The Camderson method
Simple tools for analysis people can rely on
Error Review Card
Compare · Ranges · Test · Second reader · Record
Review a file before anyone relies on it.
Data Layout Check
Header · One table · One thing per cell · Formats · Dictionary
Make a table ready for analysis.
Data Reliability Check
Accurate · Complete · Fit · Look · Log
Check accuracy, completeness and fit before trusting data.
Criteria Map
Question · Sum column · Tests · Labeled cells
Plan a conditional total before writing it.
Lookup Plan
Key · Clean · Exact · Not found · Count
Make lookups that do not break.
Formula Test Sheet
Steps · Inputs · Test · Lock · Handover
Make a workbook readable, testable and ready to hand over.
Pivot Question Card
Question · Sketch · Layout · Total · Sentence
Start every pivot table from a question.
Measure Sheet
Name · Calculation · Example · Percent or points · Limits
Define measures so they do not mislead.
Pivot Check
Refresh · Source · Reconcile · Record
Keep pivot tables fresh and reconciled.
Dashboard Brief
Decision · Audience · Measures · Trigger · Message
Design a dashboard around a decision.
Chart Check
Type · Axis · Axes · Color · Title
Make charts honest and readable.
Dashboard Handover Pack
Brief · Dictionary · Checks · Run sheet · Review date
Let someone else run your dashboard.
Check. Build. Answer. Hand over.
Curriculum
Inside the course
4 modules, 12 lessons with worked examples
01
Trustworthy Spreadsheets
Prevent errors, structure data for analysis and clean it with an audit trail.
02
Advanced Formulas
Build conditional totals, reliable lookups and formulas others can read and hand over.
03
Pivot Tables That Answer
Build pivot tables from a question, use measures that do not mislead and keep them reconciled.
04
Dashboards People Trust
Design dashboards for decisions, choose honest charts, add slicers and hand them over.
What is included
Skills, tools and templates you keep and use in your work
- 12 lessons, each with a written lesson, worked examples and figures, at your own pace
- A running example from Thistledown Distribution, a fictional organization where people in every team put these skills to work
- A fillable Workbook with Try it and Reflect pages for every lesson
- Advanced Spreadsheet Templates (Word) for every teaching tool
- A practice tracker with live formulas, a solutions version and a reusable template
- Quick Reference Cards and the Case Pack
- An optional visual companion PDF with every lesson figure
- Knowledge checks for every module and a 20-question final assessment
- A capstone you can build for your own team or a fictional case, reviewed by a person
- Access to the Camderson Academy community
- A Camderson Academy Certificate of Completion when you pass the final assessment and the capstone
Is this course right for you?
This course is for you if
- You use spreadsheets every week and want your analysis to be faster, more reliable and easier to hand over
- You work in any department: finance, operations, sales, marketing, HR, care, administration or leadership
- You want skills that work in the major spreadsheet programs
It is not the right fit if
- You are new to spreadsheets (CA-TD-001 covers the basics)
- You want to learn a database, scripting language or business intelligence platform
- You need accounting or audit advice for a specific filing
Your instructor
Meet your instructor
Taught by Camderson Advisory
Strategic advisor and organizational leader
Your instructor is a strategic advisor and organizational leader whose career spans healthcare, public service, human resources, operations, and learning and development. Years of building and facilitating workplace trainings for hundreds of employees and leaders have shown that new habits stick when they are simple, practical and welcome in every role. In this course, your instructor helps you build spreadsheet analysis that is accurate, clear and easy for others to use.
About
About Camderson Academy
Camderson Academy is the education division of Camderson Advisory Services. Camderson helps leaders build organizations that work without them in the room. Everything we teach has been used in a real organization first.
Training a team?
We offer group enrollment for teams and whole organizations that want everyone, in every role and department, to build the same skills. Email connect@camderson.com to talk through your group.
Frequently asked questions
Do I need any experience or a previous course?
Comfort with basic formulas, tables and charts is expected. CA-TD-001 Microsoft Excel for Business is a good foundation but not required.
Who is this course for?
Experienced spreadsheet users in any department. The example is a regional distributor, and the methods work for teams in offices, clinics, schools, nonprofits and businesses of every size.
How long do I have access?
Your access does not expire. We review the course on a regular cycle, and any updates are added for you at no extra cost.
How long does it take?
About 6 hours in total, including the written lessons, the Try it exercises, the knowledge checks, the final assessment and the capstone. Everything is self-paced.
Is there a money-back guarantee?
Yes. You are covered by a 30-day money-back guarantee. If the course is not right for you, email connect@camderson.com within 30 days of purchase and we will refund you in full. No questions asked. Your course access ends when the refund is issued. (Guarantee wording identical to earlier courses.)
What tools do I need?
A spreadsheet program that opens .xlsx files (Microsoft Excel, Google Sheets, Apple Numbers or LibreOffice Calc), a word processor that opens .docx files and a PDF reader. All templates and practice files are included as downloads.
Do I have to use my own data for the capstone?
No. You can build your handover pack for the fictional Pinegate Community Pantry included in the course. If you use your own data, leave out personal and confidential details.
Does the course recommend products or give professional advice?
No. It teaches methods and names features from more than one spreadsheet program only as examples. It is general education, not accounting or IT advice, and Camderson Academy is not affiliated with any vendor.
Is the certificate accredited, or does it carry professional credit?
Neither. You receive a Camderson Academy Certificate of Completion after passing the final assessment and the capstone, which a person reviews. It is not an academic credential and does not carry continuing education or other professional credit.
Formulas you can check. Pivot tables that answer. Dashboards people trust.
Self-paced, about 6 hours, with a Workbook, templates, Quick Reference Cards and a practice tracker.
Backed by our 30-day money-back guarantee.
This course earns a Camderson Academy Certificate of Completion. It is not an academic credential and does not carry continuing education or other professional credit. This course is general education about building reliable analysis in spreadsheet software. It is not accounting, audit, legal or IT advice. Function names, menus and features differ between spreadsheet programs and versions, so check your own program's help pages. Examples and numbers are illustrative. Use only data your organization allows you to use. Camderson Academy is not affiliated with any software vendor and does not endorse any product.