Discover hidden productivity tips when working with Excel Pivot Tables. At first Pivot Tables might seem like a complex tool but they are one of Excel's EASIEST features to work with. They help you summarize data really FAST. My Online Excel Courses https://www.xelplus.com/courses/ In this video I'll show you in about 10 minutes, how simple it is to create a pivot table and get quick insights into your data. I'll also throw in some Excel Pivot Table tips and tricks not everyone is aware of. To top it off we'll also add Pivot Slicers to get a professional visual to apply filters to our Pivot Table. Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ DOWNLOAD the workbook so you can practice with this Pivot Table example data (scroll down to the bottom of the post): https://www.xelplus.com/pivot-tables-in-10-minutes/ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ Timestamps 00:00 Why use Excel Pivot Tables? 01:35 Convert Data to Excel Tables 02:46 Create Pivot Table 04:08 Change aggregation in Pivot Table to average or count 04:40 Adjust number format in Pivot Table 05:10 Add filter to Pivot Table 05:28 Add column fields to Pivot Table 05:50 Removing Grand Totals and Sub Totals in Pivot Table 06:27 Update Pivot Table layout and design 07:14 How to bring back Pivot Table Fields dialog box 07:42 Update Pivot Table column header without errors (pivot table field name not valid) 08:33 Sort values in Pivot Table 08:41 Lock column width on Pivot Table refresh 09:00 Add Value as percentage of grand total in Pivot Table 10:22 Add Pivot Table Slicers to Filter Data 11:10 Connect Slicer to multiple Pivot Tables 11:50 Refresh Pivot Tables 12:40 Benefits of Pivot Tables EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ GEAR I use: https://www.xelplus.com/resources/#gear More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel