Excel Power Query and Power Pivot [Change the way you work with Excel] -Combine multiple Excel files
Excel Power Query and Power Pivot are some of the tools that once mastered will help you reclaim a big chunk of time lost in massaging data.
In this video, we look at 2 examples:
1. Use Power Query to combine sheets of data into one table.
2. Combine multiple Excel files in a folder using Power Query
We explore how to use Power Query to clean data and create scalable reports using Power Pivot.
Link to register for virtual Training:
https://datacycleanalytics.com/power-...
The techniques taught are also applicable if you are working with MS Power BI.
#PowerQuery #PowerPivot #PowerBI
_____________
SUBSCRIBE:
/ @williamthedataprof
_____________
Polish up your charting and data visualization skills. Get this FREE eBook:
https://datacycleanalytics.com/boardr...
Let’s connect:
Facebook: / billwilliamsk
LinkedIn [personal]: / william-kiarie-baab977a
LinkedIn [company]: / data-cycle-analytics-ltd