107,425 views
How to Join SEVERAL SPREADSHEETS Directly from the Folder with Power Query - 30 Excel Lessons 21/30 Free Excel Course: https://bit.ly/EXCEL-GRATUITO Excel Courses https://cursos.ninjadoexcel.com.br In this class, I will teach you how to join several spreadsheets into one using Power Query. Learn in a simple, easy way that will help you a lot. This feature is extremely useful, as it is possible to join several spreadsheets into one directly in the Windows folder (for example). In order for you to be able to combine several spreadsheets into one, all spreadsheets must have the same pattern, the same sequences and number of columns. Therefore, I advise you to keep ONLY the spreadsheets you want to consolidate in the folder where you will find the spreadsheets. Watch the step by step and you can't go wrong! Download the Folder with the Files: https://1drv.ms/u/s!AmMwzGRjZm49gdEvA... Link to this class: How to Join SEVERAL SPREADSHEETS Directly from the Folder with Power Query - 30 Excel Classes 21/30 • Access Bar Quick in Excel AUL... Are you already subscribed to the channel? Click here and sign up: https://www.youtube.com/user/ninjadoe... ----------------------- EXCEL COURSES If If you want to learn Excel directly from me, access the link and see the available courses. LIMITED SPACES. Complete Excel Course: https://bit.ly/3BqaAcQ ----------------------- MY CONTACTS ▶ www.ninjadoexcel.com.br ▶ Group Studies on Facebook: https://www.fb.com/groups/ninjadoexce... ▶ Facebook: http://www.fb.com/ninjadoexcel ▶ / edsoncavalcantejunior ▶ Email: [email protected]