Videos
Welcome to our Excel video library, where you'll find comprehensive tutorials presented at various Excel and Data user groups.
Our videos cover topics that save you time and automate your data processes when using Excel.
Each tutorial includes downloadable files where applicable, so you can easily follow along and apply what you learn in the videos.
Explore our content to discover practical tips and advanced techniques that will transform the way you work with Excel, making your spreadsheets more efficient and effective.​
Automating Data Cleaning in Excel with Power Query
Summary
There are many ways to clean data in Excel using formulas and functions, but these can be manual and time consuming, especially if they need to be applied every time the data set is expanded.
Power Query is a tool in Excel which allows users to create a series of steps, such as removing duplicates, creating calculations and formatting text, that are remembered and automatically applied to a data set.
In this presentation I will go through all the steps of cleaning a messy data set in Excel using Power Query, showing how to automate repetitive tasks so Excel users will be able to spend less time on data cleaning and more time on data analysis.
Download Files
Raw Data April 23
Raw Data May 23
Dynamic Arrays in Excel
Summary
Traditional Excel formulas could only return a single value, but with the introduction of Dynamic Array formulas its now possible to return multiple values into a range of cells using just one formula.
I will go over new dynamic array functions, including FILTER, SEQUENCE, SORT, UNIQUE, as well as showing how these formulas can be combined with traditional formulas to make dynamic calculations that expand over multiple cells as the data changes.
​
If you currently find yourself having to repeat one formula over a large dataset and having to drag down those formulas every time your data expands, then watch this video and find out how dynamic arrays can help you create more flexible calculations.
Download Files
Dynamic Arrays