PivotTables let you analyze and reorganize your data dynamically, which is a vital ability when performing retrospective analysis. In this video, watch a presentation that incorporates various methods for manipulating your data.
- [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 see…it as dollar signs.…
And there we have the actual values.…
Released
11/28/2017- Designing a scenario-planning exercise
- Estimating scenario plausibility and outcomes
- Establishing parameter value ranges
- Calculating the standard deviation of a dataset
- Indicating the probability of a scenario value occurring
- Walking through a scenario presentation
- Performing retrospective analysis using a PivotTable
- Changing PivotTable summary operations
Share this video
Embed this video
Video: Walk through a scenario presentation