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 1 of 15

duration 59 seconds

1 control arrow

1 control arrow

1 control arrow

1 control arrow

From Melinda Ronca-Battista

10 plays 0
10 pivot table O3 avg and formatting 2 of 15

duration 39 seconds

10 pivot table O3 avg and formatting

10 pivot table O3 avg and formatting

10 pivot table O3 avg and formatting

10 pivot table O3 avg and formatting

From Melinda Ronca-Battista

12 plays 0
11 pivot table suppressing errors 3 of 15

duration 38 seconds

11 pivot table suppressing errors

11 pivot table suppressing errors

11 pivot table suppressing errors

11 pivot table suppressing errors

From Melinda Ronca-Battista

3 plays 0
12 change headers in pivot table 4 of 15

duration 33 seconds

12 change headers in pivot table

12 change headers in pivot table

12 change headers in pivot table

12 change headers in pivot table

From Melinda Ronca-Battista

2 plays 0
13 pivot table date grouping 5 of 15

duration 1 minute 16 seconds

13 pivot table date grouping

13 pivot table date grouping

13 pivot table date grouping

13 pivot table date grouping

From Melinda Ronca-Battista

1 plays 0
14 tabular format pivot table 6 of 15

duration 41 seconds

14 tabular format pivot table

14 tabular format pivot table

14 tabular format pivot table

14 tabular format pivot table

From Melinda Ronca-Battista

10 plays 0
15 expanding or collapsing pivot table groupings 7 of 15

duration 52 seconds

15 expanding or collapsing pivot table groupings

15 expanding or collapsing pivot table groupings

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 8 of 15

duration 2 minutes 22 seconds

16 pivot chart creation

16 pivot chart creation

16 pivot chart creation

16 pivot chart creation

From Melinda Ronca-Battista

1 plays 0
17 customizing pivot chart 9 of 15

duration 3 minutes 54 seconds

17 customizing pivot chart

17 customizing pivot chart

17 customizing pivot chart

17 customizing pivot chart

From Melinda Ronca-Battista

2 plays 0
18 pivot chart equal grouping by month 10 of 15

duration 37 seconds

18 pivot chart equal grouping by month

18 pivot chart equal grouping by month

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 11 of 15

duration 1 minute 12 seconds

19 adding 2nd pollutant to pivot chart

19 adding 2nd pollutant to pivot chart

19 adding 2nd pollutant to pivot chart

19 adding 2nd pollutant to pivot chart

From Melinda Ronca-Battista

2 plays 0
2 highlight last column 12 of 15

duration 14 seconds

2 highlight last column

2 highlight last column

2 highlight last column

2 highlight last column

From Melinda Ronca-Battista

4 plays 0
20 chart types incl pivot 13 of 15

duration 2 minutes 20 seconds

20 chart types incl pivot

20 chart types incl pivot

20 chart types incl pivot

20 chart types incl pivot

From Melinda Ronca-Battista

1 plays 0
21 secondary axis pivot chart 14 of 15

duration 4 minutes 58 seconds

21 secondary axis pivot chart

21 secondary axis pivot chart

21 secondary axis pivot chart

21 secondary axis pivot chart

From Melinda Ronca-Battista

3 plays 0
22 pivot table extract subset function 15 of 15

duration 1 minute 1 second

22 pivot table extract subset function

22 pivot table extract subset function

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…