Course Outline
Day 1 Automation Foundations for Finance
Introduction
We start by setting out what the six days will cover and how each day builds on the one before. You'll meet the sample finance data used throughout the course, and we'll talk about the processes that take up most of your month. This gives us real examples to refer back to all week.
Deciding What to Automate
Not every task is worth automating, so we begin with how to tell the difference. We look at the signs of a good candidate: work that repeats, follows clear rules, involves a lot of volume and is prone to errors. We also cover tasks that should stay manual, such as those needing judgement or happening only once a year. Finally, you'll learn a simple way to estimate the time an automation could save, so you can decide where to start.
Hands-on: Score a list of common finance tasks against these criteria and pick the strongest candidates.
Mapping a Process
Automating a process you haven't mapped usually means automating its problems too. In this module you'll learn to break a process into its inputs, steps, decisions, handoffs and outputs. We'll look at where work tends to stall and where errors creep in, because those points often show where automation will help most.
Hands-on: Map one real process from your own work, from the first input to the final output.
The Automation Tool Landscape
Here we give you a plain overview of the tools covered in the course and how they fit together. Power Query prepares data, Power BI reports on it, Power Automate moves information and triggers actions, and Copilot helps you draft and analyse. We also explain where n8n fits and how connectors let these tools talk to the systems you already use.
Hands-on: Match each step of your mapped process to the tool best suited to it.
Data Hygiene
Automation depends on clean, consistent data, so this module covers the habits that make everything else easier. We look at why Excel tables matter, how to keep column structures consistent, and how to set the right data types. We also discuss file naming and keeping a single source of truth, so different versions of the same data don't compete.
Hands-on: Convert a messy workbook into properly structured Excel tables.
Licences and Access
Many automation projects stall because someone discovers halfway through that they lack the right licence. We explain in plain terms what a standard Microsoft 365 licence includes and what needs a premium licence. You'll also learn how to check what you personally have access to.
Hands-on: Check your own licences and access against the tools used in the course.
Day 2 Power Query
Getting Started with Power Query
Power Query is built into Excel and Power BI, and many finance users already have it without knowing. We open the Power Query editor and walk through how it works. You'll see how each change you make is recorded as an applied step, which is what makes your work repeatable. We also cover the options for loading results back into Excel or Power BI.
Hands-on: Open the editor and load a bank statement CSV file.
Connecting to Data
Finance data arrives in many forms, so we practise connecting to the most common ones: CSV files, Excel workbooks, tables and whole folders. We cover the small problems that often trip people up, such as missing headers, unusual delimiters and character encoding. By the end, you'll be able to bring in data from your usual exports with confidence.
Hands-on: Connect to a ledger export and a bank statement.
Core Cleaning
This is where most of the time savings come from. We work through the cleaning steps you'll use again and again: removing unwanted rows and columns, splitting columns, setting data types and replacing values. We give particular attention to dates and number formats, which cause many of the errors in finance data.
Hands-on: Clean a messy bank export into a usable table.
Reshaping Data
Budgets and reports are often laid out with one column per month, which looks fine on screen but is hard to analyse. We show you how to unpivot this data into a long format that works properly with pivot tables and Power BI. We also cover grouping and summarising data inside Power Query.
Hands-on: Unpivot a budget sheet into a long table.
Combining Data
Finance work often means bringing several sources together. We cover appending queries to stack data from different periods, and merging queries to look up information from another table. We explain the different join types in plain terms. Then we show you one of Power Query's most useful features: combining every file in a folder automatically, so adding a new month is as simple as dropping in a file.
Hands-on: Combine twelve monthly exports from a single folder.
Reconciliation Preparation
Here we apply what you've learned to a common finance task. You'll learn how to match bank and ledger records using shared keys such as references and amounts. We also show you how to flag items that don't match, so you can focus your time on the exceptions instead of checking every line.
Hands-on: Build a query that matches bank and ledger records and lists the unmatched items.
Refresh and Maintenance
The real benefit of Power Query is that you build the process once and refresh it each month. We show you how to refresh your queries and add new data without redoing your work. We also cover how to document your steps so colleagues can follow them, and how to avoid the common changes that break a query.
Hands-on: Add a new month's file and refresh the query.
Day 3 Power BI
Power BI Fundamentals
We introduce Power BI Desktop, where you build reports, and the Power BI service, where you share them. You'll get to know the report, model and data views and what each one is for. We then bring in the data you cleaned on Day 2, so you build on work you've already done.
Hands-on: Load the Day 2 cleaned data into Power BI.
Data Modelling
A well-built model makes reporting simple, and a poor one makes it frustrating. We explain the star schema in plain terms: fact tables that hold your transactions, dimension tables that describe them, and a date table that makes period reporting work. We also cover how relationships between tables work and why filter direction matters.
Hands-on: Build a model containing actuals, budget, accounts and dates.
Essential DAX
DAX is the formula language used in Power BI. We keep it practical and focus on the few functions finance users need most. You'll learn the difference between calculated columns and measures, and how to use SUM, CALCULATE and DIVIDE to produce reliable figures.
Hands-on: Write measures for actual, budget and variance.
Time Intelligence
Finance reporting depends on comparing periods. In this module you'll learn how to calculate month-to-date and year-to-date figures, and how to compare them with the prior year. These measures make up the core of most monthly management reports.
Hands-on: Add year-to-date and prior-year variance measures to your model.
Report Design
A useful report shows the reader what matters quickly. We cover how to choose the right visual for finance data and when a simple table works better than a chart. You'll also learn to add slicers and drill-down, and to use conditional formatting so that significant variances stand out.
Hands-on: Build the budget versus actual report page.
Sharing and Refresh
A report only helps if the right people can see current figures. We show you how to publish to a workspace and share reports with colleagues. We also cover setting up scheduled refresh, and good habits for working in shared workspaces.
Hands-on: Publish your report and set a refresh schedule.
Day 4 Power Automate
Automation Basics
We introduce Power Automate and what it can do for finance teams. You'll learn the difference between automated flows, which start when something happens, instant flows, which you start yourself, and scheduled flows, which run at set times. We also explain the difference between standard and premium connectors, which affects what you can build with your licence.
Hands-on: Build a simple instant flow.
Triggers and Actions
Every flow starts with a trigger and then carries out actions. We look at the triggers most useful in finance, such as a new email arriving, a new file being added or a set time of day. We then cover common actions in Outlook, SharePoint, Excel and Teams.
Hands-on: Trigger a flow from an email with an attachment.
Conditions and Expressions
Real processes involve decisions, so this module shows you how to build them into a flow. We cover conditions, switch statements and loops. We also introduce simple expressions for working with dates, text and numbers, keeping the focus on what finance users will actually need.
Hands-on: Route invoices differently depending on the supplier or amount.
Approvals
Approvals are one of the most valuable uses of Power Automate in finance. We look at the different types of approval, how to send a request to one person or several in sequence, and how to record the outcome. This gives you a clear audit trail of who approved what and when.
Hands-on: Add an approval step to your flow and log the result.
Error Handling
Flows sometimes fail, and knowing how to find and fix the problem matters as much as building the flow. We show you how to read a flow's run history and identify what went wrong. We also cover run-after settings, retries and failure notifications, so you hear about a problem before it causes a missed deadline.
Hands-on: Break your flow on purpose, then find and fix the fault.
Invoice Intake Build
Now we bring the day together in a complete working process. Your flow will save invoice attachments from email into SharePoint, log the invoice details to a list or Excel table, and send each invoice for approval. This is a pattern you can adapt to many other finance processes.
Hands-on: Complete the invoice intake and approval flow from start to finish.
AI Builder Demonstration
To close the day, the trainer demonstrates how AI Builder can read invoices and extract details such as supplier, date and amount automatically. We explain the licensing it needs and help you judge whether the time saved would justify the cost for your volume of invoices.
Hands-on: Instructor demonstration only.
Day 5 n8n
n8n Fundamentals
n8n is a flexible automation tool that can connect to almost any system with an API. We start with the basics: the editor, workflows, nodes and executions. You'll see how data passes from one node to the next, which is the key to understanding how n8n works.
Hands-on: Build and run your first workflow.
Triggers and Credentials
We look at the different ways to start a workflow: on a schedule, from a webhook or manually. We also cover how n8n stores the credentials it uses to connect to other systems, and the good practices that keep those credentials safe.
Hands-on: Set up a scheduled trigger and connect an email account.
Working with APIs
Many finance systems and data services offer an API, and n8n's HTTP Request node lets you use them. We show you how to read API documentation without being a developer, send a request and make sense of the JSON data that comes back.
Hands-on: Fetch daily exchange rates from a public API.
Transforming Data
Data from an API rarely arrives in the shape you need. We cover how to filter records, map fields to the right names and apply simple logic with IF and Switch nodes. By the end of this module, you'll be able to turn raw data into a clean summary.
Hands-on: Shape the exchange rate data into a summary table.
Scheduled Finance Workflow
Here you put the day's learning together into a complete workflow. It runs on a schedule, collects data, writes the results to a spreadsheet and sends a summary by email or Teams. We also add error handling, so you're told if a run fails.
Hands-on: Complete the scheduled data collection and notification workflow.
Choosing Between n8n and Power Automate
With both tools now familiar, we compare them side by side. We look at the connectors each one offers, how they're hosted, what they cost, the skills they need and who will support them. This helps you choose the right tool for each process instead of defaulting to one.
Hands-on: Compare both tools for the process you mapped on Day 1.
Hosting and Data Protection
Where an automation runs affects how your data is protected. We compare cloud-hosted and self-hosted n8n and what each means for your organisation. We also cover your obligations under POPIA when financial or personal information passes through a workflow.
Hands-on: Review a workflow for data protection risks.
Day 6 Copilot and Governance
Copilot Overview
We begin with a realistic view of what Microsoft 365 Copilot can and cannot do in finance work. We explain how Copilot uses your data and why it can only see what you already have permission to access. This sets clear expectations before you start using it.
Hands-on: Explore Copilot across Excel, Word, Outlook and Teams.
Copilot in Excel
We show you how to ask Copilot in Excel for analysis, formulas, summaries and charts. The emphasis throughout is on checking every result against the source data, because Copilot can produce answers that look right but aren't. You'll build the habit of verifying before you rely on anything it gives you.
Hands-on: Analyse a trial balance with Copilot and verify every figure.
Variance Commentary
Writing variance commentary each month takes time, and Copilot can produce a useful first draft. Using the Day 3 data, you'll ask Copilot to draft budget versus actual commentary. We then show you how to spot statements the data doesn't support, and how to correct them before the commentary goes out.
Hands-on: Write and verify variance commentary for the Day 3 report.
Communication and Collaboration
We look at how Copilot can help with the writing that surrounds finance work. You'll practise drafting executive summaries in Word and emails in Outlook. We also cover meeting recaps and follow-up actions in Teams.
Hands-on: Turn your variance commentary into an executive summary.
Copilot with Power BI
Copilot can answer questions about a Power BI report and summarise what it shows. We try this on the report you built on Day 3 and look at where it helps. We also discuss the limits of AI-generated insights and why a person still needs to interpret the results.
Hands-on: Ask Copilot questions about your Day 3 report.
Prompting Well
The quality of Copilot's output depends heavily on how you ask. We cover practical techniques: giving context, specifying the format you want and refining your request step by step. You'll also learn to save prompts that work, so you can reuse them each month.
Hands-on: Build a short prompt library for your monthly reporting.
Governance
Automations need looking after, or they become a risk when someone leaves or a system changes. We cover data privacy and POPIA, access permissions and documenting each automation. We also discuss naming an owner and a backup for every automation, and reviewing and retiring automations that are no longer needed.
Hands-on: Create an automation register entry for each build from the course.
Summary and Next Steps
We close by reviewing what you've built over the six days. We discuss how to choose your first automation back at work and where to find help when you get stuck.
Requirements
- Comfortable with Excel: sorting, filtering, basic formulas and lookups.
- No programming or automation experience required.
- A work Microsoft 365 account with the access listed under Software and Licensing.
Licences must be confirmed for every participant before the course starts. Some modules become instructor demonstrations where a licence is not available, as shown below.
- Tool: Microsoft 365 | Licence needed: A business or enterprise plan with the Excel desktop app, Outlook, SharePoint and Teams (for example Business Standard, Business Premium, E3 or E5) | Days: All | If not available: Required. The course cannot run without it.
- Tool: Excel with Power Query | Licence needed: Included in the Microsoft 365 Excel desktop app for Windows | Days: 1, 2, 6 | If not available: Required.
- Tool: Power BI Desktop | Licence needed: Free download, Windows only | Days: 3 | If not available: Required. Install before Day 3.
- Tool: Power BI service | Licence needed: Power BI Pro (included in E5) or Premium Per User to publish and share reports in workspaces | Days: 3, 6 | If not available: Participants build locally; publishing and sharing become a demonstration.
- Tool: Power Automate (standard) | Licence needed: Included with most Microsoft 365 plans. Covers Outlook, SharePoint, Excel Online, Teams and Approvals | Days: 4 | If not available: Required for the Day 4 build.
- Tool: Power Automate Premium and AI Builder | Licence needed: Premium per-user licence or AI Builder capacity | Days: 4 | If not available: Instructor demonstration only. Not needed by participants.
- Tool: n8n | Licence needed: n8n Cloud subscription or a self-hosted instance, with a user account per participant | Days: 5 | If not available: A trainer-provided training instance can be used.
- Tool: Microsoft 365 Copilot | Licence needed: Paid Microsoft 365 Copilot or Copilot Business licence per participant | Days: 6 | If not available: Copilot Chat (free) for prompting practice; Excel, Power BI and Teams modules become demonstrations.
Participant Equipment
- A Windows laptop with the Microsoft 365 desktop apps installed (Power BI Desktop does not run on macOS).
- At least 8 GB RAM recommended for Power BI Desktop.
- A current version of Microsoft Edge or Google Chrome.
- Permission to install Power BI Desktop, or IT to install it in advance.
IT Preparation Before the Course
- Confirm each participant's Microsoft 365, Power BI and Copilot licences.
- Allow participants to create Power Automate cloud flows and use the Approvals connector.
- Provide a SharePoint site and a Power BI workspace for course exercises.
- Set up n8n user accounts and, if connecting to Microsoft 365, an Azure app registration.
- Check SharePoint and Teams permissions before Copilot is enabled, so it does not surface files to the wrong people.
Testimonials (4)
How to manage business financials
surprise mtileni - Hatima Holdings (Pty) ltd
Course - Learning Xero
Yaxşı ünsiyyət, müzakirələrə açıq yanaşma, maraqlı və cəlbedici bir atmosfer yaratma
Ahmet Keyman - Keytrade AG
Course - Management Accounting and Finance for Non-Finance Professionals
Machine Translated
Trenerin təcrübəsi və məzmunu çatdırma üsulu
Roggli Marc - Bechtle Schweiz AG
Course - FinOps
Machine Translated
The trainer did not leave a single minute unexploited! He was up a storm throughout every lesson and provided much material for whatever he dealt with.