Excel IFS Function
The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.
Excel Multiple Match Results Simple
If you don't have the Filter function in Excel, you need to check out this easy formula approach to get multiple match results in Excel. Download the workbook and use the version that fits your example best.
Excel Dependent Drop Down Lists on Every Row
Create multiple dependent drop-down lists in Excel that you can copy to every row. You'll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.
Excel Dynamic Sorted Chart
Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.
Excel’s Secret Count Text Trick
Check out this Excel formula hack to count text cells only. This mysterious syntax, excludes blank cells, numbers and also cells with formulas that result in an empty string.
Time Value of Money
Time Value of Money “A dollar today is worth more than a dollar tomorrow.” It’s a saying that is true for any business as well as your own personal finances. It’s a simple principle that has a fancy name…Time Value of Money.
Calculating Returns for a Rental Property
Properly calculate returns on your rental property investment. This free Excel ROI calculator, makes it easy for you. In fact, you can use it to calculate the returns on any type of investment.
Excel Cell References
In the beginning days for any Excel user, there seems to be an unavoidable event that occurs. You’re cruising along typing in data and writing simple formulas. Then you are shown that a formula can be repeated across many rows of data using Fill Series or copy/paste. But then, IT happens!
Removing NonBreaking Spaces
Sometimes the data you copy or import into Excel has stubborn spaces that can't be removed with the TRIM function. You need a different function to remove these nonbreaking spaces. Something that acts like a TRIM ALL function in Excel.
Excel 3-D Formulas
With Excel 3D formulas you get to combine data from multiple worksheets into one summary sheet. This article includes a bonus Excel hack which shows you how to use wildcards in 3D reference formulas.