Latest stories

How to Create Appealing Excel Data Validation Drop Down List

If you haven’t used excel data validation drop down list in your reports then you are mostly missing something “really big”. The combination of well-structured drop down list and formulas like Indirect, Sumifs & Vlookup are the deadly combinations for Excel dashboards. So, in this step by step tutorial, I’m going to cover how to create drop down list in excel. We will...

[Solved] Excel cannot create or use the data range too complex

There are a lot of issues in Excel. The most annoying one is “Excel cannot create or use the data range too complex”. I’m sure, by referring above sentence you will not be able to figure out route cause of the problem. Then, what will you do? You will google it… ….there will be some workaround and the problem is solved¬†[tempreoraly]. Some other day again same problem...

How to Split First and Last Name in Excel [with examples]

In this step by step tutorial, we are going take a look at how to split first and last name in excel with detailed examples. Data mining is a cumbersome work!You need to have a better understanding of various excel text formulas and tools like the Text to Columns to deal with the situation. If you happen to be the one who lacks these skills, then no worries, you’ll certainly have...

Speedometer Chart – A Smart Solution to Present Your Data

The term speedometer is very well known in the automobile industry, however in today’s tutorial, we are going to take a look at how to create Speedometer Chart using google sheets. Creating visually appealing presentations is a key to a successful business meeting. Indeed, traditional excel charts will certainly boost your confidence but that’s not enough. In a world increasingly...

How Planned vs Actual Chart In Excel Can Ease Your Pain

The planned vs Actual chart in excel will give you an edge over traditional tabular analysis. In fancy terms, we call it as a Budget vs Actual analysis or Variance analysis. Indeed, it’s quite essential to assess the performance of our plans against actual results periodically. So, in this step by step tutorial, we are going to take a look at how to build planned vs actual graph in excel...