Do I need to be an expert?

No , but you should meet the prerequisites.

Do I need to know VBA?

No as VBA is not used during this workshop, built-in tools only.

Will I get the files?

Yes; sample data and post-course reference notes will be supplied.

Monday, 20 October

Excel Data Analysis & Visualisation

By DataCraft Solutions LTD

Learn how to analyze and visualize data like a pro using Excel in our online event!

Date and time

Location

Online

Agenda

Module 1: Clean & prepare data with Power Query

This module introduces you to common problems with raw data: inconsistent formats, blank rows, messy headers, and shows how to fix them quickly using Power Query. You’ll learn how to import files, ti...

Module 2: Explore data with Tables & formulas

Here we focus on building reliable reports with Excel Tables and dynamic arrays. You’ll discover how structured references make formulas clearer, and how functions like SORT, UNIQUE, and FILTER can r...

Module 3: Visualise findings with charts

In this module, you’ll learn how to choose and build the right chart for your message. We’ll link charts directly to dynamic ranges so they update automatically, and add simple interactivity with sli...

Module 4: Analyse using PivotTables

This section revisits Pivot Tables as a fast, flexible way to slice and dice cleaned data. You’ll see how to group, filter, and summarise information, and compare Pivot Tables with formula-based appr...

Module 5: Create a one‑page summary report

The final module brings everything together into a clear, professional summary report. You’ll combine cleaned data, dynamic summaries, and charts onto a single page, applying final polish so the repo...

Good to know

Highlights

7 hours
Online

Refund Policy

Refunds up to 7 days before event

About this event

Business • Other

Excel Data Analysis & Visualisation

Welcome to our online event where you will learn how to master Excel for data analysis and visualization! Join us for a hands-on workshop that will teach you valuable skills for manipulating data, creating charts, and presenting insights. Whether you're a beginner or looking to enhance your Excel expertise, this event is perfect for anyone interested in unlocking the power of data. Don't miss out on this opportunity to improve your data analysis skills from the comfort of your own home!

By the end of the day you’ll be able to:

Clean and reshape data with Power Query.
Build reports with Tables & dynamic formulas.
Use SORT, UNIQUE, FILTER for instant summaries.
Create visuals that update automatically.
Save time and cut reporting errors.

Who Should Attend?

Experienced Excel users who are already confident writing formulas such as VLOOKUP, MATCH, IF or other logic functions.
Professionals who can already create and adjust basic charts and summaries.
People who want to move beyond manual fixes and learn faster, smarter ways to analyse and visualise data.

Not suitable for: complete beginners or those unfamiliar with formulas and charts.

Recommended version: Microsoft 365 for Windows (Power Query + dynamic arrays).

Why Join?

Learn from an experienced Microsoft Excel trainer who has helped organisations across care, logistics, government, and financial services unlock the full potential of their data.

Gain practical skills you can use immediately in your role.

Reduce frustration, free up your time, and make Excel work smarter for you.

Book Your Place

Spaces are limited to ensure an interactive experience. Secure your place today and take the pain out of Excel reporting.

Organised by

DataCraft Solutions LTD

Followers

--

Events

--

Hosting

--