From the course: Excel: Scenario Planning and Analysis

Unlock the full course today

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

Define PivotTable dataset

Define PivotTable dataset

From the course: Excel: Scenario Planning and Analysis

Start my 1-month free trial

Define PivotTable dataset

“

- [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…

Contents