Save time with Power Query!!
In this video we will learn how power query can help save time by automating repetitive tasks. We will learn how to connect to external data, perform some basic transformations and load data to pivot tables using power query.
Timestamps:
00:00 - Intro
02:25 - Connect to external data
05:33 - Power Query Editor interface
07:30 - Basic data transformations
09:46 - Merging data from different files
16:20 - Combine monthly data from separate files
Instagram: / skillnator0
Full youtube excel playlist: • Microsoft Excel
#exceltipsandtricks #exceldashboard #pivottables #excelcharts #excelmacros #powerquery #datacleaning #excelautomation