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