The Excel Data Analysis Bootcamp 2023 – Master Sorting, Filtering, Charts & Statistics is a hands-on training course designed to turn you into a confident data analyst using Microsoft Excel. From data cleaning and organisation to advanced charting and statistical analysis, you’ll learn everything you need to transform raw data into meaningful insights that drive real-world results.

You’ll start with the fundamentals of sorting and organising data, learning how to create custom sort orders, sort by colour, and reverse lists for quick analysis. You’ll also master ascending and descending order sorting — a key step in structuring data efficiently for reports, dashboards, and business presentations.

Next, you’ll dive into filtering and cleaning data — one of the most important skills for every analyst. You’ll learn how to use number, text, and date filters, remove duplicates, extract unique values, and apply Excel’s FILTER function to isolate meaningful patterns within large datasets. These lessons ensure you can manage, refine, and prepare data accurately for deeper analysis.

Once your data is ready, the course moves on to visualisation. You’ll explore how to create stunning charts including columns, lines, pies, bars, and scatter plots, as well as more advanced visuals such as Gantt and area charts. You’ll understand when to use each chart type, how to customise designs, and how to communicate data stories visually to impress any audience.

In the later sections, you’ll work with Excel tables and add-ins, learning to use structured references and the Analysis ToolPak to streamline your analytical workflows. The course concludes with a deep dive into advanced statistical analysis, where you’ll perform descriptive statistics, build histograms, run ANOVA and F-tests, calculate moving averages, apply exponential smoothing, and explore correlations. Each exercise is demonstrated step-by-step with practical business-ready examples.

By the end of this bootcamp, you’ll have a complete toolkit for performing end-to-end data analysis in Excel. You’ll be able to clean, organise, analyse, and present data professionally — the same skill set used by data analysts, business professionals, and financial experts across industries.