|
|
Analyzing Data in the Pivot Section |
|
| |
|
Data Analysis and Reporting Document |
|
| CD06 |
|
|
|
| Focus On: |
|
Pivots |
|
|
Lesson No |
File Name |
Duration |
| |
Intro |
CD06 Introduction |
2:07 |
| |
1 |
01 Viewing the Pivot Section |
4:16 |
| |
2 |
02 Creating a Pivot |
2:55 |
| |
3 |
03 Pivoting Data |
2:25 |
| |
4 |
04 Renaming a Pivot |
1:40 |
| |
5 |
05 Deleting a Pivot Section |
:59 |
| |
6 |
06 Charting a Pivot |
1:32 |
| |
7 |
07 Selecting Pivot Elements |
3:31 |
| |
8 |
08 Moving Pivot Elements |
1:45 |
| |
9 |
09 Changing Nesting Levels |
2:37 |
| |
10 |
10 Sorting Pivot Data |
3:21 |
| |
11 |
11 Adding Totals and Subtotals |
2:06 |
| |
12 |
12 Adding Cumulative Totals |
1:30 |
| |
13 |
13 Using Data Functions |
2:48 |
| |
14 |
14 Making a Dimension a Fact |
1:47 |
| |
15 |
15 Drilling into Detail |
4:40 |
| |
16 |
16 Summarizing Pivot Data |
5:07 |
| |
17 |
17 Adding a Computed Item |
3:00 |
| |
18 |
18 Selecting Pivot Options |
1:50 |
| |
19 |
19 Hiding Pivot Data |
1:22 |
| |
20 |
20 Focusing on Pivot Data |
1:27 |
| |
21 |
21 Pivot Refresh Options |
1:34 |
| |
22 |
22 Displaying Corner Labels |
1:24 |
| |
23 |
23 Displaying Data Labels |
3:30 |
| |
24 |
24 Formatting a Pivot |
3:56 |
| |
25 |
25 Using Spotlighter |
3:56 |
| |
26 |
26 Exporting a Pivot |
3:59 |
| |
|
Total Time |
|
1:11:04