Wondering how to keep your business spreadsheets organised, readable, and safe instead of ending up with twelve versions of the same file? This module answers exactly that question. By the end of this module you will manage a business dataset in Excel with confidence — formatted clearly, backed up properly, and structured so it can be analysed later. You'll freeze rows and columns so headers stay visible in long tables, control alignment, wrapping, and merged cells so your data reads cleanly, set up a business planning checklist template, and establish a saving and backup routine that protects your work. This module is designed for office professionals, analysts, and small business owners who work with spreadsheets daily and want fewer errors and less rework. No advanced Excel experience is required — the techniques apply equally in Microsoft Excel and Google Sheets. You'll finish with a formatted, backed-up business planning workbook and a shortcut cheat sheet, ready to reuse for your own reporting and tracking. The module also covers data hygiene for AI — how to prepare tables so that Copilot, Claude, or ChatGPT can read them correctly, which matters far more than most people expect. Topics include Excel formatting, spreadsheet organisation, file management, data preparation, and Excel keyboard shortcuts.

Wondering how to turn a messy list of rows into a structured table that updates itself and doesn't break when the data grows? This module answers exactly that question. By the end of this module you will build a dynamic Excel table with working formulas, named ranges, and live date functions. You'll remove duplicate records, convert between tables and ranges, use TODAY and NOW so your sheet responds to the current date, write structured table formulas that expand automatically as rows are added, name ranges to make formulas readable, and protect a finished sheet with a password. This module is designed for anyone who maintains a recurring spreadsheet — trackers, logs, inventories, pipelines — and is tired of dragging formulas down and fixing broken ranges. No coding and no prior function knowledge are required; everything is done through the standard Excel interface. You'll finish with a working dynamic tracker built on Excel tables, ready to adapt to your own data. The module also walks through the standard data analysis process and how to fix the most common Excel errors when they appear, so you can diagnose problems yourself. Topics covered include Excel tables, removing duplicates, named ranges, date functions, structured references, sheet protection, and troubleshooting formula errors.

Wondering how to stop doing the same spreadsheet task every week and hand it to an AI assistant instead? This module answers exactly that question. By the end of this module you will automate a repeating spreadsheet workflow using AI-generated formulas and scripts. You'll prompt ChatGPT to produce working Excel functions and scripts, use Microsoft Copilot directly inside Excel to analyse and reshape data, apply Google Gemini in Sheets for the same class of task, and study real case studies covering budgeting, sales reporting, and project tracking. This module is designed for professionals who own a recurring report or tracker — weekly sales numbers, monthly budgets, project status — and want the repetitive part handled for them. Basic Excel familiarity is enough; no scripting or programming background is required, and the AI tools shown are available on free or standard business plans. You'll finish with an automated version of one of your own recurring reports, ready to run again next cycle. The module also covers how to use AI for data storytelling, so the output of your automation is something a stakeholder can read rather than just a refreshed table. Topics include Excel automation, AI-generated formulas, Copilot in Excel, ChatGPT for spreadsheets, Office Scripts, and workflow automation for business reporting.

Wondering how to work on the same spreadsheet as your team without sending files back and forth and losing track of which version is current? This module answers exactly that question. By the end of this module you will set up a shared Excel workbook that your team can edit in real time, with AI assistance built into the workflow. You'll configure collaborative editing and sharing in Excel Online, control who can see and change what, connect Excel to AI-powered tools that generate insights on shared data, and understand where the field is heading with AI assistants, APIs, and no-code platforms. This module is designed for team leads, coordinators, and hybrid or remote workers who maintain spreadsheets that more than one person touches. No IT administrator access is required for the core techniques, and everything is demonstrated on standard Microsoft 365. You'll finish with a shared, permission-controlled workbook and a working comparison of when to use desktop Excel versus Excel Online for a given task. The module also covers using Excel as a data source for low-code tools, which is how most business automation actually gets built today. Topics include Excel Online collaboration, real-time co-authoring, secure file sharing, hybrid work spreadsheets, AI assistants, and no-code integration.

Wondering how to move past summing columns and produce analysis that actually influences a business decision? This module answers exactly that question. By the end of this module you will run a full analytical cycle on a business dataset and present the result as a clear visual narrative. You'll generate IF statements from plain-language prompts, build a budget template with ChatGPT, create data summary tables, name ranges for readable references, manage multi-sheet workbooks efficiently, analyse and optimise campaign performance, automate work notes with scripts, and apply data storytelling principles to a final dashboard. This module is designed for marketers, analysts, and managers who already produce numbers and now need to produce conclusions. Comfort with basic Excel formulas is assumed; no statistics background or coding is required. You'll finish with an optimised campaign analysis and a dashboard you can present, ready to adapt to your own reporting cycle. The module also covers prompting AI for pivot table insights and the ethics of handling sensitive business data in AI tools — what should never be pasted into a chat window, and what to do instead. Topics include Excel data analysis, campaign optimisation, dashboard design, AI prompting for analytics, pivot tables, Office Scripts automation, and responsible AI use with business data.

Wondering how Microsoft Copilot actually reads your spreadsheet, and whether you can trust the answers it gives you? This module answers exactly that question. By the end of this module you will run a complete analysis in Excel with Copilot and verify its output before acting on it. You'll see how Copilot interprets your data structure, compare Excel with and without Copilot on the same task, run hypothesis checks with Copilot's guidance, request descriptive statistics, generate charts and dashboards from prompts, and refine visuals through styling, filtering, and exporting. This module is designed for Microsoft 365 users with Copilot access who want more than surface-level prompting, and for professionals evaluating whether Copilot belongs in their workflow. Basic Excel skills are enough; no formula expertise required. You'll finish with a Copilot-built dashboard and, more importantly, a working audit routine for checking AI-generated analysis before it reaches a stakeholder. The module gives equal weight to Copilot's limits — when to use it, when to do the work manually, and how to trace the logic behind a result you didn't write yourself. Topics include Microsoft Copilot for Excel, AI data analysis, prompt patterns for spreadsheets, automated chart generation, descriptive statistics, and auditing AI output.

Wondering how to clean a messy export — inconsistent dates, mixed currencies, free-text fields — without spending your afternoon on find and replace? This module answers exactly that question. By the end of this module you will transform a messy dataset into a clean, analysis-ready table using Claude. You'll write your first formula-generation prompts, split and tag free-text fields in bulk, standardise dates and currencies by describing the format you want in plain language, and handle stubborn text patterns with regex prompts you don't have to write yourself. This module is designed for analysts, operations staff, and anyone who regularly receives data from systems or colleagues in a state it can't be used in. No regex knowledge and no coding are required, and everything works on Claude's free plan with data you paste or attach. You'll finish with a cleaned, normalised dataset and a small library of reusable transformation prompts, ready to apply to next month's file. The module also explains what Claude can and cannot see in a spreadsheet, and which problems are worth fixing manually before any prompt is written — the difference between an AI that helps and one that confidently mangles your data. Topics include AI data cleaning, text parsing, data normalisation, prompt engineering for Excel, regex without coding, and preparing data for analysis.

Wondering how to fix a complicated workbook you inherited, or build multi-condition logic that doesn't quietly break at the edges? This module answers exactly that question. By the end of this module you will build and verify a multi-condition Excel model with Claude as your logic partner. You'll construct nested conditions that hold up at boundary values, reverse-engineer an inherited workbook to find hardcoded numbers and drifted ranges, build a dynamic budget and cash flow model, and create resource capacity planners and project timelines. This module is designed for finance staff, project managers, and analysts who maintain models other people depend on — and for anyone who has been handed a spreadsheet nobody fully understands. Comfort with basic Excel formulas is assumed; no VBA or programming required. You'll finish with a rebuilt, documented model and a repeatable audit routine, ready to use on the next workbook that lands on your desk. The module puts real weight on verification: where spreadsheet logic typically breaks, how to test AI-generated formulas against known edge cases, and how to document what was built so the next person can maintain it. Topics include Excel logic auditing, multi-condition formulas, financial modelling with AI, legacy spreadsheet debugging, cash flow models, capacity planning, and human-in-the-loop review.

Wondering how to take a finished analysis and turn it into something a decision-maker will actually act on? This module answers exactly that question. By the end of this module you will produce a one-page executive summary that states what happened, why, and what to do next. You'll explain what a chart is genuinely showing, read a trend and project it forward, generate a ready-to-send summary of your findings with Claude, catch suspicious transactions and anomalies with Copilot, test which metrics move together through correlation analysis, and distil a large dataset into a handful of key points. This module is designed for analysts, managers, and consultants who report upward and need their work to survive contact with a busy audience. Basic Excel and prior exposure to an AI assistant are enough; no statistics background required. You'll finish with a one-page executive dashboard and summary, ready to send. The module also gives you a routing framework for deciding which assistant to use for a given task — Copilot when the work must happen inside the live workbook, Claude when the task needs longer reasoning or explanation — plus the distinction between descriptive, diagnostic, and predictive questions. Topics include data storytelling, executive reporting, anomaly detection, correlation analysis, forecasting with AI, and framing insights for stakeholders.

Wondering how to pull everything you've learned into one workflow you'll genuinely use at work, and where to take these skills next? This module answers exactly that question. By the end of this module you will build a complete, functioning AI-enhanced Excel workflow from raw data through to a presentable result. You'll plan the workflow around a real task of your own, apply structured tables and formulas to the data, bring in an AI assistant for the analytical and reporting steps, and produce a finished output you can show to a colleague or manager. This module is designed for learners ready to consolidate scattered techniques into one working system, and for professionals who need a portfolio-quality example of AI-assisted spreadsheet work. Everything required is covered within the module, and a starter dataset is provided if you'd rather not use your own. You'll finish with a complete AI-powered Excel workflow — cleaned data, working logic, automated reporting — ready to run on a real business task. The module also covers where Excel and AI are heading, and how to keep your skills current as Copilot, Claude, and ChatGPT continue to change. Topics include capstone spreadsheet projects, AI workflow design, end-to-end Excel automation, and continuing skill development.