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. …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
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 …
How to Calculate Age in Excel From Date of Birth
Working out someone’s age from their date of birth sounds like simple subtraction, but it isn’t. A person born in December isn’t a year older until December comes around. Excel …
How to Calculate an Annuity in Excel (Payment, Present Value, Future Value)
An annuity is a series of equal payments made at regular intervals, like a monthly payout from a retirement annuity or a fixed deposit into a savings plan. Excel handles …
How to Calculate BMI in Excel
BMI (body mass index) compares someone’s weight with their height, and Excel can work it out for a whole list of people with one short formula. The tricky part is …
How to Create a Gantt Chart in Excel
A Gantt chart in Excel shows every task in a project as a bar on a timeline. You can see what starts when, what overlaps, and when the project wraps …