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

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 a perfect chart to use when you need to present single point […]

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

How to Create a Dependent Drop Down List in Excel

A drop down list is an awesome tool. You can pre-define some values and user can enter data by selecting one of those values.One of its advanced features is a “Dependent Drop Down List”.A dependent drop down is all about showing values in a drop down list according to the selection of the value in […]