Learn how to use this life-changing feature of Excel called Power Query to automate 5 common Excel tasks. Everything from combining data files to replacing XLOOKUP. DOWNLOAD THE WORKBOOK ► https://www.excelcampus.com/powerquery/automate-5-excel-tasks-power-query/

LINKS

Get free weekly Excel tips: https://www.excelcampus.com/newsletter/

Free 60-minute Excel training session: https://www.excelcampus.com/blueprint

Join Our Comprehensive Excel Training Program: https://www.excelcampus.com/elevate

Related Content

Why/when you should use Power Query: https://youtu.be/NM36N6COMuQ
String parsing with formulas and Power Query: https://youtube.com/live/1ZYbfx25wwk

00:00 Introduction
00:20 Automating Data Preparation
02:42 Combining Data
04:12 Splitting and Grouping Data
05:38 Replacing XLOOKUP
07:30 Transforming for Data Analysis