CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE FREE 16-CLASS 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... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/t... ----------------------------------------------------------------------- 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... ----------------------------------------------------------------------- Do you know the answer to the question I asked in the title? In this video I will explain a little more about the pivot table in Google Sheets, as well as its advantages and disadvantages in relation to the pivot table in Excel! I can already tell you that the Google Sheets pivot table has many similarities with the same tool in Excel. If you can build this tool in Excel, you will also know how to make a pivot table in Google Sheets. The step by step of how to create a pivot table is very simple, just click on a cell in the table you want to use as a basis, go to the Data tab and select the Pivot Table option. Having this tool in your dynamic spreadsheet makes it much more automatic and easier to analyze, creating automatic tables and graphs. A big difference between Google Sheets dynamic tables and Excel is that they update automatically! So, if you thought this was a problem, Google Sheets dynamic tables have solved this problem. The biggest disadvantage of a dynamic spreadsheet in Google Sheets is that its dynamic tables are not as customizable as Excel's. You cannot create a dynamic chart, data segmentation, timeline, and the like. Nor can you use some of the more specific formatting. Ultimately, as I mentioned at the beginning of the description, the two tools are very similar, so by understanding how to make a dynamic table in Excel you will also know how to make one in Google Sheets (except for a few small changes) ----------------------------------------------------------------------- #excel #vba #hashtagtraining