5 Advanced PivotTable Techniques

5 advanced PivotTable techniques in Excel. PivotTables are one of Excel's most important tools. This video demo's 5 advanced PivotTable techniques. View More Tips - http://www.computergaga.com The five different tips and the time they start is shown below. 00:44 - Grouping fields by month and year 02:12 - Showing data as a percentage of total 03:43 - Using Slicers 06:15 - Creating a calculated field 08:50 - Applying Conditional Formatting to a PivotTable Sign up for the online Xtreme PivotTables course to become a PIVOTTABLE MASTER http://goo.gl/JCUz5Y Connect with us! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► http://www.twitter.com/computergaga1


  1. Great video even though you didn't order the Sum of Total Sales column in descending order after applying the conditional formatting which hurt my soul
  2. Quite boring tutorial for me because when you're advance user of pivot you won't need to have too detail explanation.
  3. That page is not clear. I am not able to see that. Pls make it correct
  4. Very helpful

    Thanks a lot
  5. great....Thanks
  6. Hi Alan.. thanks for the 5 tips in one video.. keeping my skills tuned up by watching everything you send me. Thumbs up!
  7. Great demon straight to the point!
  8. Thank you Computergaga. Excellent video 👍🏻
  9. Great video.
  10. someone copied your video
  11. awesome, thank you
  12. Thanks very much I practiced everyone of those tips
  13. Wow some great tips. Thanks.
  14. Thanks, very meaningful lecture I have Day book chart I couldn't create like list, and category please help in this regard. how would I send you the chart Thanks
  15. Thumbs up
  16. Great Video, do you have a tip on interactive dashboards and linking external data
  17. Thank you for this excel video,
  18. Hi , can you change nagative to positive number in a PivotTable? i am trying to show change in budget for last year and current year . Thanks
  19. your tips are really awesome, concise and easy to understand. More value in less time. Thanks You.
  20. can you use a less than symbol in calculated field, would it be something like this "<"& FieldName

Additional Information:

Visibility: 431985

Duration: 10m 9s

Rating: 2016