Appending Multiple Excel Sheets using Microsoft Power Query - Excel - #shorts
Channel: Efficiency 365 by Dr Nitin
Date: 2022-02-02

Stop copy paste. Combine data from multiple sheets instantly. Do not append manually. 
Refresh in one click.
Use Get and Transform (Power Query).

Prerequisites:
Data must have same columns.
Data must be in tables.
Works in all versions of Excel including Excel 365. 
If you have an older version of Excel, Get and Transform option will not be there in the Data tab.
In that case, download Power Query Add-in from here:
https://www.microsoft.com/en-in/download/details.aspx?id=39379

Watch detailed video here:
https://youtu.be/-ChtiKoohjc

Hindi version:
https://youtu.be/EQSDCF7bUH4

Read blog articles about data clean-up:
https://efficiency365.com/2014/10/24/knowledge-pack-data-analytics/


Buy Dr Nitin Paranjape  Microsoft expert latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://hi.switchy.io/22B1
Excel to Power BI - https://swiy.io/pivotsh

Learn more from 1000+ blog articles by Dr Nitin Paranjape 
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn : https://www.linkedin.com/in/nitinparanjape/
Twitter : https://twitter.com/drnitinp

Production
--------------------
Music and Effects: https://www.epidemicsound.com 
Created using Camtasia: https://www.techsmith.com/video-editor
AI based captions: https://videoindexer.ai (Microsoft service)