Only a few Excel users know about that we can create graphs with REPT function. Most people use the REPT function simply to repeat characters but the REPT function actually does much more than that. Some people think the REPT
Background Zeros are almost inevitable in a workbook. Sometimes you may change the appearance of the zero. Do you have the following ask? Display zero as blank cells Show zero as dash Hide zero without actually deleting zero In this
Generating random numbers is easy with Excel! Learn about generating uniform and normal random numbers in Excel to aid your business analysis!
Background Sometimes we have to sum the intersections of multiple ranges. Can you think of a formula? Using INDEX MATCH? INDIRECT? And nested IF function? I go through exactly the same thought process until I meet Intersection operator. Don’t panic
I will show you how to get unique values without unique function, by a standard formula or an array formula. Here is the perfect substitute for Unique.
Excel comes with great tools to compute the IRR on an investment. We are going to show you 3 methods in computing IRR and their limitations.
