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

Comments

  1. Excellent video! Great tips and clear presentation. Bonus points for the table of contents with links to times in the description (this ought to be mandatory for videos like this). Keep it up!
  2. 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
  3. Quite boring tutorial for me because when you're advance user of pivot you won't need to have too detail explanation.
  4. That page is not clear. I am not able to see that. Pls make it correct
  5. Very helpful

    Thanks a lot
  6. great....Thanks
  7. Hi Alan.. thanks for the 5 tips in one video.. keeping my skills tuned up by watching everything you send me. Thumbs up!
  8. Great demon straight to the point!
  9. Thank you Computergaga. Excellent video 👍🏻
  10. Great video.
  11. someone copied your video
    https://youtu.be/du5DJDHRrVk
  12. awesome, thank you
  13. Thanks very much I practiced everyone of those tips
  14. Wow some great tips. Thanks.
  15. 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
  16. Thumbs up
  17. Great Video, do you have a tip on interactive dashboards and linking external data
  18. Thank you for this excel video,
  19. 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
  20. your tips are really awesome, concise and easy to understand. More value in less time. Thanks You.


Additional Information:

Visibility: 469669

Duration: 10m 9s

Rating: 2302