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. That page is not clear. I am not able to see that. Pls make it correct
  2. Very helpful

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


Additional Information:

Visibility: 410447

Duration: 10m 9s

Rating: 1829