PivotTables let you summarize and reorganize your data dynamically, but you can’t summarize just any dataset. In most cases, your data needs to be laid out as a data list.
- [Instructor] Pivot tables let you summarize and reorganize…your data dynamically,…but you can't summarize just any data set.…In most cases, your data needs to be laid out…as a data list, and even better,…formatted as an Excel table.…In this movie, I will show you how to set up your data,…so you can create a pivot table,…and also how to use an Excel table,…which is extremely useful, in and of itself.…My sample file is project analysis 0401,…and you can find it in the chapter four folder…of the exercise files collection.…
This workbook contains a single worksheet,…and on it I have a data list.…And when I say data list, I mean I have a set of columns,…in this case for year, month, quarter and so on.…And underneath it I have rows…that contain a full set of values for each of those columns.…The first row of data which starts at cell A2,…has the year 2016, month of January,…and then quarter, project, budgeted, and actual labor data…for that month, for that given project.…
The data continues down to row 13,…for that first project, and that is the last data,…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- 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