Latest stories

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...

The Step-by-Step Guide to Creating Excel Heat Map That’ll Impress Your Boss

Creating excel heat map is an art. You need to know which colour combinations work better for your scenarios. According to a research conducted by Prof. Richard Wiseman, “about 25% of people found documents with colours are easier to analyse”.  In fact, colours can play a pivotal role in your analysis when you use it wisely. For example, if you’d like to highlight high-cost...

5 Clever Ways to Use Excel Go to Special Command

Excel Go to Special command has a special focus in the industry, do you know why..? As the name suggests, the user can quickly select a cell or a group of cells based on a preferred condition. For example, if you want to quickly see all formula cells in your workbook then your ideal option would be “Go to Special”. It’s not just limited to formulas, you can also use it for...

12 Spectacular Excel Skills Employers Looking for

It was 2010, I was just out of college and searching for my first job, I was scrutinised in an interview to check whether I have required excel skills or not. Thankfully I was fully prepared to answer their questions and got selected for the position. I think it’s most common situation for young & experienced professionals nowadays. Increasing dependency on excel is actually demanding...