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

➲ Continue Reading

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

➲ Continue Reading

Excel Monthly Expense Tracker [Free Download]

Tracking your expenses is one on the most important things to be successful. But sometimes, it’s really hard to track all of them.Whenever we spend our money somewhere we forget it after few days. And then, end of the month we are totally blank about our spending.So here’s the deal:We spend our most of the […]

➲ Continue Reading

Excel Daily Sales Report Template [Format]

One of the first templates which I created on Excel was for a Daily Sales Report.And while doing this, one thing which I had learned that you need a format which is quick and simple to use.You can’t spend a lot of time every day to create a sales report, especially at end of the day […]

➲ Continue Reading

How to Copy Chart Formatting To Another Excel Chart [Trick]

Let’s say, with your extreme efforts you have formatted a chart and then you realize that you have more charts to format.Applying the same formatting to all the charts is a tedious task, the same thing again and again.It’s a pain.The good news is: there is a super quick solution to your pain. All you […]

➲ Continue Reading