Combine Tables from Multiple Worksheets with Excel.CurrentWorkbook()

In this video, we combine tables from multiple worksheets using the Excel.CurrentWorkbook() M function in Power Query.

This function returns all tables and named ranges from the workbook. So in the video, we filter out the list to only combine the tables.

Some steps are then followed to clean the data before loading it to the worksheet.

This is a simple process to quickly combine data from multiple worksheets. It can be refreshed if the task is a regular one.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ► LinkedIn: 18737946
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1

• #howto_style
• #microsoft_excel
• #power_query
• #combine_tables
• #combine_worksheets
• #computergaga
• #combine_data_in_excel
• #combine_data
• #consolidate_worksheets
• #combine_tables_in_excel_from_different_sheets
• #combine_tables_in_excel_using_power_query
• #combine_tables_in_excel_by_column_headers
• #excelcurrentworkbook
• #excelcurrentworkbook_power_query
• #excel_combine_multiple_worksheets_into_one
• #excel_combine_tabs_into_one_worksheet
• #excel_combine_tables_from_multiple_sheets
• #excel_tips