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.

The five different PivotTable tips and the time they start is shown below.

00:00 Video introduction
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

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

The Ultimate Excel Course & Advanced Excel Tricks Bundle ► https://bit.ly/2YibpiM

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1

Видео 5 Advanced PivotTable Techniques канала Computergaga