How to Calculate Employee Retirement Dates in Excel
You can calculate a retirement date in Excel from an employee’s birth date and retirement age. The formula depends on whether retirement falls on a birthday or at month-end. I’ll …
Steve Scott
How to Name a Range in Excel
A named range in Excel gives a cell or group of cells a label you can use in formulas instead of a cell address. That label stays connected to the …
How to Pull Stock Prices into Excel
You can get stock prices in Excel without copying each quote from a website. The Stocks data type connects a company or ticker symbol to its market information. Check the …
How to Extract Unique Values Based on Conditions in Excel
Getting unique values with criteria in Excel means keeping one copy of each value, but only from rows that meet your conditions. You might need a customer list for one …
How to Sum Multiple Columns With SUMIFS in Excel
The SUMIFS function in Excel adds values that meet your conditions, but summing several cost columns takes more than widening its sum range. When your criteria occupy one column, SUMIFS …
How to Find the Last Row With Data in Excel
If you add rows to a list every week, you’ll often need to know where the data ends. Sometimes you just want to jump there. Other times you need that …
How to Convert Date to Fiscal Year in Excel
A fiscal year is the 12-month period a company or government uses for its accounts, and it often doesn’t start in January. If your fiscal year runs from July to …
How to Filter Horizontally in Excel (Filter Across Columns)
Excel’s Filter button only works one way. It hides rows, so it can’t help when your data runs sideways, with each record in its own column. You see this layout …
How to Make a Slicer Drop-Down List in Excel
A slicer in Excel lets you filter a PivotTable with one click. But with a lot of items, it becomes a tall stack of buttons that crowds your report. A …
How to Add a Search Box to a Slicer in Excel
A slicer is great when it has five buttons. When it has 36, you end up scrolling up and down the list, hunting for the one item you want. Excel …
How to Limit a Slicer to One Selection in Excel
Slicers let anyone filter a report with one click. But some reports only make sense for one item at a time, like a sales summary for a single store or …
How to Change Slicer Font Size, Color and Style in Excel
Slicers are the easiest way to filter a report. But every new one looks the same, with small text on pale blue buttons that rarely match your workbook. You can …