Module Build/Create Lessons:
Click to launch lesson; mouse-over to see description of lessons, above.Module:Build/Create Lesson 1 [0:30]
Adding fields, or data, to the pivot table involve dragging or placing data fields into one of four areas.
Adding fields, or data, to the pivot table involve dragging or placing data fields into one of four areas.
Module:Build/Create Lesson 2 [0:38]
The role of the four areas, and how each treats data.
The role of the four areas, and how each treats data.
Module:Build/Create Lesson 3 [0:58]
Data in proper table format has been created or obtained. Where to start?
How to request a new pivot table.
Data in proper table format has been created or obtained. Where to start?
How to request a new pivot table.
Module:Build/Create Lesson 4 [1:05]
Data in proper table format has been created or obtained. Where to start?
How to request a new pivot table for Excel 2007 users.
Data in proper table format has been created or obtained. Where to start?
How to request a new pivot table for Excel 2007 users.
Module:Build/Create Lesson 5 [1:04]
You are looking at an empty pivot table.
How to move fields into the appropriate area. How to select fields from the Fields List.
You are looking at an empty pivot table.
How to move fields into the appropriate area. How to select fields from the Fields List.
Module:Build/Create Lesson 6 [1:08]
You are looking at an empty pivot table.
How to move fields into the appropriate area. How to select fields from the Fields List.
Excel 2007 users.
You are looking at an empty pivot table.
How to move fields into the appropriate area. How to select fields from the Fields List.
Excel 2007 users.
Module:Build/Create Lesson 7 [2:09]
Here, adjusting Field Settings is required to get the desired display. Uses math-English college sections dataset.
Here, adjusting Field Settings is required to get the desired display. Uses math-English college sections dataset.
Module:Build/Create Lesson 8 [1:34]
How do you know what data area the pivot table contains? How to you adjust the coverage area?
How do you know what data area the pivot table contains? How to you adjust the coverage area?
There are 8 lessons in this module.
Module:
Module:
Build/Create.
Create a pivot-table from a prepared dataset.