I went from being a bad excel user to a professional after learning these excel tips and tricks. The good news is I’m going to teach you these tips using simple and real-life examples. There has been so much written about the best excel tips and tricks on the internet, I could literally find 2,23,000 exact matches by the time of writing this article. So, I don’t want to write one more article with all the garbage. ...
Almost everyone knows how to use filters in excel but very few know that there is visual filter called ‘slicer in excel’. Without any doubts filters are most commonly used functionality in excel to slice and dice data. Its very useful and easy to use when you have multiple columns. But given that filters work based on dropdowns the selections are hidden and only visible when you click on the dropdown. ...
We want to generate $1m Revenue in 2018 said by CEO. Well, that’s ambitious goal… Considering our current year Revenue is at $0.7m but how do we achieve that..? let’s see if we can use Excel Goal Seek to put some foundations. By the way, we are into Chocolate business. I’ll walk you through step by step on building various models to achieve 1m revenue target by using Goal Seek in excel. ...
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. ...
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..? ...
Can better data let you make better decisions..? Maybe yes, with Excel text formulas you can analyze data effectively. Every day your business will generate millions of lines of data, and most of the times your data will not be in a structured way, even the best technology in the world cannot give you ready-made data to support your decision-making process. I think that is the reason why we’re so heavily dependent on MS Excel from simple to complicated analysis. ...
Do you know even today 7 out of 10 people don’t know about MS Excel Alternatives.! Almost all Universities, Colleges, Schools, Business Houses, Financial institutions, use excel one or the other way. According to Chandoo.org, “about 80% of high paying jobs require advanced Excel skills” MS Excel is the first application that comes to our mind when we talk about Reporting or Analytical related stuff, indeed, it’s very well known fact and widely used spreadsheet application in the industry. ...