Data Exploration with Excel Pivot Charts

Data Exploration with Excel Pivot Charts

Show Details

This series demonstrates how MS Excel pivot tables and charts can be used to quickly summarize and present air monitoring data. The actual data files used in this series can be downloaded at http://datatools.tamscenter.com

…Read more Less…

1 control arrow

duration 59 seconds

1 control arrow

1 control arrow

From Melinda Ronca-Battista

7 plays 0
10 pivot table O3 avg and formatting

duration 39 seconds

10 pivot table O3 avg and formatting

10 pivot table O3 avg and formatting

From Melinda Ronca-Battista

8 plays 0
11 pivot table suppressing errors

duration 38 seconds

11 pivot table suppressing errors

11 pivot table suppressing errors

From Melinda Ronca-Battista

2 plays 0
12 change headers in pivot table

duration 33 seconds

12 change headers in pivot table

12 change headers in pivot table

From Melinda Ronca-Battista

1 plays 0
13 pivot table date grouping

duration 1 minute 16 seconds

13 pivot table date grouping

13 pivot table date grouping

From Melinda Ronca-Battista

0 plays 0
14 tabular format pivot table

duration 41 seconds

14 tabular format pivot table

14 tabular format pivot table

From Melinda Ronca-Battista

9 plays 0
15 expanding or collapsing pivot table groupings

duration 52 seconds

15 expanding or collapsing pivot table groupings

15 expanding or collapsing pivot table groupings

From Melinda Ronca-Battista

1 plays 0
16 pivot chart creation

duration 2 minutes 22 seconds

16 pivot chart creation

16 pivot chart creation

From Melinda Ronca-Battista

0 plays 0
17 customizing pivot chart

duration 3 minutes 54 seconds

17 customizing pivot chart

17 customizing pivot chart

From Melinda Ronca-Battista

1 plays 0
18 pivot chart equal grouping by month

duration 37 seconds

18 pivot chart equal grouping by month

18 pivot chart equal grouping by month

From Melinda Ronca-Battista

1 plays 0
19 adding 2nd pollutant to pivot chart

duration 1 minute 12 seconds

19 adding 2nd pollutant to pivot chart

19 adding 2nd pollutant to pivot chart

From Melinda Ronca-Battista

1 plays 0
2 highlight last column

duration 14 seconds

2 highlight last column

2 highlight last column

From Melinda Ronca-Battista

4 plays 0
20 chart types incl pivot

duration 2 minutes 20 seconds

20 chart types incl pivot

20 chart types incl pivot

From Melinda Ronca-Battista

1 plays 0
21 secondary axis pivot chart

duration 4 minutes 58 seconds

21 secondary axis pivot chart

21 secondary axis pivot chart

From Melinda Ronca-Battista

2 plays 0
22 pivot table extract subset function

duration 1 minute 1 second

22 pivot table extract subset function

22 pivot table extract subset function

From Melinda Ronca-Battista

3 plays 0

Search for ""

Public, Restricted

27 Media

4 Members

Managers:: Melinda Ronca-Battista
Natasha Fulton
Jennifer Williams
ITEP Team
Appears In:: ITEP Tribal Data…