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.…
Author
Curt Frye
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
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 3s
-
-
1. Introducing the Art of Scenario Planning
-
2. Manage Scenarios in Excel
-
3. Establish Parameter Value Ranges
-
4. Present Scenarios Using PivotTables
-
Define PivotTable dataset6m 23s
-
Filter PivotTable data5m 10s
-
Link a macro to a shape6m 27s
-
-
Conclusion
-
Next steps1m 16s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Walk through a scenario presentation