BIS155 Course Discussions Week 5

$4.50

BIS155 Course Discussions Week 5
Discuss and compare the data consolidation and What-If analysis Excel tools…

SKU: BIS 155 Data Consolidation and What-if Analysis Categories: , Tags: , ,

Description

BIS155 Course Discussions Week 5

BIS155 Course Discussions Week 5

Data Consolidation and What-if Analysis  All Students Posts – 39 Pages 

Discuss and compare the data consolidation and What-If analysis Excel tools. Under what circumstances would you use each of these tools? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used. Let’s begin by defining the terms we will be working with this week. What is meant by Data Consolidation?  What are some examples in which you might want to consolidate data?

When you do a What-If analysis it changes the values in the cells and that shows how that change affects the rest of the formulas in the worksheet.  You can use this if you own a company and want to build some budgets with a different amounts of revenue.  You tell Excel the formula to run and then it determines what values to produce…