AWESOME Excel trick to combine data from multiple sheets
Reconcile & consolidate data from multiple worksheets automatically using this amazingly simple Excel trick. You can set up a repeatable process so that every month Excel automatically combines the data for you.
⏱ In this video 👉
==============
0:00 - Introduction to the combine sheets problem
1:01 - New file to consolidate the data
2:05 - Updating "power query" steps
3:07 - Cleaning up the combined data
5:35 - Loading data to Excel
5:58 - Testing with new data
6:48 - More Power Query
Sample files 📗📗👇
================
Download the sample clinic data here - https://chandoo.org/wp/wp-content/uploads/2021/11/awesome-clinics-log.xlsx
Combined workbook with query - https://chandoo.org/wp/wp-content/uploads/2021/11/combined-clinic-data.xlsx
Article on how to use Power Query - https://chandoo.org/wp/power-query-tutorial/
Learn Power Query (complete tutorial):
===============================
If you are new to Power Query then watch this complete tutorial (80 minutes) to understand it fully. https://youtu.be/PiFAa_jjaEI
My Power Query tips & tricks playlist:
==============================
Here is a playlist of all my PQ tips & tricks. Binge responsibly ;)
https://www.youtube.com/watch?v=PiFAa_jjaEI&list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
Have a beautiful day 😀🌼🌞
#PowerQuery #Excel
Видео AWESOME Excel trick to combine data from multiple sheets канала Chandoo
⏱ In this video 👉
==============
0:00 - Introduction to the combine sheets problem
1:01 - New file to consolidate the data
2:05 - Updating "power query" steps
3:07 - Cleaning up the combined data
5:35 - Loading data to Excel
5:58 - Testing with new data
6:48 - More Power Query
Sample files 📗📗👇
================
Download the sample clinic data here - https://chandoo.org/wp/wp-content/uploads/2021/11/awesome-clinics-log.xlsx
Combined workbook with query - https://chandoo.org/wp/wp-content/uploads/2021/11/combined-clinic-data.xlsx
Article on how to use Power Query - https://chandoo.org/wp/power-query-tutorial/
Learn Power Query (complete tutorial):
===============================
If you are new to Power Query then watch this complete tutorial (80 minutes) to understand it fully. https://youtu.be/PiFAa_jjaEI
My Power Query tips & tricks playlist:
==============================
Here is a playlist of all my PQ tips & tricks. Binge responsibly ;)
https://www.youtube.com/watch?v=PiFAa_jjaEI&list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
Have a beautiful day 😀🌼🌞
#PowerQuery #Excel
Видео AWESOME Excel trick to combine data from multiple sheets канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![COMBINE Multiple Excel WORKBOOKS into One | ExcelJunction.com](https://i.ytimg.com/vi/JiAYngRcN0s/default.jpg)
![Create a Pivot Table from Multiple Sheets in Excel | Comprehensive Tutorial!](https://i.ytimg.com/vi/Yv7QBZXEDDc/default.jpg)
![10 things you thought Excel couldn't do, BUT it does them SO WELL](https://i.ytimg.com/vi/HcY8sYesI3Y/default.jpg)
![Consolidate Excel Sheets with Power Query](https://i.ytimg.com/vi/YOC-pEIuHpA/default.jpg)
![](https://i.ytimg.com/vi/Stuv2zNi24A/default.jpg)
![MS Excel - Consolidation](https://i.ytimg.com/vi/_lT8CpBXAWg/default.jpg)
![The *ONLY* 10 Excel keyboard shortcuts you need to master](https://i.ytimg.com/vi/ykP-agYOtC4/default.jpg)
![Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)](https://i.ytimg.com/vi/fHFUh6EhBcw/default.jpg)
![8 strategies I used to learn & master Excel in a short time](https://i.ytimg.com/vi/K0UF-nSc_Mw/default.jpg)
![Stop using VLOOKUP in Excel. Switch to INDEX MATCH](https://i.ytimg.com/vi/ZI5FLSll9AY/default.jpg)
![How to use Microsoft Power Query](https://i.ytimg.com/vi/0aeZX1l4JT4/default.jpg)
![I no longer VLOOKUP(), I use this other function instead…](https://i.ytimg.com/vi/DDlZXXEI1bU/default.jpg)
![Excel - Merge Data from Multiple Sheets Based on Key Column](https://i.ytimg.com/vi/325GKIXPsSI/default.jpg)
![📊 How to Build Excel Interactive Dashboards](https://i.ytimg.com/vi/MTlQvyNQ3PM/default.jpg)
![Excel VSTACK 🍔 - Quickly Combine Data from Multiple Sheets (Excel Noob Vs Pro)](https://i.ytimg.com/vi/qNz35j5ZevQ/default.jpg)
![5 Conditional Formatting tips to make you a rock star at work 🤘](https://i.ytimg.com/vi/El28a08cXIU/default.jpg)
![Get Multiple Files Containing Multiple Sheets with Power Query](https://i.ytimg.com/vi/sLW3NbeGDy8/default.jpg)
![Combine Data From Multiple Worksheets into a Single Worksheet in Excel](https://i.ytimg.com/vi/dse9h2W4ejw/default.jpg)
![Consolidate & Clean Multiple Excel Sheets in One Pivot Table](https://i.ytimg.com/vi/FI4HkCzMaIk/default.jpg)
![How Power Query Will Change the Way You Use Excel](https://i.ytimg.com/vi/6lBqYInBldk/default.jpg)