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 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.