Show Top Ten Results - Excel PivotTable Tricks
Filter your Excel PivotTable to display only the top ten results. This technique can be really awesome in Excel dashboards when space is limited.
See more PivotTable tricks on the Advanced Excel Tricks course - https://bit.ly/2UlTfvB
This video tutorial shows how to filter for the top ten results in an Excel PivotTable dashboard. The dashboard is set up with Slicers for interactivity. The top ten selling products created in the lesson complete the dashboard.
The video also shows how to stop columns from autofitting when data is filtered. This is a really useful skill when creating interactive dashboards.
You can also get your PivotTable to display the top 5, or top 15 results. It can also be used to display percentages such as top 10% or bottom 10%.
Here are the timings for the video.
00:00 - Introduction
01:55 - Create the PivotTable
03:42 - Show top ten in Excel PivotTable
05:26 - Connect the Slicers to the top ten PivotTable
06:17 - Stop PivotTable columns widths changing
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
Видео Show Top Ten Results - Excel PivotTable Tricks канала Computergaga
See more PivotTable tricks on the Advanced Excel Tricks course - https://bit.ly/2UlTfvB
This video tutorial shows how to filter for the top ten results in an Excel PivotTable dashboard. The dashboard is set up with Slicers for interactivity. The top ten selling products created in the lesson complete the dashboard.
The video also shows how to stop columns from autofitting when data is filtered. This is a really useful skill when creating interactive dashboards.
You can also get your PivotTable to display the top 5, or top 15 results. It can also be used to display percentages such as top 10% or bottom 10%.
Here are the timings for the video.
00:00 - Introduction
01:55 - Create the PivotTable
03:42 - Show top ten in Excel PivotTable
05:26 - Connect the Slicers to the top ten PivotTable
06:17 - Stop PivotTable columns widths changing
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
Видео Show Top Ten Results - Excel PivotTable Tricks канала Computergaga
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Create an Interactive Top N Report in Excel (includes duplicate values) with Filter FunctionIntroduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or DuplicatesExcel PivotTable Calculated ItemsDisplay Different Top n from a Slicer - EASY Trick Works in Excel or Power BIHow to build Interactive Excel Dashboards that Update with ONE CLICK!Top 10 with formulas in Excel | Automatically calculate Top 10 as data changes | Excel Off The GridExcel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)Setup a Slicer to Sort or Filter Another Slicer for Quick NavigationInteractive Excel HR Dashboard - FREE DownloadTop 10 Values with One Excel FormulaHow to Add a Search Box to a Slicer in ExcelExcel Dashboard Course #21 - Creating a Pivot table Dashboard with Slicers in Excel (in 15 minutes)Secrets to Building Excel Dashboards in Under 15 Minutes!Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX)Modern Excel Dashboard | Sales Analytics System | Video tutorial #1Advanced Pivot Table Techniques (to achieve more in Excel)MS Excel - Pivot Table Example 1 Video TutorialsExcel Slicers, Inside Out - includes workbook with step by step instructions