You could write down the fields and the order in which they appear, but it’s far easier to record a macro that configures the PivotTable for you.
- [Voiceover] When you work with pivot tables,…you will often find that you want to recreate…a particular configuration.…You can write down the fields and…the order in which they appear and in fact you should…but it's far easier to record a macro that…configures the pivot table for you.…In this movie, I will show you how to use a macro…to record a pivot table position.…My sample file is Project Analysis_04_06,…and you can find it in the Chapter 4 folder…of the exercise files collection.…
This pivot table summarizes labor data…for a series of projects over the years 2016 and 2017.…I currently have the pivot table set up…so that it shows quarterly results in the rows…and each of the projects in the column headers areas.…If I want to recall this position,…I can do that by recording a macro.…First I will need to start recording…so I'll go to the View tab on the ribbon…and yes I realize this is a little counterintuitive…but this is where they put macros.…
I'll go to the far right corner, or far right end,…and click the Macros button's down arrow…
- 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
Excel 2016: Business Process Analysiswith Curt Frye1h 25m Intermediate
Excel: Power Query (Get & Transform)with Oz du Soleil1h 49m Intermediate
1. Introducing the Art of Scenario Planning
2. Manage Scenarios in Excel
3. Establish Parameter Value Ranges
4. Present Scenarios Using PivotTables
Next steps1m 16s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.