CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... ---------------------------------- DOWNLOAD THE FREE MINI COURSE ON DASHBOARDS IN EXCEL: http://bit.ly/2x839VE --------------------------------- ► 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 ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY --------------------------------- TOP Videos: ► 5 Steps to Learn How to Make a Pivot Table in Excel • 5 Steps to Learn How to Make a Pivot... ► VLOOKUP - Complete Step by Step (without complications) • VLOOKUP - Complete Step by Step (without c... ► IF Function - I'll explain to you on the beach how to do the IF formula! • IF Function - I'll explain to you on the beach how ... ► How to make your Excel spreadsheet more beautiful and impress your boss • How to make your Excel spreadsheet more beauti... ► How to recover an unsaved Excel spreadsheet • How to recover an unsaved Excel spreadsheet --------------------------------- In today's video we will learn how to make a pivot table in Excel in 5 steps! Yes, I'll show you step by step how to make a pivot table in Excel! There are 5 steps to show you how to create and use a pivot table. In step number 1, we will try to understand what a pivot table is for. This tool can be used in many situations, but it is 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 “Pivot Table” option. Once this is done, a window will appear with some options to tell Excel where in your spreadsheet we are going to 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, because 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 side. 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 and one. 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 will start to take shape, with the regions arranged in rows and Male and Female in the table columns. In addition to the rows and columns, we need to place the Sales header in the Values ​​quadrant, because we want to add up the Sales of the table rows and columns. With what we have seen so far, I think you have already learned how to make a pivot table in Excel, even without having finished the steps, you have already managed to build the main part of this table! The penultimate step is a key step in learning a pivot table in Excel, because in it we will understand the various functions and applications that this tool has. By default, when we put Sales in Values, it automatically made a “Sum of Sales”. What few people know and is essential when learning Excel pivot tables is that you can change the type of operation that the table performs! How so? You can choose whether you want to add up the sales, calculate an average of the sales, find the smallest or largest sale, and so on. To do this, just click on the “Sum of Sales” arrow and go to “Value Field Settings”. In this window, just 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 of males in Rio de Janeiro, but we can't find out who these people are. How do you find out? Just double-click on the sales value and it will show in a new table! In this video, our goal was to teach you how to use a pivot table in Excel step by step, so that you can understand the main part of this tool, as well as some more specific details! --------------------------------------------------- #excel #vba #hashtagtraining