Excel Pivot Table
How to Create a Dropdown from a Slicer in Excel (with Easy Steps)
Learn how to create a dropdown from a slicer in Excel with simple steps—add a slicer, customize your pivot table, and finalize the dropdown.
Read article
Blog
1285 articles
Excel Pivot Table
How to Hide Filter Arrows in Excel Pivot Table
Learn how to hide filter arrows in Excel Pivot Tables by disabling field headers, captions, and using VBA for complete control.
Read article
Excel Pivot Table
How to Ungroup Dates in Excel Pivot Table (3 Simple Ways)
Learn how to ungroup dates in Excel Pivot Tables using the Ungroup feature, keyboard shortcuts, or by disabling auto grouping.
Read article
Excel Pivot Table
How to Group Dates by Month and Year in Excel Pivot Table
Learn how to group dates by month and year in an Excel Pivot Table using drag-and-drop and the Group Selection feature.
Read article
Excel Pivot Table
How to Sort Pivot Table by Sum of Values in Excel
Learn how to sort a Pivot Table by the sum of values using the Sort feature for horizontal sorting & a Calculated Field for vertical sorting.
Read article
Excel Pivot Table
How to Group Excel Pivot Table by Different Intervals
Learn how to group Excel Pivot Table data by equal or uneven intervals using built-in options or a helper column for better analysis.
Read article
![[Fixed] Cannot Group that Selection Error in Excel Pivot Table](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-excel-pivot-table-cannot-group-that-selection-67ca9338.webp)
Excel Pivot Table
[Fixed] Cannot Group that Selection Error in Excel Pivot Table
Fix the “Cannot group that selection” error in Excel Pivot Tables caused by wrong date formats, text strings, or Data Model issues.
Read article
Excel Pivot Table
How to Group Columns in Excel Pivot Table (3 Methods)
Learn how to group columns in Excel Pivot Tables using Calculated Fields, PivotChart Wizard, and Power Query for better data analysis.
Read article
![[Solved] Unable to Get the PivotFields Property of PivotTable Class](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-unable-to-get-the-pivotfields-property-of-the-pivottable-class-dde28374.webp)
Excel Pivot Table
[Solved] Unable to Get the PivotFields Property of PivotTable Class
Fix "Unable to get the PivotFields property of the PivotTable class" VBA error with solutions for field names, table references & selections.
Read article
Google Sheets Intermediate Tutorials
How to Refresh Data in Google Sheets
Google Sheets is a powerful tool for collaboration and data organization. Sometimes, you can see that your data isn’t updated when you are working with formulas, scripts, or other data connections. At that time, you need to refresh Google Sheets. In this article, I will describe how to refresh Google Sheets in many ways, from […]
Read article
How to Work with Version History in Google Sheets
When you edit your sheets, they are automatically saved in Google Sheets. You can see who made changes to what in your sheet. Additionally, you can view previous versions and restore any desired content. Checking version history in Google Sheets can keep your data secure. What Is Version History in Google Sheets? Version History is […]
Read article
Excel Pivot Table
How to Apply Conditional Formatting in Excel Pivot Table
Learn how to apply conditional formatting in Excel Pivot Tables using the formatting icon or by creating a new conditional rule.
Read article