Michael Girvin - Business Department, Highline Community College

You Tube Excel Videos & Excel is
Fun Book

Home Page

Personal Info
Business Dept


Download PowerPoint (if you want):


Download "By Hand Notes":

None for this chapter

Download Solutions To Homework (Excel Workbooks):


Download Excel Workbooks To Complete While Watching Videos:


IF YOU ARE USING EXCEL 2007, because these all have the file extension ".xls", if you want the Pivot Tables to look the same as in the videos, after you create the Pivot Table, right-click the Pivot Table, point to Pivot Table Options, click on the Display tab, then uncheck the checkbox “Classic Pivot Table layout”.

Watch videos three different ways:

1) Custom Player, click and watch here (21 videos, 210 minutes):

2) Click on link to go to YouTube and watch videos (21 videos, 210 minutes)

Stats 12: Categorical Frequency Distribution w Formulas
Stats 13: Column Chart From Frequency Distribution:
Stats 14: Categorical Relative & Percent Freq. Dist. w Formulas
Stats 15: Categorical Freq. Dist. Pie Chart w Pivot Table &
Stats 16: Categorical Cross Tabulation with Pivot Table
Stats 17: Categorical Cross Tabulation with Formulas (Not required for class)
Stats 18: Pareto Chart for Categorical Data See how to create  (Not required for class)
Stats 19: Grouping Categories w Formula & Pivot Table
Stats 20: P1 Quantitative Freq. Dist. w Formulas
Stats 21: P2 Quantitative Freq. Dist. w Formulas
Stats 22: Histogram & Ogive Charts & % Cumulative Frequency
Stats 23: Skew in Histograms
Stats 24: Quantitative Freq. Dist. w Pivot Table
Stats 25: % Freq. Dist.& Histogram w Pivot Table
Stats 26: Cumulative Freq. Dist w Pivot Table
Stats 27: Dot Plot Chart w REPT & COUNTIF functions
Stats 28: Stem & Leaf Chart w REPT & COUNTIF functions (Not required for class)
Stats 29: Quantitative Cross Tabulation W Pivot Table
Stats 30: Scatter Diagram for 2 Quantitative Variables
Stats 31: Histogram using Data Analysis Add-in
Excel Statistics 32: Frequency Distribution Summary (Pivot Table & Formula)


3) Click on link to go to YouTube Playlist (21 videos, 210 minutes):
Excel Statistics Business Class Ch02: Descriptive Statistics

Other Related YouTube Videos:
Excel Magic Trick #61: Frequency Polygon Line Chart
Excel Magic Trick 329: Frequency Polygon With 2 Or More Line
Excel Array Formula Series #8: FREQUENCY function
Excel Magic Trick #93: Gantt Cell Chart Conditional Formatting

Michael GirvinOffice Hours and contact information