Practical Spreadsheet Solutions
Practical Spreadsheet Solutions
  • 67
  • 70 336
How to remove old redundant items from pivot table slicers in Microsoft Excel
Slicers are great for filtering pivot tables, but may get cluttered with redundant items that were deleted over time from the source data of the pivot table. A large number of old items in a slicer can be quite annoying to the user. So in this video you will see two methods, how to clean such messy slicers.
0:00 Introduction
0:39 Why slicer items turn redundant
1:57 Clean-up method 1 (using Slicer Settings)
2:39 Clean-up method 2 (using PivotTable Options)
For more content like this, please subscribe to my channel.
#MsExcel #ExcelTips #excel
Screenshots used with permission from Microsoft.
มุมมอง: 123

วีดีโอ

New trick to connect any chart to a pivot table + awesome dynamic sunburst chart in Microsoft 36512:26New trick to connect any chart to a pivot table + awesome dynamic sunburst chart in Microsoft 365
New trick to connect any chart to a pivot table + awesome dynamic sunburst chart in Microsoft 365
มุมมอง 267หลายเดือนก่อน
New easy method to connect any chart to pivot table data specially for Microsoft 365 and an awesome interactive sunburst chart as an application example. Pivot tables are very useful for analyzing data, but do not work with all chart types. In this video you will see how to connect any chart to a pivot table dynamically using a spill range. This solution is for Microsoft 365 desktop app and onl...
No more complex formulas that others just can't read - use function LET in Microsoft 3659:50No more complex formulas that others just can't read - use function LET in Microsoft 365
No more complex formulas that others just can't read - use function LET in Microsoft 365
มุมมอง 139หลายเดือนก่อน
Make long formulas readable by shortening repetitive formula parts and showing the calculation steps using the function LET in Microsoft 365. This function helps to simplify long formulas and increase calculation performance. The syntax of this function lets the user declare variables and specify the calculation in which these variables should be used. As an example you will see how to simplify...
Using table slicers with spilling formulas to make an engaging interactive chart in Microsoft 36519:49Using table slicers with spilling formulas to make an engaging interactive chart in Microsoft 365
Using table slicers with spilling formulas to make an engaging interactive chart in Microsoft 365
มุมมอง 3482 หลายเดือนก่อน
Slicers are a great feature for interactive reports, but you need to know a trick to use them with formulas. That is where the function SUBTOTAL can help to unlock the full potential of this interactive feature. The slicers can control tables by filtering rows and the SUBTOTAL function can ignore hidden rows. Slicer selections can be used in formulas by performing calculations with visible tabl...
Make an awesome interactive chart displaying aggregated numbers easily in Microsoft 36512:56Make an awesome interactive chart displaying aggregated numbers easily in Microsoft 365
Make an awesome interactive chart displaying aggregated numbers easily in Microsoft 365
มุมมอง 4732 หลายเดือนก่อน
Interactive charts can easily be made directly from spill ranges of formulas with dynamic array functions in Microsoft 365 and Excel for the web. The trick is to link the chart to the spill range of a SINGLE formula. Then the number of displayed chart categories will expand and shrink with the spill range. Using two separate spill ranges for the categories and values will not work, because the ...
A feature that you absolutely need to know to make EASY dynamic charts in Microsoft 3656:44A feature that you absolutely need to know to make EASY dynamic charts in Microsoft 365
A feature that you absolutely need to know to make EASY dynamic charts in Microsoft 365
มุมมอง 3293 หลายเดือนก่อน
The chart in this video displays a changing number of categories and can be built very easily from the spill range of a single formula with dynamic array functions. This method is an alternative to using dynamic named ranges as chart references and is available in Microsoft 365 and Excel for the web. In older versions you will still need to use dynamic named ranges for a similar effect. It is i...
Use table slicers to their full potential with the SUBTOTAL function in Microsoft Excel18:25Use table slicers to their full potential with the SUBTOTAL function in Microsoft Excel
Use table slicers to their full potential with the SUBTOTAL function in Microsoft Excel
มุมมอง 5534 หลายเดือนก่อน
Tables in Microsoft Excel can be used with slicers, just like pivot tables. Slicers are a great feature for interactive reports. The function SUBTOTAL can help you to unlock the full potential of slicers for formulas. Slicers can control tables by filtering rows and the SUBTOTAL function can ignore hidden rows. Slicer selections can be used in formulas by performing calculations with visible ta...
How to make an EASY color-changing rating chart in Microsoft Excel, no Visual Basic for Applications6:54How to make an EASY color-changing rating chart in Microsoft Excel, no Visual Basic for Applications
How to make an EASY color-changing rating chart in Microsoft Excel, no Visual Basic for Applications
มุมมอง 1975 หลายเดือนก่อน
To make an easy 5-star rating chart with changing colors in Microsoft Excel without using Visual Basic for Applications you will need to add additional columns with formulas to the score table, so that for each score only one column displays the achieved score based on meeting a condition. Other columns should not show any value. One more column is necessary as the background and its values sho...
How to add the pivot table grand total to a dynamic chart using as example a chart for NPS®22:36How to add the pivot table grand total to a dynamic chart using as example a chart for NPS®
How to add the pivot table grand total to a dynamic chart using as example a chart for NPS®
มุมมอง 1.2K6 หลายเดือนก่อน
How to add the pivot table grand total to a dynamic chart using as example a chart for NPS®
Calculation and an interactive chart for Net Promoter Score® survey results in Microsoft Excel17:57Calculation and an interactive chart for Net Promoter Score® survey results in Microsoft Excel
Calculation and an interactive chart for Net Promoter Score® survey results in Microsoft Excel
มุมมอง 5846 หลายเดือนก่อน
Calculation and an interactive chart for Net Promoter Score® survey results in Microsoft Excel
Trick to connect any chart to a pivot table + an awesome dynamic sunburst chart in Microsoft Excel12:03Trick to connect any chart to a pivot table + an awesome dynamic sunburst chart in Microsoft Excel
Trick to connect any chart to a pivot table + an awesome dynamic sunburst chart in Microsoft Excel
มุมมอง 2.3K6 หลายเดือนก่อน
Trick to connect any chart to a pivot table an awesome dynamic sunburst chart in Microsoft Excel
Making an interactive tornado (butterfly or pyramid) chart using one pivot table in Microsoft Excel11:07Making an interactive tornado (butterfly or pyramid) chart using one pivot table in Microsoft Excel
Making an interactive tornado (butterfly or pyramid) chart using one pivot table in Microsoft Excel
มุมมอง 374ปีที่แล้ว
Making an interactive tornado (butterfly or pyramid) chart using one pivot table in Microsoft Excel
How to add currency symbols to cells, chart elements, formulas, and pivot tables in Microsoft Excel10:59How to add currency symbols to cells, chart elements, formulas, and pivot tables in Microsoft Excel
How to add currency symbols to cells, chart elements, formulas, and pivot tables in Microsoft Excel
มุมมอง 769ปีที่แล้ว
How to add currency symbols to cells, chart elements, formulas, and pivot tables in Microsoft Excel
Colorful dynamic custom data labels made easy in Microsoft Excel10:36Colorful dynamic custom data labels made easy in Microsoft Excel
Colorful dynamic custom data labels made easy in Microsoft Excel
มุมมอง 758ปีที่แล้ว
Colorful dynamic custom data labels made easy in Microsoft Excel
Automate the bar of pie chart in Microsoft Excel: answering your questions13:03Automate the bar of pie chart in Microsoft Excel: answering your questions
Automate the bar of pie chart in Microsoft Excel: answering your questions
มุมมอง 581ปีที่แล้ว
Automate the bar of pie chart in Microsoft Excel: answering your questions
Automate the bar of pie chart and control it with a slicer for custom drilldown in Microsoft Excel9:24Automate the bar of pie chart and control it with a slicer for custom drilldown in Microsoft Excel
Automate the bar of pie chart and control it with a slicer for custom drilldown in Microsoft Excel
มุมมอง 2.6Kปีที่แล้ว
Automate the bar of pie chart and control it with a slicer for custom drilldown in Microsoft Excel
Stay on track of project deadlines by setting a self-updating reminder in Microsoft Excel10:23Stay on track of project deadlines by setting a self-updating reminder in Microsoft Excel
Stay on track of project deadlines by setting a self-updating reminder in Microsoft Excel
มุมมอง 130ปีที่แล้ว
Stay on track of project deadlines by setting a self-updating reminder in Microsoft Excel
Automate the pie of pie chart and control it with a pivot table to drill down any slice in MS Excel18:24Automate the pie of pie chart and control it with a pivot table to drill down any slice in MS Excel
Automate the pie of pie chart and control it with a pivot table to drill down any slice in MS Excel
มุมมอง 1.6Kปีที่แล้ว
Automate the pie of pie chart and control it with a pivot table to drill down any slice in MS Excel
Declutter a line chart by choosing shown product from a drop-down list (OFFSET or INDEX functions)14:07Declutter a line chart by choosing shown product from a drop-down list (OFFSET or INDEX functions)
Declutter a line chart by choosing shown product from a drop-down list (OFFSET or INDEX functions)
มุมมอง 328ปีที่แล้ว
Declutter a line chart by choosing shown product from a drop-down list (OFFSET or INDEX functions)
Charting a Dynamic Year-to-Date Period Using the INDEX Function in Microsoft Excel (Part 2 of 2)14:48Charting a Dynamic Year-to-Date Period Using the INDEX Function in Microsoft Excel (Part 2 of 2)
Charting a Dynamic Year-to-Date Period Using the INDEX Function in Microsoft Excel (Part 2 of 2)
มุมมอง 884ปีที่แล้ว
Charting a Dynamic Year-to-Date Period Using the INDEX Function in Microsoft Excel (Part 2 of 2)
Charting a Dynamic Year-to-Date Period Using the OFFSET Function in Microsoft Excel (Part 1 of 2)16:29Charting a Dynamic Year-to-Date Period Using the OFFSET Function in Microsoft Excel (Part 1 of 2)
Charting a Dynamic Year-to-Date Period Using the OFFSET Function in Microsoft Excel (Part 1 of 2)
มุมมอง 2.4Kปีที่แล้ว
Charting a Dynamic Year-to-Date Period Using the OFFSET Function in Microsoft Excel (Part 1 of 2)
Excel Chart with Rolling 6 Months, 12 Months, or User-Defined End Date using Dynamic Named Ranges20:48Excel Chart with Rolling 6 Months, 12 Months, or User-Defined End Date using Dynamic Named Ranges
Excel Chart with Rolling 6 Months, 12 Months, or User-Defined End Date using Dynamic Named Ranges
มุมมอง 14Kปีที่แล้ว
Excel Chart with Rolling 6 Months, 12 Months, or User-Defined End Date using Dynamic Named Ranges
Rotating Pie Chart in Microsoft Excel with Visual Basic for Applications24:42Rotating Pie Chart in Microsoft Excel with Visual Basic for Applications
Rotating Pie Chart in Microsoft Excel with Visual Basic for Applications
มุมมอง 6282 ปีที่แล้ว
Rotating Pie Chart in Microsoft Excel with Visual Basic for Applications
Highlight chart points with a click in a filtered Excel table to explain your key messages - Part 212:25Highlight chart points with a click in a filtered Excel table to explain your key messages - Part 2
Highlight chart points with a click in a filtered Excel table to explain your key messages - Part 2
มุมมอง 1402 ปีที่แล้ว
Highlight chart points with a click in a filtered Excel table to explain your key messages - Part 2
Highlight chart points with a click in an Excel table to explain key messages in your report- Part 117:06Highlight chart points with a click in an Excel table to explain key messages in your report- Part 1
Highlight chart points with a click in an Excel table to explain key messages in your report- Part 1
มุมมอง 922 ปีที่แล้ว
Highlight chart points with a click in an Excel table to explain key messages in your report- Part 1
Changing Visible Columns-Highlight Max and Min Values in an Interactive Chart in Microsoft Excel15:04Changing Visible Columns-Highlight Max and Min Values in an Interactive Chart in Microsoft Excel
Changing Visible Columns-Highlight Max and Min Values in an Interactive Chart in Microsoft Excel
มุมมอง 3702 ปีที่แล้ว
Changing Visible Columns-Highlight Max and Min Values in an Interactive Chart in Microsoft Excel
Sales Breakdown with an Interactive Sunburst Chart in Microsoft Excel9:02Sales Breakdown with an Interactive Sunburst Chart in Microsoft Excel
Sales Breakdown with an Interactive Sunburst Chart in Microsoft Excel
มุมมอง 3.6K2 ปีที่แล้ว
Sales Breakdown with an Interactive Sunburst Chart in Microsoft Excel
Dynamic Commenting of KEY Messages in a Chart using Microsoft Visual Basic for Applications- Part 221:19Dynamic Commenting of KEY Messages in a Chart using Microsoft Visual Basic for Applications- Part 2
Dynamic Commenting of KEY Messages in a Chart using Microsoft Visual Basic for Applications- Part 2
มุมมอง 1312 ปีที่แล้ว
Dynamic Commenting of KEY Messages in a Chart using Microsoft Visual Basic for Applications- Part 2
Dynamic Commenting of KEY Messages in a Chart using Custom Data Labels in Microsoft Excel- Part 115:17Dynamic Commenting of KEY Messages in a Chart using Custom Data Labels in Microsoft Excel- Part 1
Dynamic Commenting of KEY Messages in a Chart using Custom Data Labels in Microsoft Excel- Part 1
มุมมอง 4422 ปีที่แล้ว
Dynamic Commenting of KEY Messages in a Chart using Custom Data Labels in Microsoft Excel- Part 1
Draw ATTENTION to Your Reports with this Animated Custom Chart in Microsoft Excel19:40Draw ATTENTION to Your Reports with this Animated Custom Chart in Microsoft Excel
Draw ATTENTION to Your Reports with this Animated Custom Chart in Microsoft Excel
มุมมอง 1732 ปีที่แล้ว
Draw ATTENTION to Your Reports with this Animated Custom Chart in Microsoft Excel