97,535 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! ----------------------------------------------------------------------- ► Spreadsheet used in the video: 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... ----------------------------------------------------------------------- In today's class we will talk about the Google Sheets Query Function, which is one of the formulas used to join Google Sheets tabs. In addition to this function, we will also need to learn the Select Google Sheets to use together with the query function to be able to join tables in Google Sheets. This is an exclusive Google Sheets function, you will not find it in Excel. It works very similar to a query in a database and, with it, we can access several tables, tabs and even spreadsheets. Therefore, the Query Google Sheets function together with the Select Google Sheets are very useful and used to join tables, tabs and spreadsheets easily and dynamically. ----------------------------------------------------------------------- #excel #vba #hashtagtreinamentos