TUDO sobre TABELA DINÂMICA no EXCEL

CLICK HERE TO LEARN MORE ABOUT THE COMPLETE EXCEL IMPRESSIONADOR COURSE: https://lp.hashtagtreinamentos.com/es... ---------------------------------- DOWNLOAD THE FREE MINI-COURSE ON DASHBOARDS IN EXCEL: https://excelparaestagio.klickpages.c... --------------------------------- ► Spreadsheet used in the video: https://pages.hashtagtreinamentos.com... --------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/t... --------------------------------- Hashtag Training ► Subscribe to our channel: https://www.youtube.com/hashtagtreina... ► Turn on notifications (click the bell icon)! ► Like our video! --------------------------------- Social Media ► YouTube:    / hashtagtreinamentos   ► Instagram:   / hashtagtreinamentos   ► Facebook:   / hashtagtreinamentos   ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-... ► TikTok:   / hashtagtreinamentos   --------------------------------- Top Videos: ► 5 Steps to Learn How to Create a Pivot Table in Excel    • 5 Passos para Aprender Como Fazer Tabela D...   ► VLOOKUP - Complete Step-by-Step (no complications)    • PROCV - Passo a Passo Completo (sem compli...   ► IF Function - I'll explain how to use the IF formula on the beach!    • Função SE - Te explico na praia como fazer...   ► How to make your Excel spreadsheet more beautiful and impress your boss    • Como deixar a planilha excel mais bonita e...   ► How to recover an unsaved Excel spreadsheet    • Como recuperar planilha Excel não salvo   --------------------------------- In today's video, we'll learn how to create a pivot table in Excel in 5 steps! These 5 steps will show you how to create and use a pivot table. In step number 1, we'll try to understand what a pivot table is for. This tool can be used in various situations, but it's generally used to quickly and easily create management summaries. The second step of the video shows you how to insert a pivot table. This is very simple; just select the data that will serve as the source for the table, go to the "Insert" tab, and click on the "PivotTable" option. Once you do that, a window will appear with some options to tell Excel where in your spreadsheet you will place this table. Since the default option is already what we want, we don't need to change anything and just click "OK". Many people get lost in the third step, as this is where we understand how to create a pivot table in Excel. In this step, we build the table itself; that is, we tell Excel what information we want in the rows and columns. After creating the Excel pivot table, a window with options will appear on the right. In this window, we can select what to do with each of the headers in our database. In the example, we wanted to have all the cities arranged in rows and the genders in columns. To do this, we need to click on the desired header and drag it to the respective quadrant; that is, we will drag Region to Rows and the header containing Male and Female to Columns. Once this is done, our Excel pivot table begins to take shape, with the regions arranged in rows and Male and Female in the columns of the table. In addition to the rows and columns, we need to place the Sales header in the Values ​​quadrant, because we want to sum the Sales from the rows and columns of the table. Based on what we've seen so far, I think you've already learned how to create a pivot table in Excel. Even without finishing all the steps, you've already managed to build the main part of this table! The penultimate step is key to learning pivot tables in Excel because it's where we'll understand the various functions and applications this tool offers. By default, when we enter Sales in Values, it automatically performs a "Sum of Sales". What few people know, and is fundamental when learning Excel pivot tables, is that you can change the type of operation the table performs! How so? You can choose whether you want to sum sales, average sales, find the lowest or highest sale, and so on. To do this, just click the "Sum of Sales" arrow and go to "Value Field Settings". In this window, simply choose the operation you want to perform. The last step is a simple step on how to use a pivot table that makes all the difference when it comes to saving time! For example, we can see the sales value for men in Rio de Janeiro, but we can't identify who these people are. How do we find out? Simply double-click on the sales value and it will appear in a new table! --------------------------------------------------- #excel #vba #hashtagtreinamentos