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. Hi Alan.. thanks for the 5 tips in one video.. keeping my skills tuned up by watching everything you send me. Thumbs up!
  2. Hi sir Grouping dates in pivot table is not possible in 2016 excel could you please explain
  3. Great demon straight to the point!
  4. Thank you Computergaga. Excellent video 👍🏻
  5. Great video.
  6. someone copied your video
    https://youtu.be/du5DJDHRrVk
  7. awesome, thank you
  8. Thanks very much I practiced everyone of those tips
  9. Wow some great tips. Thanks.
  10. 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
  11. Thumbs up
  12. Great Video, do you have a tip on interactive dashboards and linking external data
  13. Thank you for this excel video,
  14. 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
  15. your tips are really awesome, concise and easy to understand. More value in less time. Thanks You.
  16. can you use a less than symbol in calculated field, would it be something like this "<"& FieldName
  17. How do I know what level I am using excel? Like beginner,intermediate or advanced, I have searched online but the definitions are ambiguous, one job asked what level am I using pivot tables with the same criteria mentioned above, how do I know if I'm advanced or another level?
  18. No no no no nooooo and no! The video's good but don't write nothing related to "advanced" in the title! Because all these techniques are really basic!!!
  19. Useful video. Thanks!
  20. hi Computergaga,

    Every time i tried to insert calculated field, i ended up getting the result of all zeros. Do you by any chance know what could possibly be the reasons why i always hit a snag?

    Cheers!


Additional Information:

Visibility: 393702

Duration: 10m 9s

Rating: 1715