Description
Instantly Fix Macros in Excel: https://vba.teachexcel.com?src=yt
Weekly Excel Tips in your Email: https://tips.teachexcel.com
In this tutorial, you’ll learn how to use Power Query in Microsoft Excel to build a self-updating dashboard that automatically combines multiple CSV files from a folder, cleans messy data, and updates your charts with one click.
This is one of the most powerful Excel automation techniques for analysts, finance professionals, and anyone working with large datasets.
We’ll take raw, messy CSV files and turn them into a clean dataset, then build a dynamic dashboard with PivotTables and charts that update instantly when new data is added.
What You’ll Learn:
- How to combine multiple CSV files in Excel automatically
- How to use Power Query to clean and transform data
- How to fix messy datasets (dates, text, duplicates, formatting)
- How to create a dynamic dashboard with PivotTables and charts
- How to build a “one-click refresh” system in Excel
- How to fix the double refresh issue (background refresh explained)
- How to make Excel dashboards update when new files are added
Instead of spending hours cleaning data every time you get a new file, you’ll build a system where:
- You drop a CSV into a folder
- Click Refresh
- Everything updates automatically
This is how modern Excel workflows are built.
If you'd like to learn more about automating Excel, check our Excel Automation Courses (linked below).
I hope you enjoy the video! :)
Don
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~ TeachExcel Tutorial Page ~~
https://www.teachexcel.com/excel-tutorial/2724/3?src=yt_v_Xy9bme6LYoE
~~ Excel Automation Courses (50-80% off) ~~
https://courses.teachexcel.com/
~~ AI Course Pre-signup Discount Offer ~~
https://notify.teachexcel.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
00:00 Intro
00:34 How the Auto-Updating Dashboard Works
01:50 How to Make an Auto-Updating Dashboard
08:30 How to Create a Dashboard with PivotTables
12:34 Build the Dashboard Visuals
16:23 Turn On Auto-Updating for the Dashboard
#excel #powerquery #howto