Answer to: Compare and contrast the data consolidation and what-if analysis Excel tools By signing up, you'll get thousands of step-by-step. Data consolidation and What-If Analysis are two completely different tools available in Excel However, there are situations in which these. Scenario Manager in excel is a What-if-Analysis tool, which shows the different Like Data Table, you now input values must change to achieve a specific goal.
Practical use of Excel Consolidate and What-If Analysis
Consolidating Data And What-if Analysis Works
Every day, most analysts merge data in Excel and other spreadsheet programs to get better insights. Consolidating data in Excel is part of a bigger process called data preparation, but as the number of new data sources increases, merging data in spreadsheets is getting harder to do. Because we at Trifacta are passionate about creating radical productivity for business analysts , we became experts in data preparation. So, we know from firsthand experience when consolidating data with a spreadsheet is a good idea, and how to do it well. Of course, you can always copy and paste data from smaller, simpler data sets; but most analysts find VLookup to be one of the most important tools for merging data in Excel when data sets get bigger. As the scale and complexity of your data sources grow, you might find merging data with Excel is harder to do. For large and varied data sets, Excel becomes too complicated, cumbersome , and slow to use.
Introduction to What-If Analysis
By using What-If Analysis tools in Excel, you can use several different sets of values in one or more formulas to explore all the various results. For example, you can do What-If Analysis to build two budgets that each assumes a certain level of revenue. Or, you can specify a result that you want a formula to produce, and then determine what sets of values will produce that result. Excel provides several different tools to help you perform the type of analysis that fits your needs.
Applies to first charge of a new subscription only. View Plans. IT issues often require a personalized solution. Start 7-Day Free Trial. Experts Exchange.