5 Step Pivot Table Overview Part 1: The Basics »»
5 Step Pivot Table Overview Part 2 - Layouts and Styles »» Work along on this spreadsheet: »» https://cutt.ly/up4excel021-3 FREE Shortcuts Cheat Sheet »» http://www.up4excel.co.uk/shortcuts
No one wants to mess about looking for the data they want within a pivot table. Luckily Excel provides some great features to sort and filter data in pivot tables that are easy to master.....and that’s what this video is all about!
In part 1 I gave you a complete overview of how to set up a pivot table and in part 2 how to lay it out well and format it nicely. In part 3 I'll show you how to sort and filer your pivot table and we'll add some cool features like slicers and timelines. There’ll be plenty of tips and tricks along the way too.
This video covers all the following:
» Setting up your data (Part 1:
» Pivot Table creation and basic layouts (Part 1:
» Layout options and styles (in Part 2:
» Sorting and Filtering PivotTables (in this video)
» Slicers and Timelines (in this video)
In my next video I'll be going through pivot table layout options in a lot more detail. Make sure you hit the subscribe button so that you don't miss out on that.
======================================================================================
Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time
Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.
Here’s some of the things you could do with the time you’re going to save:
» Invest in yourself, saving even more time with Up4Excel training videos
» Spend more of your time on interpreting rather than compiling reports
» Get ahead of the game and accelerate your next promotion
» Or perhaps leave work on time, or even early, and enjoy your home life
We regularly release videos packed full of ways to save time and impress those around you. Make sure you subscribe, and hit the bell icon so you don’t miss out and fall behind!
======================================================================================
The Webcam I Use:
Logitech C920 HD Pro Webcam, Full HD 1080p
https://amzn.to/2nlc9FE
Recommended Advanced Formulas Book:
Ctrl+Shift+Enter: Mastering Excel Array Formulas (by Mike Girvin of ExcelIsFun fame)
https://amzn.to/2ofPytU
======================================================================================
Get more FREE Training on Up4Excel here: https://cutt.ly/ewsz9Sn
5 Step Pivot Table Overview Part 1: The Basics »»
5 Step Pivot Table Overview Part 2 - Layouts and Styles »»
FREE Shortcuts Cheat Sheet »» http://www.up4excel.co.uk/shortcuts
Work along on this spreadsheet: »» https://cutt.ly/up4excel021-3
======================================================================================
▶️ DTube
▶️ YouTube
Congratulations @up4excel! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :
You can view your badges on your Steem Board and compare to others on the Steem Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPTo support your work, I also upvoted your post!
Vote for @Steemitboard as a witness to get one more award and increased upvotes!
Pivot tables rock, but power pivot is better :-)