IF Function is one of the most powerful functions in excel. And, the best part is, you can combine other functions with IF to increase its power. Combining IF and
In Excel, there are two kinds of cell reference styles……first is A1 and the second is R1C1.Well, most of the Excel users don’t even know about the existence of R1C1
In this post, I’ll reveal the secret about how I use VLOOKUP And MATCH to create data for my Dynamic Charts. I’ll also tell you about reasons to use VLOOKUP And MATCH to increase the power of VLOOKUP. But before doing this let me explain you everything about the combination of these two awesome functions.
If you know how to present data in an understandable and effective way, you can deliver your message strongly. For this purpose, one of my favorite things is a PICTOGRAPH.And in
Creating an In-Cell Column Chart by using the REPT Function is the second part of our in cell charting Series. Yesterday, I had used this text repetition formula to create a star rating template in Excel. Basic Idea of
Here is a quick tip for you… …to create a star rating template in Excel. To create this star rating template all you need is REPT function. REPT Function is useful……when you want