What PivotTable is all about?

PivotTable is an essential Excel tool used to explore and analyse huge data set in order to generate an interactive and user friendly summary reports. Its ability to automatically group, sort and filter different subset of data, and ensure data are summarised by categories and sub categories are its cool features that stand it out[…]

Shares 0

Use Goal Seek to generates best input for target results

Goal Seek is another amazing “What-if” analysis tool in Excel, with cool features that are very useful in generating the best input for a formula you already know the result, but not sure of the exact input. The limitation here is that it only work with one variable input. Solver is an ideal tool in[…]

Shares 0

Scenario Manager and its Application

The process of trying out different value for formula to see how the changes will affect the outcome is known as What-If Analysis. Scenario Manager in other hand, is one of the tools used to create and save multiple assumptions “what-If” Scenario in Microsoft Excel. What-If Analysis tools are located in the Data Menu. ZHM[…]

Shares 0