Excel Pivot Table
How to Change Slicer Color in Excel (2 Different Ways)
Learn how to change slicer color in Excel using built-in slicer styles or create custom styles with your own colors now.
Read article
Blog
1285 articles
Excel Pivot Table
How to Filter Excel Pivot Table Based on Cell Value
Filter Excel Pivot Tables based on cell values using column filters, label and value filters, slicers, or timelines for dates.
Read article
Excel Pro Tips
How to Display Text from Another Cell in Excel (8 Examples)
Display text from another cell in Excel using direct references, TEXT formatting, lookup formulas, named ranges, or conditional logic.
Read article
Excel Pro Tips
How to Trace Errors in Excel (2 Easy Methods)
Trace errors in Excel using the Trace Error feature from the context menu or Formulas tab to quickly identify and fix formula issues.
Read article
Excel Pro Tips
How to Make Excel Look Like a Page (with Simple Steps)
Make Excel look like a page using Page Setup, fit data to one page, adjust margins, add headers and footers, and preview print.
Read article
Excel Pro Tips
How to Recover Excel File After Crash (6 Possible Solutions)
Recover Excel files after a crash using Document Recovery, AutoRecover files, OneDrive restore, temp files, or unsaved workbooks.
Read article
Excel Pro Tips
How to Check Edit History in Excel Online (2 Quick Ways)
Learn how to check edit history in Excel Online using Show Changes to view edits or Version History to track full file changes.
Read article
Excel Pro Tips
How to Delete Hidden Rows in Excel (5 Suitable Ways)
Learn how to delete hidden rows in Excel manually, with filters, Go To Special, built-in tools, or a VBA script for large datasets.
Read article
Excel Pro Tips
How to Convert Minutes to Seconds in Excel (3 Simple Ways)
Learn how to convert minutes to seconds in Excel using simple multiplication, the CONVERT function, and time formats easily fast.
Read article
Excel Pro Tips
How to Export the Metadata of an Excel File (5 Different Ways)
Export Excel file metadata manually or with Get Data, Power Query, VBA, and PowerShell to extract document properties into sheets.
Read article
Excel Pro Tips
How to Fill Blank Cells with Text in Excel (6 Easy Ways)
Learn how to fill blank cells in Excel using Go To Special, IF formulas, Find and Replace, Power Query, and VBA scripts easily.
Read article
Excel Pro Tips
How to Copy Another Cell If a Cell Is Blank in Excel
Learn how to copy another cell when a cell is blank in Excel using IF, ISBLANK, LEN, TRIM, nested formulas, and VBA macros easily.
Read article