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

In this step-by-step tutorial, we are going to take a look at how to split first and last name in excel with detailed examples. Data mining is 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 a better understanding after reading this tutorial....

August 23, 2016 · Sudheer Tammini

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 saturated with data and information, visualizations are a potent way to break through the clutter, tell your story, and persuade people to action, says Adam Singer – Analytics Advocate at Google....

July 25, 2016 · Sudheer Tammini

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

July 5, 2016 · Sudheer Tammini

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

Creating excel heat map is an art. You need to know which colour combinations work better for your scenarios. According to aresearch 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 scenario then you might have to use Red, similarly Green for the low cost....

May 2, 2016 · Sudheer Tammini

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 finding blanks, Comments, Errors, Conditional formatting, Data validation etc....

April 18, 2016 · Sudheer Tammini