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... BASIC EXCEL HANDBOOK [FREE DOWNLOAD]: https://www.hashtagtreinamentos.com/h... ----------------------------------------------------------------------- ► To Download the File Used in the Class, Access: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/t... ----------------------------------------------------------------------- Recommended Videos: ► The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP • The 5 FORMULAS Excel BASIC that you... ► VLOOKUP - Complete Step by Step (without complications) • VLOOKUP - Complete Step by Step (without c... ► Pivot Table - How to make an Excel Pivot Table in 5 steps! • Pivot Table - How to make an Excel Pivot T... ► 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 Impressives! In today's class I want to talk about Pivot Table from Basic to Advanced. So I'm going to show you some basic information, but some advanced information about pivot tables that will help you a lot and make you keep your information correct and up to date. I'm going to talk about pivot table fields (to show you how to insert information into the pivot table), pivot table formatting (the correct way). I will also comment on the use of the format as table tool in Excel together with the use of the pivot table. An important point is how to update the pivot table, because it is not enough to just update your database; you also need to update the pivot table. Another very interesting point is the data segmentation in the pivot table, which greatly facilitates the use of filters and also makes this selection much easier and more visual. Finally, I will show you how to perform calculations in the pivot table using the calculated fields! ----------------------------------------------------------------------- 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 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! ----------------------------------------------------------------------- Class Content 00:00 Introduction 00:34 Explanation of the Database 01:15 How to Create a Pivot Table? 02:28 How to Insert Information in a Pivot Table? (Basic) 04:05 Filter in a Pivot Table 04:59 Formatting a Pivot Table 07:49 Value Field Settings (Analysis Types) 09:24 How to Refresh a Pivot Table? 13:38 Format as a Table in Excel (Dynamic Update) 15:44 Segmenting Data in a Pivot Table 16:47 Calculations in a Pivot Table (Calculated Fields) 20:00 Conclusion #excel #hashtagtrainings