<div>
Looks good and I shall get a good start.<br />
<br />
Thanks for help
</div>


Looks good and I shall get a good start.

Thanks for help

<div>
<div class="content wysiwyg-content">
Can anyone provide the practical use of Excel's Consolidate and What-If Analysis? (It's under Data &gt;&nbsp;Data Tools)<br />
<br />
If you can provide a simple sample then it would be great!<br />
<br />
Thank you.
</div>
</div>


Can anyone provide the practical use of Excel's Consolidate and What-If Analysis? (It's under Data > Data Tools)

If you can provide a simple sample then it would be great!

Thank you.

Practical use of Excel Consolidate and What-If Analysis

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Analytics is the discovery and communication of meaningful patterns in data. Especially valuable in areas rich with recorded information, analytics relies on the simultaneous application of statistics, computer programming and operations research to quantify performance. Specifically, areas within analytics include predictive analytics, prescriptive analytics, enterprise decision management, retail analytics, store assortment and stock-keeping unit optimization, marketing optimization and marketing mix modeling, web analytics, sales force sizing and optimization, price and promotion modeling, predictive science, credit risk analysis, and fraud analytics.

Analytics

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.