People who use Pivot Tables regularly knows this issue very well. ….i.e. manually refreshing pivot tables in your workbooks. It’s perfectly alright to use the manual method if you have one or two pivot tables in your reports. …but what if you have 5 to 10 pivot tables and then you will need to refresh all of them regularly..? Well.. that’s a boring job. So with that in mind, I have written this tutorial to help you build your own Pivot table refresh macro to automate the process. ...

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 also cover some of the advanced techniques to create data validation list multiple selections using Indirect formula. ...

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 and same googling. ...

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

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

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

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 scenario then you might have to use Red, similarly Green for the low cost. ...

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

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 people with various skills in excel. ...

The engine needs powerful thrust for speed, whereas analyst needs a handful of Excel keyboard shortcuts to crunch data and convert that into a useful information. Indeed it’s not always a good idea to work with the mouse for selecting various options. According to thekeycuts average analyst can save 10.79 minutes a day & 47 hours a year by using shortcuts, that sounds a lot isn’t it..? Very often it’s a need for analysts to learn new excel shortcuts to meet the required speed, but the real problem is, how do you remember all the shortcuts..? ...