How to Combine 100's of EXCEL Sheets using Power Query

Опубликовано: 23 Октябрь 2024
на канале: Data Untelligence
1,204
31

In just a couple of minutes, learn how to combine multiple sheets in excel into one table using power query. Whether it is just a couple, or 100's of sheets this tutorial will be able to help.

There are also many other 2 minute Excel formula videos to help you learn Excel.

Other 2 MINUTE FORMULA VIDEOS below:

Playlist:    • Add Months & Years in Excel - 2 Minut...  
Get First word from a cell:    • Get first word or get LEFT word in Ex...  
Get Last word from a cell:    • Get last word in Excel - 2 Minute Exc...  
Add months or years in formula:    • Add Months & Years in Excel - 2 Minut...  
Using wildcards in SUMIF:    • SUMIF CONTAINS in Excel - Using Wildc...  
multiple if statements:    • Excel IF function Multiple Criteria  
Learn the Vlookup formula:    • Vlookup formula in Excel - 2 Minute E...  
how to use the Rank formula and get unique ranks:    • Rank Formula in Excel - 2 Minute Exce...  
using the IF(Contains) formula:    • Excel If formula - If CONTAINS formul...  

Want to learn some quick tips in Excel Pivot Tables:
   • How to change date formats in Pivot T...