01
Numbers nobody can trace
An AI summary reads well and sounds sure, but a total, a percentage or a customer name in it does not match the data, and nobody can say where it came from.
Camderson Academy · CA-AI-006
Faster answers from your data. Numbers you can stand behind.
A practical, self-paced course for anyone on any team who reports on spreadsheet data. Use AI to clean, analyze and chart business data, protect personal and confidential data before anything is uploaded, trace every AI number back to the source, draw honest charts and write reports that lead with the answer.
About 6 hours · 18 lessons with video · Intermediate · No coding · Self-paced · Tools and templates you keep · 30-day money-back guarantee
AI makes analysis faster. It does not make every number right.
02
Messy data, quiet fixes
Duplicates, a test order, a typing error and mixed dates sit in the export. Some get fixed, some do not, and nobody wrote down which.
03
Charts and reports that mislead
A cropped axis makes a small dip look like a collapse, and the real answer is buried on page three, so people decide on the wrong picture.
Learning outcomes
What you will be able to do
Eight practical outcomes, each practiced in an exercise and checked in the final assessment or the capstone.
- Explain how AI data analysis features produce numbers and where they go wrong, and choose the right feature for a task.
- Protect personal and confidential data before using AI by checking tool approval, data terms and the minimum data a question needs.
- Frame an analysis with a clear question, decision, audience and metric definitions before touching the data.
- Profile and clean a dataset with AI help while keeping every change visible, tested and reversible.
- Summarize, compare and explain business data with AI, and verify every number against the source and a control total.
- Build honest, readable and accessible charts and fix misleading AI-made ones.
- Write answer-first reports with AI help and fact-check every claim before anyone relies on them.
- Make analysis reproducible and run recurring AI-assisted reporting responsibly as a team.
The Camderson method
Teaching tools for analysis you can check, starting with your next report
The Data Share Check and the Analysis Brief
Approved tool and account · Minimum for the question · Remove or replace · Look for hidden data · Record what you shared · Question · Decision · Definitions · Checks · Output
Decide what data may go into an AI tool before anything is uploaded, then frame the question on one page so everyone agrees what the numbers mean.
The Data Profile and the Cleaning Log
Shape · Keys · Types · Gaps · Ranges · Categories · Totals · Problem · Rule · Rows affected · Method · Confirmed by · Reversible
Look before you trust, then clean in steps anyone can see, check and undo.
The Control Total Check and the Number Trace
Every breakdown adds to the total · The total equals the trusted figure · List every number · Find its source · Recompute it · Mark it · Fix or remove
Tie every summary to a figure you trust, and trace every number in an AI answer back to the data before it goes in a report.
The Honest Chart Check and the Two-Person Review
Zero for bars · One value axis · Fair range · Consistent scales · Labels and units · Context · Author checks · Reviewer spot-traces · Sign-off recorded
Draw charts that tell the truth at a glance, and have a second person check the key numbers before anyone relies on the report.
Every AI number is a draft until you can show where it came from.
Curriculum
Inside the course
Six modules, 18 lessons with worked examples and video
01
AI as Your Analysis Partner
How AI tools work with your data and the Show Your Work Test, protecting data before you upload with the Data Share Check, and framing the question with the Analysis Brief.
02
Cleaning Data with AI
The Data Profile for a first look you can trust, the Cleaning Log for changes you can see and reverse, and the Formula Test for AI-written formulas.
03
Analysis You Can Check
The Control Total Check for summaries and pivots, the Variance Walk for trends and what drives them, and the Number Trace for catching invented and wrong numbers.
04
Charts That Tell the Truth
The Chart Chooser for the right chart, the Honest Chart Check for axes, scales and comparisons, and the Readable Chart Check for clear, accessible charts.
05
Reports People Can Trust
The Answer-First Report Frame for structure, the Numbers Pack for drafting with AI from verified figures, and the Two-Person Review before you send.
06
Reproducible, Responsible Reporting
The Analysis Log for analysis anyone can repeat, the Report Runbook for recurring reports with AI, and your AI Analysis Practice Plan.
What is included
Skills, tools and templates you keep and use in your work
- 18 lessons, each with a written lesson, worked examples and figures, and a narrated lesson video, at your own pace
- A running example from Mossbank Larder, a fictional specialty food wholesaler whose September sales export has duplicates, a test order, a typing error, text amounts and mixed dates and region names
- A fillable Workbook with Try it and Reflect pages for every lesson
- Analysis Templates (Word) for every teaching tool, including the Data Share Check, Analysis Brief, Cleaning Log, Number Trace, Honest Chart Check, Answer-First Report Frame and Report Runbook
- An AI Prompt Library for Analysis with prompts for profiling, cleaning, formulas, summaries, charts and report drafts, each paired with the check to run
- Mossbank Sales Analysis practice spreadsheets with live formulas, a solutions version and a reusable Analysis Workbook Template, plus the raw export to practice on
- Quick Reference Cards and the Mossbank Case Pack
- An optional visual companion PDF with every lesson slide
- Knowledge checks for every module and a 20-question final assessment
- An AI-Assisted Analysis and Report capstone on data your organization approves or on a fictional youth sports league, reviewed by a person
- A Camderson Academy Certificate of Completion when you pass the final assessment and the capstone
- Access to the Camderson Academy community
Is this course right for you?
This course is for you if
- You turn spreadsheets into answers for other people: analysts and coordinators, people in sales, operations, customer service, finance, HR and marketing, team leads, managers and owners, in any department
- You use, or want to use, ChatGPT, Copilot in Excel, Gemini in Google Sheets or a similar tool for analysis, and want to know which numbers you can trust
- You want templates, checklists and practice files you can use with your next report, and habits that make every number traceable
It is not the right fit if
- You are brand new to spreadsheets (CA-TD-001 Microsoft Excel for Business covers sorting, filtering and formulas first)
- You want to learn statistics, coding or data engineering (this course stays in the spreadsheet and needs no coding)
- You mainly need AI policy and governance for your organization (CA-AI-007 Responsible AI Use and Governance at Work covers that)
- You want a product recommendation or pricing advice for a specific AI plan (the course describes features neutrally and points you to the official help pages)
Your instructor
Meet your instructor
Ruben Tejada
MA, MS, PHR
Managing Partner · Leadership & Organizational Effectiveness
Ruben Tejada is a strategic advisor and organizational leader whose career spans healthcare, public service, human resources, operations, and learning and development. He has advised executives and leaders on leadership development, talent development, employee experience, culture and succession planning, and has led initiatives to strengthen leadership accountability and build workforce capability. That work gives him a practical view of how teams turn numbers into decisions people can stand behind. In this course he helps you use AI to move faster with your data while making sure every number in your report can be checked, one report at a time.
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 who reports on data, in every role and department, to share the same habits for protecting data, checking numbers and writing reports people can trust. Email connect@camderson.com to talk through your group.
Frequently asked questions
Do I need any experience or a previous course?
No previous course is required and no coding is needed. It is an intermediate course: you should be comfortable sorting, filtering and writing simple formulas in a spreadsheet. CA-AI-001 ChatGPT & AI for Business Professionals and CA-TD-001 Microsoft Excel for Business are helpful background.
Who is this course for?
Anyone on any team who reports on spreadsheet data: analysts and coordinators, people in sales, operations, customer service, finance, HR and marketing, team leads, managers and owners. The examples come from a food wholesaler, and the tools fit offices, clinics, agencies, shops, nonprofits and businesses of every size.
How long do I have access?
Your access does not expire. We review the course regularly, 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 and their videos, the Try it exercises, the knowledge checks, the final assessment and the capstone. Everything is self-paced.
Do I have to use real data for the capstone?
No. You can complete your AI-Assisted Analysis and Report on the fictional Kittering Youth Sports League data included in the course. If you use real data, use only data your organization approves for the purpose, remove names, contact details and other personal information, and leave out confidential figures.
Do I need a paid AI tool?
No. Every exercise and the capstone can be completed in a spreadsheet with the templates, and using an AI tool is optional. If you do use one, use only a tool and account your organization has approved for the data. Features and plans change, so the lessons date every product detail and point you to the official help pages.
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, an analysis and report that a person reviews. It is not an academic credential and does not carry continuing education or other professional credit.
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.
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. An AI tool is optional. All templates and practice files are included as downloads.
Faster answers. Numbers you can stand behind.
Self-paced, about 6 hours, with a Workbook, Analysis Templates, an AI Prompt Library for Analysis, Quick Reference Cards and practice spreadsheets with live formulas to help you clean, analyze, chart and report on your data with AI, and check every number before anyone relies on it.
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 using AI for data analysis and reporting. It does not replace your organization's data, privacy, security or AI policies or professional financial, legal or statistical advice. Share data only with the AI tools your organization has approved. Camderson Academy is not affiliated with OpenAI, Microsoft or Google and does not endorse any of their products; AI tools change often, so check their official help pages before you rely on a feature, a plan or a price.