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.

Excel Calendar with Holidays and Appointments

Excel Calendar with Holidays and Appointments This week’s post is a special post because it comes directly from the super-brain of one of our XelPlus community members, Adam Weaver. Adam holds both a PMP certification (Project Management Professional) and an RMP certification

Excel’s XLOOKUP – 5 Examples

Excel's XLOOKUP 5 Examples By now, you may have read about Excel’s new super lookup function called XLOOKUP. XLOOKUP has the promise of becoming the only lookup function you’ll ever need for virtually any lookup problem you encounter.  This will be a

Excel Lookup to the Left with XLOOKUP

Left Lookup in Excel with XLOOKUP (made easy) When users learn to perform a lookup in Excel, it doesn’t take long before a situation arises that causes the user to ask… “How do I perform a lookup to the LEFT?” Because most