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 […]

How to Create a Bullet Chart in Excel

Step by Step Guide to Create a Bullet Chart in Excel Selecting a right kind of a chart is one of the toughest tasks. While struggling with these kinds of problems, I’ve found a chart called “Bullet Chart”.Bullet Chart is one of those advanced Excel charts which you should learn to get better at charting.It’s […]

10 Excel Charting Tips You Are Still Not Using

The moment you are reading this post you still have to explore a lot of things about excel charts unless you are “Jon Peltier“. Here in this post, I’ll show you 10 charting tips which you can instantly use while creating your next chart. I’m pretty sure that these charting tips will help you to […]

How to Create a Tornado Chart in Excel

Tornado chart is useful for those who want to analyze their data for better decision making. It’s a useful tool for sensitivity analysis, but you can use it for comparison purpose as well.It’s like a two-sided bar chart (looks like a tornado) where we have two data bars opposite to each other. It makes it […]

1 17 18 19 20 21 28