Work along on this spreadsheet: »» https://cutt.ly/up4excel021-2
5 Step Pivot Table Overview Part 1: The Basics »»
FREE Shortcuts Cheat Sheet »» http://www.up4excel.co.uk/shortcuts
If you're not currently using pivot tables this video is going to transform your Excel experience.
In part 1 I gave you a complete overview of how to set up a pivot table. Now in part 2 I'll show you how to lay it out well and format it nicely. In part 3 we'll add some cool features. There’ll be plenty of tips and tricks along the way too.
If you want a copy of the spreadsheet we’ll be working on, plus the finished version at the end of the video, just click on this link:
»» https://cutt.ly/up4excel021-2
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 Part 3)
» Slicers and Timelines (in Part 3)
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
======================================================================================
5 Step Pivot Table Overview Part 1: The Basics »»
FREE Shortcuts Cheat Sheet »» http://www.up4excel.co.uk/shortcuts
Work along on this spreadsheet: »» https://cutt.ly/up4excel021-2
======================================================================================
▶️ DTube
▶️ YouTube