97,135 views
CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE FREE BASIC EXCEL MINI COURSE: https://excelparaestagio.klickpages.c... To receive daily Microsoft Excel, VBA and Power BI content for free, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-... In our videos we teach several Excel tips and Excel tricks so that you can develop in this tool! ----------------------------------------------------------------------- ► To Download the File Used in Class, Access: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► Blog: https://bit.ly/2MRUZs0 ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-... ► Tik Tok: https://bit.ly/3dUpwkW ----------------------------------------------------------------------- TOP Videos: ► The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP • The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP • ► VLOOKUP - Complete Step by Step (without complications) • VLOOKUP - Complete Step by Step (without complications) ► Pivot Table - How to make an Excel Pivot Table in 5 steps! • Pivot Table - How to make a Pivot Table... ► EXCEL SPREADSHEET to IMPRESS ANYONE • EXCEL SPREADSHEET to IMPRESS ANYONE... ► Learn EVERYTHING about how to create GRAPHICS in EXCEL • Learn EVERYTHING about how to create GRAPHICS... ----------------------------------------------------------------------- Hey Guys! In this class we will teach you how to join Excel files into a single worksheet without using VBA! That's right, we will teach you how to join Excel files with Power Query Excel so that you no longer have to work when you have to join several tabs from the same file or several different files into one. As we will show you two ways of doing it, we will use two Power Query tools to join several files into one. They are: combine and transform data and the transform data tool. This way we will be able to join this information into a single table! So let's go to the class so as not to miss any details of how to join Excel files using Power Query. ----------------------------------------------------------------------- #excel #vba #hashtagtrainings