How to Reference Another Sheet Dynamically in Excel
You have an Excel formula such as =Denver!C10, but it keeps pointing to Denver when you need another sheet. You’d rather type a sheet name in a cell and have …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Use SUMIF Across Multiple Sheets in Excel
Monthly sales sheets in Excel often share the same layout, but you still need one total per drink across all those months. Using SUMIF across multiple sheets seems straightforward until …
How to Calculate a Running Total in Excel
A running total in Excel shows you the total so far on every row. It’s also called a cumulative sum. A running balance carries forward an opening balance, adding money …
How to Round to Significant Figures in Excel
Rounding to significant figures in Excel lets you report lab or science results to a consistent precision, even when your numbers have very different sizes. Counting starts at the first …
How to Calculate Monthly Averages in Excel
Monthly averages in Excel help you spot trends hidden among individual daily records, such as a change in your typical calories burned per workout. Each average combines the records from …
How to Repeat Rows in Excel
If you need to repeat rows in Excel, there’s no Repeat Rows button to do it for you. You might want each row repeated, the whole list repeated, or a …
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 …
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 …