Courses floor › Business, Money and Career
Excel from Zero to Confident for Finance and Operations Staff (Interme
| SKU | FB-16-B79817F5 |
|---|---|
| Format | ZIP: Markdown, PDF, PNG, Python |
| File size | 636.8 KB |
| Delivery | Instant download, unlimited re-downloads from your account |
| Licences | Personal, Commercial, Extended |
All sales are final. Refund policy.
About this product
7-module intermediate course for finance and operations staff. Build robust multi-sheet formulas using IF, SUMIFS, COUNTIFS and error handling. Includes written lessons, worked examples, a quiz with answer key per module, runnable companion scripts, a workbook, a cheat sheet, a final project and a NorthFraim completion certificate. Made with AI assistance. Modules: 1. Reliable Formula Foundations for Finance Work; 2. Conditional Aggregation and Reconciliation Totals; 3. Lookups That Do Not Break; 4. Tables, Structured References and Data Validation; 5. Pivot Tables and Charts for Operations Reviews; 6. Cleaning Messy Data Before It Reaches a Report; 7. A Small Linked Model with Inputs and a Summary. What you will be able to do: Build robust multi-sheet formulas using IF, SUMIFS, COUNTIFS and error handling; Resolve lookups safely with exact-match techniques and validation of missing keys; Structure data as tables and summarise it with pivot tables and pivot charts; Clean messy operational data with text, date and duplicate-handling techniques; Assemble a small linked model with inputs, calculations and a summary dashboard. Format: self-paced written course you download and keep (636.8 KB, 7 modules, 21 lessons, about 12,103 words), plus workbook, cheat sheet, quizzes and scripts.
What's included
- 7 modules, 21 written lessons (12,103 words of teaching text)
- A worked example per module
- A 2-question quiz and answer key per module
- Runnable companion Python scripts per module (checked in a sandbox)
- workbook.pdf: practice exercises for every module
- cheatsheet.pdf
- final-project.md with steps, deliverables and rubric
- certificate.pdf (completion certificate)
- syllabus.md, README.md, PROVENANCE.md
Download and use
- After payment, click your download link (on screen, in your email receipt and in your account dashboard; re-download any time).
- Unzip the file: double-click it on Windows or Mac, or tap it in the Files app on a phone.
- Open README.md, then syllabus.md, to see the plan.
- Work through modules/m1 to the last module: read the three lessons, study the worked example, do the practice (practice.md or the workbook), take quiz.md and check quiz-answer-key.md.
- Run each module's companion script with Python 3.9 or newer: open a terminal in the module's code folder and run the command shown in the lesson (standard library only, no internet or keys needed).
- Print or fill in workbook.pdf as you go, keep cheatsheet.pdf at hand, then complete final-project.md.
- Print certificate.pdf and write your name on it when you finish.
Tags
andconfidentcourseexcelfinanceforfromintermediatelessonsoperations








