How to Make a Pie Chart in Excel (With Percentages)
A pie chart in Excel shows how a total splits into parts, like how much of your weekly sales each product brings in. Making the basic chart takes a couple …
Steve Scott
How to Custom Sort Slicer Items in Excel (Months and Custom Order)
A slicer in Excel lists its buttons in alphabetical order by default. That’s fine for product names, but not for things that have a natural order. Shifts should run Morning, …
Convert Inches to Feet and Inches in Excel (Without the 5′ 12″ Bug)
If you have lengths stored in inches, like 71.8 for a dining table, you probably want to show them the way people read them: 5′ 11.8″. Excel has no built-in …
Calculate Income Tax in Excel Using Tax Brackets
If you want to work out how much federal income tax you owe in Excel, you can’t just multiply your income by one tax rate. The US uses progressive tax …
Highlight Entire Row Based on Cell Value in Excel
If you want Excel to color a whole row when one cell in it has a certain value, like every order marked Overdue, conditional formatting can do it for you. …
Remove Old Items or Blanks From a Slicer in Excel
If your slicer keeps showing items you deleted from the data, or a (blank) button nobody asked for, the problem sits in the PivotTable behind it. Refreshing doesn’t always help. …
How to Show the Slicer Selection in a Cell in Excel
A slicer makes it easy to see what you’ve filtered while you’re looking at it. But the moment you want that selection in a cell, for a report heading or …
Slicer Not Working or Greyed Out in Excel (How to Fix It)
A slicer is the easy way to filter a PivotTable or Table in Excel, so it’s annoying when the button is greyed out or the slicer stops responding. The cause …
Slicers vs Filters in Excel (Differences and When to Use Each)
Slicers and filters in Excel do the same basic job. They hide the rows you don’t want so you can focus on the ones you do. Where they differ is …
How to Use a Timeline in a PivotTable in Excel
A Timeline in Excel is a date filter for PivotTables. Instead of ticking dates in a drop-down, you drag across a bar of months, and the PivotTable shows only that …
How to Create an Interactive Dashboard in Excel (With Slicers)
An interactive dashboard in Excel puts your key numbers and charts on one sheet, and lets anyone filter all of them with a click. Pick a store or a date …
How to Extract a Word Containing Specific Text in Excel
Checking whether a cell contains some text in Excel is easy, but pulling out the whole word that holds that text takes a bit more work. Say a note reads …