Sales people often need to estimate the sales of upcoming months. They do it with a handful of techniques that uses both quantitative analysis as well as qualitative judgment.
The MINIFS function is an advanced statistical function, which is only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).
One have seen different types of graphics that display information, ranging from simple charts, to dashboards and miniature charts like spark lines and so on, but one of them that appealed me a lot from artistic point of view is a word cloud.
Businesses are all about decision making. If you are working for a firm, whether it is producing goods or providing services, you must have come across situation where you need to do the “What-If” Analysis. One of the most helpful tools in this context is “Goal Seek”.
When we are developing a model or trying to test some formula, we need data and when we don’t have one, we have to create it to suit our needs. This is frequently called dummy data.
The Sparkline in Excel is a tiny chart, which can be included within the background a cell. This is used to provide visual representation of data, showing the variations, minimum/ maximum values and data trends.
Conditional Formatting is a widely used tool of Excel that provides pre-determined formatting to be applied to a cell or range of cells. The formatting may depend on the cell value or the content of it