In Cell Bar Chart With REPT Function

In-cell charts are awesome.And today, I’ll show you how to create an in-cell bar chart with REPT function.But, do they really worth your time?Yes.Here is the single important reason:They are easy to create and simple to use.Ahead, in this post, I’ll show a step by step process to create a decent bar chart with REPT […]

How Combine IF and AND Functions in Excel

As I told you, by combining IF with other functions you can increase its powers. AND function is one of the most useful functions to combine with IF function. Like you combine IF and OR functions to test multiple conditions. In the same way, you can combine IF and AND functions. There is a slight difference in using […]

How to Create a Dynamic Chart Title in Excel

We all love dynamic and interactive charts. They are awesome. But, do you know what is the most important part of a dynamic chart? That’s ➜ Chart Title By creating a dynamic chart title you can make your Excel charts more effective. Just think this way. You have created a dynamic chart in which values will change when current […]

How To Combine IF and OR Functions in Excel

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 OR functions is one the most useful formula combination in excel. In this post, I’ll show you why we need to combine IF and OR functions. And, […]

How to Use R1C1 Reference Style in Excel

 In Excel, there are two kinds of cell reference styles, first is A1 and second is R1C1. Most of the Excel users don’t even know about the existence of R1C1 reference style. But, some users love to use it and found it more convenient than A1 reference style. The R1C1 style is a kind of old one.It was […]