AWESOME Excel trick to combine data from multiple sheets

Chandoo
Chandoo
1 میلیون بار بازدید - 3 سال پیش - Reconcile & consolidate data from
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/upl...
Combined workbook with query - https://chandoo.org/wp/wp-content/upl...
Article on how to use Power Query - https://chandoo.org/wp/power-query-tu...

Learn Power Query (complete tutorial):
===============================
If you are new to Power Query then watch this complete tutorial (80 minutes) to understand it fully. Power Query Tutorial - What is it, ho...

Want more? Get my Power Query mini-course here 👉 https://chandoo.org/wp/power-query-po...

My Power Query tips & tricks playlist:
==============================
Here is a playlist of all my PQ tips & tricks. Binge responsibly ;)
Power Query Tutorial - What is it, ho...

Have a beautiful day 😀🌼🌞

#PowerQuery #Excel
3 سال پیش در تاریخ 1400/09/02 منتشر شده است.
1,090,037 بـار بازدید شده
... بیشتر