Transform raw business data into executive-ready reports using Microsoft Copilot, Power Query and Excel in this practical, hands-on workshop
Stop spending hours cleaning data, writing formulas, and formatting reports manually. Learn a complete AI-powered reporting workflow that you can apply to your own work the very next day. Imagine transforming raw business data into executive-ready reports in a fraction of the time using Microsoft Copilot, Power Query, and Excel.
In this hands-on live workshop, Microsoft MVP Alan Murray will guide you through a complete reporting workflow, showing you how to use Microsoft Copilot alongside Excel, Power Query, and VBA to transform raw business data into polished, decision-ready reports.
Rather than exploring isolated Copilot features, you'll work through a practical end-to-end business scenario that demonstrates how AI can improve productivity across every stage of the reporting process—from cleaning data and generating formulas to building dashboards and extracting meaningful insights.
By the end of this workshop, you'll have the skills, prompts, and reusable resources to confidently integrate Microsoft Copilot into your everyday reporting workflow.
Speakers
Alan Murray
Microsoft MVP | Excel Expert | Founder, Computergaga
Good to know
Highlights
- 3 hours
- Online
Refund Policy
Location
Online event
Agenda
-
Welcome and Introduction
• Introduction and objectives • The business scenario we'll work through during the session • How Copilot fits into the modern Excel workflow
-
Understanding the Business Data
• We'll use Copilot to understand the information we're working with. • Explore and summarise the dataset • Identify data quality issues and inconsistencies • Ask questions using natural language • Understand what needs to happen before
-
Preparing Data for Analysis
• Learn how Copilot helps prepare data for reliable reporting and analysis. • Clean inconsistent data • Build and explain formulas • Apply conditional formatting to highlight issues • Document calculations and workbook logic • Use Power Query to automate repetitive data preparation