Combine data from multiple Excel sheets or CSV / Excel files - Power Query -  Power BI -  ETL
Channel: Efficiency 365 by Dr Nitin
Date: 2020-04-27

#consolidate #msexcel #datacleaning 
Learn the 11th rule of clean data. Combine data from multiple files (Excel / CSV) and also from multiple sheets using Power BI (Power Query). Save hours of manual work. 
Learn how to use Power Query in Excel and Power BI to perform quick and efficient data analytics. Automate ETL without writing macros. 

Read articles by Dr Nitin Paranjape about Excel and #powerbi 
https://efficiency365.com/2014/10/24/knowledge-pack-data-analytics/