From the course: Excel: Scenario Planning and Analysis

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Walk through a scenario presentation

Walk through a scenario presentation

From the course: Excel: Scenario Planning and Analysis

Start my 1-month free trial

Walk through a scenario presentation

“

- [Instructor] Pivot tables let you analyze and reorganize your data dynamically which is a vital ability when performing retrospective analysis. In this movie I will go through a sample presentation that incorporates various methods for manipulating your data. My sample file is Project Analysis 0408 and that is a workbook that you can find in the chapter four folder of the exercise files collection. Good afternoon. Our team was asked to analyze budgeted and actual labor data for a series of four projects. We have the values for the years 2016 and 2017, have the values for 2016 showing here broken down by month. And scrolling down we can see the same values for 2017 as well as our totals. The budgeted values are fairly consistent so I'll switch over to a quarterly view which might be easier to see as a summary. I have been asked to display the actual data as opposed to what the budget looked like. So I will drag budgets out, bring actual in, and I will format the data so that you can…

Contents