Business spreadsheets with Excel
Turn Excel into a working tool: clean tables, formulas you can trust, lookups, pivot tables and a budget model that answers questions.
- hours
- 16
- units
- 4
- lessons
- 16
- Certificate level
- 3
About this course
Turn Excel into a working tool: clean tables, formulas you can trust, lookups, pivot tables and a budget model that answers questions.
Who it is for
Office workers, small business owners and anyone who copies numbers by hand today.
Paces
Standard · Flexible
What you will be able to do
- Enter, format and structure data in a worksheet
- Use formulas and functions, including lookups
- Summarise data with pivot tables and charts
- Build a simple budget model
Curriculum
4 units · 16 topics · 16 hours
01Worksheets and data4 lessons · 4 hours
Outcome: Enter, format and structure data in a worksheet
- L01Cells, ranges and navigation60 min
- L02Entering and cleaning data60 min
- L03Formatting for reading60 min
- L04Tables, sorting and filters60 min
- ✓Unit check: show this outcome with evidence
02Formulas and lookups4 lessons · 4 hours
Outcome: Use formulas and functions, including lookups
- L05Formulas and references60 min
- L06SUM, AVERAGE, IF and friends60 min
- L07XLOOKUP and VLOOKUP60 min
- L08Checking formulas for errors60 min
- ✓Unit check: show this outcome with evidence
03Pivot tables and charts4 lessons · 4 hours
Outcome: Summarise data with pivot tables and charts
- L09Building a pivot table60 min
- L10Grouping and filtering a pivot60 min
- L11Choosing the right chart60 min
- L12Conditional formatting60 min
- ✓Unit check: show this outcome with evidence
04A budget model4 lessons · 4 hours
Outcome: Build a simple budget model
- L13Laying out a model60 min
- L14Inputs, calculations and outputs60 min
- L15What-if scenarios60 min
- L16Capstone: build the budget60 min
- ✓Unit check: show this outcome with evidence
How each live lesson runs
Every topic is one live lesson of an hour. Your instructor and mentor are AI, and they say so.
Whiteboard · Idea
Cells, ranges and navigation
- Teodor Varela explains one idea at a time on the whiteboard, in plain words.
How you are assessed
What you hand in
A working budget spreadsheet with formulas
Final check
Build a budget model from a brief
Certificate level 3
You showed the skill
Your evidence was assessed against the course's standard, and a person signs this certificate.
Who teaches
Every lesson has a named AI teacher and a mentor who keeps you on track. Both are AI, and every screen says so.
- AI instructorTeodor Varela
- AI mentorBastian Kwan
First class · try it now
Sit the first class before you decide
Seven steps, about ten minutes, no account: learn, check, produce, get assessed, defend it in a short viva and leave with a proof card.
More in this category
Business, Finance & Entrepreneurship
Agile project management
Run a project the agile way on a realistic case: build the backlog, plan a sprint, track it on a board and turn a retrospective into real changes.
Business, Finance & Entrepreneurship
Bookkeeping fundamentals
Keep a small business's books the right way: double entry, daily records, a bank reconciliation and a trial balance that adds up.
Business, Finance & Entrepreneurship
Writing a business plan
Go from an idea to a plan someone can say yes to: the customer problem, the market, the numbers and a clear one-page model with a short pitch.
