playlistduration

Excel 2007 Statistics: Charts, Functions, Formulas

by excelisfun · 151 videos

Total watch time

1d 15m

at 1× speed · exactly 1 day, 15 minutes, 16 seconds at 1×

1×1d 15m 16s
1.25×19h 24m 13s
1.5×16h 10m 11s
1.75×13h 51m 35s
2×12h 7m 38s
Average video9m 38s
Longest38m 41s
Shortest1m 23s
Compare Open on YouTube JSON

Plan to finish

About 25 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 25 days. Turn on JavaScript to plan around your week.

Videos (151)

1d 15m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Excel Statistics 01: Intro To Excel 2007 for Statistics 10:10 2008-07-09
2 Excel Statistics 02: Calculations, Operators, Formulas 10:13 2008-07-09
3 Excel Statistics 03: Data Analysis Sorting & Pivot Tables 9:55 2008-07-09
4 Excel Statistics 04: Frequency Pivot Table Chart Basics 10:13 2008-07-09
5 Excel Statistics 05: Cell References in Formulas 9:35 2008-07-09
6 Excel Statistics 06: Don't get tricked by Number Formatting 10:22 2008-07-09
7 Excel Statistics 07: Calculate Proportions and Percentages 4:27 2008-07-09
8 Excel Statistics 08: Install Excel 2007 Data Analysis Add-in 2:44 2008-07-09
9 Excel Statistics 09: What Is Statistics? 10:28 2008-07-10
10 Excel Statistics 10: Data & Scales/Levels of Measurement 10:22 2008-07-10
11 Excel Statistics 11: Descriptive & Inferential Statistics 9:59 2008-07-10
12 Excel Statistics 12: Categorical Frequency Distribution w Formulas 10:36 2008-07-25
13 Excel Statistics 13: Column Chart From Frequency Distribution: 7:20 2008-07-25
14 Excel Statistics 14: Categorical Relative & Percent Freq. Dist. w Formulas 8:16 2008-07-25
15 Excel Statistics 15: Category Frequency Distribution w Pivot Table & Pie Chart 10:09 2008-07-25
16 Excel Statistics 16: Categorical Cross Tabulation with Pivot Table 7:51 2008-07-25
17 Excel Statistics 17: Categorical Cross Tabulation with Formulas 9:50 2008-07-25
18 Excel Statistics 18: Pareto Chart for Categorical Data See how to create 8:25 2008-07-25
19 Excel Statistics 19: Grouping Categories w Formula & Pivot Table 6:35 2008-07-25
20 Excel Statistics 20: P1 Quantitative Freq. Dist. w Formulas 10:17 2008-07-25
21 Excel Statistics 21: P2 Quantitative Freq. Dist. w Formulas 10:04 2008-07-25
22 Excel Statistics 22: Histogram & Ogive Charts & % Cumulative Frequency 10:07 2008-07-25
23 Excel Statistics 23: Skew in Histograms 4:00 2008-07-28
24 Excel Magic Trick 655: Frequency Polygon Line Chart 7:49 2010-07-17
25 Excel Statistics 24: Quantitative Freq. Dist. w Pivot Table 10:04 2008-07-28
26 Excel Statistics 25: % Freq. Dist.& Histogram w Pivot Table 10:02 2008-07-28
27 Excel Statistics 26: Cumulative Freq. Dist w Pivot Table (Running Total) 8:30 2008-07-28
28 Excel Statistics 27: Dot Plot Chart w REPT & COUNTIF functions 8:58 2008-07-28
29 Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions 7:27 2008-07-28
30 Excel Magic Trick 589: Stem & Leaf Chart for Decimals - Array Formula - Statistics 13:24 2010-05-03
31 Excel Magic Trick 376: Stem & Leaf Chart for Big Numbers 11:34 2009-08-27
32 Excel Statistics 29: Quantitative Cross Tabulation W Pivot Table 5:43 2008-07-28
33 Excel Statistics 30: Scatter Diagram for 2 Quantitative Variables 7:02 2008-07-28
34 Excel Statistics 31: Histogram using Data Analysis Add-in 8:54 2010-02-01
35 Excel Magic Trick 654: Charts: Line & X Y Scatter 3:39 2010-07-17
36 Excel Statistics 33: Measures Of Location 15:38 2009-06-29
37 Excel Statistics 34: MEAN, MEDIAN, MODE (Averages) 10:52 2009-06-29
38 Excel Statistics 35: Weighted Mean & Geometric Mean 13:54 2009-06-29
39 Excel Statistics 35.2: Geometric Average V Arithmetic Mean - Finance Example 8:49 2009-06-29
40 Excel Statistics 36: Trimmed Mean 4:36 2009-06-29
41 Excel Statistics 37: PERCENTILE & QUARTILE 9:00 2009-06-29
42 Excel Statistics 38: Data Analysis Add-in Rank & Percentile 8:06 2009-06-29
43 Excel & Statistics 39: Variability Chart - Visual Approach (Dispersion or Spread) 7:25 2009-06-29
44 Excel & Statistics 40: Range & Interquartile Range (Variability) 5:05 2009-06-29
45 Excel & Statistics 41: Sample Standard Deviation (Variability) 17:49 2009-06-29
46 Excel & Statistics 42: Coefficient of Variation 4:59 2009-06-29
47 Excel & Statistics 43: Data Analysis Add-in Descriptive Statistics 1:49 2009-06-29
48 Excel & Statistics 44: Skew & SKEW function 9:24 2009-06-29
49 Excel & Statistics 45: Z-Score (# Standard Deviations From Mean) 5:56 2009-06-29
50 Excel & Statistics 46: Chebyshev's Theorem 9:33 2009-06-29
51 Excel & Statistics 47: Empirical Rule (Bell Shaped Curve) 16:44 2009-06-29
52 Excel & Statistics 48: Empirical Rule vs. Chebyshev's Theorem 3:23 2009-06-29
53 Excel & Statistics 49: Outliers & Box Plot with Median and Mean 21:46 2009-06-29
54 Excel Statistics 50: Probability Basics (by hand notes) 23:39 2009-07-07
55 Excel Statistics 51: Probability Basics with Excel 31:18 2009-07-07
56 Excel Statistics 52: Probability Laws (by hand notes) 16:29 2009-07-07
57 Excel Statistics 53: Probability Laws with Excel 11:24 2009-07-07
58 Excel Statistics 54: Joint Probability Table and More! 11:54 2009-07-07
59 Excel Statistics 55: Probability Pivot Table 8:19 2009-07-07
60 Excel Statistics 55.5: Bayes Theorem Posterior Probabilities 5:26 2009-07-13
61 Excel Statistics 56: Discrete Probability Distributions (Basics) 19:09 2009-07-13
62 Excel Statistics 57: Build Discrete Probability Distribution & Chart 27:05 2009-07-13
63 Excel Statistics 58: Discrete Probability Chart with 2 Data Sets 6:59 2009-07-13
64 Excel Statistics 59: Discrete Probability Mean & Standard Deviation SUMPRODUCT function 19:40 2009-07-13
65 Excel Statistics 60: Budget Income Statement (Probability) SUMPRODUCT function 6:41 2009-07-13
66 Excel Statistics 61: Stock Expected Return & Standard Deviation (Probability) 6:43 2009-07-13
67 Excel Statistics 62: Binomial Experiments & Probabilities 24:06 2009-07-13
68 Excel Statistics 63: BINOMDIST & Mean & Standard Deviation For Binomial Probability Distribution 12:01 2009-07-13
69 Excel Statistics 64: Cumulative BINOMDIST with IF Function for Cumulative Distribution Charts 10:31 2009-07-13
70 Excel Statistics 65: POISSON function Poisson Probability Distribution 10:40 2009-07-13
71 Excel Statistics 66: Continuous Probability Distributions (Normal, Uniform, Exponential) 17:07 2009-07-17
72 Excel Statistics 67: Uniform Probability Distributions 14:00 2009-07-18
73 Excel Statistics 68: Normal (Bell) & Standard Normal Characteristics 13:40 2009-07-18
74 Excel Statistics 69: #1 Normal Probability Excel Functions & Area Charts 15:05 2009-07-18
75 Excel Statistics 70: #2 Normal Probability Excel Functions & Area Charts 18:08 2009-07-18
76 Excel Statistics 71: #3 Normal Probability Excel Functions & Area Charts 11:30 2009-07-18
77 Excel Statistics 72: Find X Given Normal Probabilities NORMINV & NORMSINV functions 5:00 2009-07-18
78 Excel Statistics 73: Exponential Probability EXPONDIST function 9:33 2009-07-18
79 Excel Statistics 74: Taking a Sample with RAND & VLOOKUP 13:42 2009-07-24
80 Excel Statistics 75: Point Estimates & Sample Error 16:00 2009-07-24
81 Excel Statistics 76: Sampling Distribution Of Sample Mean & Central Limit Theorem 24:06 2009-07-24
82 Excel Statistics 77: Probabilities for Sampling Distribution Of Sample Mean 13:03 2009-07-24
83 Excel Statistics 78 Relationship Standard Error & Sample Size 4:41 2009-07-24
84 Excel Statistics 79: Proportions Sampling Distribution 8:56 2009-07-24
85 Excel Statistics 80: Confidence Interval Sigma Known 25:48 2009-07-29
86 Excel Statistics 81 Confidence Interval Sigma Known From Raw Data 8:36 2009-07-29
87 Excel Statistics 82: Confidence Interval Sigma Not Known TINV function 11:41 2009-07-29
88 Excel Statistics 83: Confidence Interval For Advertising TINV function 5:14 2009-07-29
89 Excel Statistics 84 Confidence Interval Data Analysis Add-in Descriptive Statistics 5:44 2009-07-29
90 Excel Statistics 85: Confidence Intervals for Proportions #1 8:34 2009-07-29
91 Excel Statistics 86: Confidence Intervals for Proportions #2 4:52 2009-07-29
92 Excel Statistics 87: Sample Size for Confidence Intervals 7:55 2009-07-29
93 Excel Statistics 88: Confidence Interval & Hypothesis Tests 38:41 2009-08-04
94 Excel Statistics 89: Hypothesis Testing With Critical Value & p-value 36:22 2009-08-04
95 Excel Statistics 90: NORMSINV for Critical Value NORMSDIST for P-value 6 examples 7:41 2009-08-04
96 Excel Statistics 91: TINV & TDIST functions for Critical Value and P-value 6 examples 10:59 2009-08-04
97 Excel Statistics 92: Hypothesis Test T Distribution 6:46 2009-08-04
98 Excel Statistics 93: Hypothesis Test Proportions 7:18 2009-08-04
99 Excel Magic Trick # 10: 3 types of Averages! 4:08 2008-03-03
100 Excel Magic Trick #11: How Good Is Your Average? 5:00 2008-03-05
101 Excel Magic Trick # 3: AVERAGE & Go To Blanks 3:30 2008-02-29
102 Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions 4:48 2008-03-05
103 Excel Magic Trick #15: SUM or COUNT Above Some Limit! 4:44 2008-03-05
104 Excel Magic Trick # 274: Probabilities Binomial Distribution 22:31 2009-03-02
105 Excel Magic Trick #21: BINOMDIST function for Probability 8:00 2008-03-05
106 Excel Magic Trick #22: NORMDIST function for Probability 7:36 2008-03-05
107 Excel Magic Trick #248: PERCENTILE QUARTILE functions Decile 5:45 2009-02-04
108 Excel Magic Trick #19: Randomly Generate Words 3:35 2008-03-05
109 Excel Magic Trick #18: Randomly Generate Letters 4:35 2008-03-05
110 Excel Magic Trick #17: Randomly Generate Whole Numbers 4:12 2008-03-05
111 Excel Array Formula Series #3: Expected Return For Stocks 3:39 2008-06-26
112 Excel Array Formula Series #6: Statistics Bayes' Theorem 3:51 2008-06-26
113 Excel Array Formula Series #8: FREQUENCY function 5:27 2008-06-26
114 Excel Array Formula Series 12: MMULT function Matrix Algebra 2:22 2008-06-26
115 Excel Array Formula Series 14.1: Stock Returns 6:46 2008-06-26
116 Excel Array Formula Series #14.2: Beginning Stock Analysis 9:53 2008-06-26
117 Excel Array Formula Series 14.3 Portfolio Standard Deviation 9:57 2008-06-26
118 Excel Array Formula Series 14.4: Stock Portfolio Analysis 4:46 2008-06-26
119 Excel Magic Trick #97: AVEDEV function 2:24 2008-07-01
120 Excel Magic Trick #93: Gantt Cell Chart Conditional Formatti 3:54 2008-07-01
121 Excel Magic Trick #91: FORECAST function 1:44 2008-07-01
122 Excel Magic Trick #124: Box Plot or Box & Whisker 10:22 2008-10-17
123 Excel Magic Trick 145 p4 STDEV IF Standard Deviation IF 5:23 2008-10-28
124 Excel Magic Trick #145 p3 AVERAGE IF before 2007 Excel 2:36 2008-10-28
125 Excel Magic Trick #145 p2 MODE IF 4:40 2008-10-28
126 Excel Magic Trick #145 p1 MEDIAN IF 2:59 2008-10-28
127 Excel Magic Trick #168: Cross Tabulation For a Survey 6:27 2008-12-30
128 Excel Magic Trick #178: Best Value Per 1 Unit Of Stats Value 1:23 2009-01-03
129 Excel Magic Trick #203: SUMIF function formula 21 Examples of Different Criteria 10:50 2009-01-09
130 Excel Magic Trick #180: COUNTIF function formula 21 Examples of Different Criteria 9:42 2009-01-03
131 Excel Magic Trick #198: 3 Formulas For Frequency Distribution 6:22 2009-01-09
132 Excel Magic Trick #199: Histogram w Conditional Formatting 2:39 2009-01-09
133 Excel Magic Trick #243: MEAN MEDIAN MODE STDEV Histogram 11:14 2009-02-02
134 Excel Magic Trick 329: Frequency Polygon With 2 Or More Line 10:47 2009-05-29
135 Excel Magic Trick 337: RANK function 10 Examples 15:42 2009-06-15
136 Excel Magic Trick 476: SUMPRODUCT Function for Weighted Average Cost From Transaction Data 4:52 2010-01-08
137 Excel 2010 Preview #1: New Rank Function RANK.AVE 3:00 2009-07-25
138 Excel 2010 Preview #3: New Percentile Function PERCENTILE.EXC 4:14 2009-07-25
139 Excel 2010 Preview #7: Confidence Intervals for T-Distribution CONFIDENCE.T function 2:42 2009-07-29
140 Mr Excel & excelisfun Trick 21: Excel 2010 Sparklines (Amazing Cell Charts!!) 3:57 2009-07-31
141 Excel 2010 Preview #8: Five New T Distribution Functions that Replace TINV & TDIST 9:47 2009-08-07
142 Excel Magic Trick 498: 6 PivotTable Calculation Tricks (Pivot Table) 8:21 2010-02-05
143 Excel Magic Trick 536: List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Function 7:58 2010-03-02
144 Excel Magic Trick 564: Daily Gantt Chart 8:33 2010-04-05
145 Excel Magic Trick 565: Excel 2010 Daily Gantt Chart 11:14 2010-04-05
146 Excel Magic Trick 592: Extract Word That Occurs Most Frequently - MODE for Word - Data Array Formula 5:23 2010-05-07
147 Excel Magic Trick 636: Dynamic Frequency Table & Histogram Chart 17:52 2010-06-25
148 Excel Magic Trick 713: Count Max Number In Succession in Column FREQUENCY function magic! 5:37 2010-09-03
149 Excel Magic Trick 733: Expected Returns For Portfolio SUMPRODUCT & MMULT functions 9:00 2010-10-14
150 Excel Magic Trick 761: Formula Displaying Multiple Modes & Counting Modes Excel 2010 MODE.MULT 7:24 2011-03-02
151 Excel Magic Trick 973: List Multiple MODEs in Excel 2007 or earlier: COUNTIF or PivotTable 8:31 2012-11-06

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 1d 15m · 151 videos

Markdown
[![Watch time: 1d 15m · 151 videos](https://playlistduration.com/badge/playlist/PL532F30A36E392932.svg)](https://playlistduration.com/playlist/PL532F30A36E392932)
HTML
<a href="https://playlistduration.com/playlist/PL532F30A36E392932"><img src="https://playlistduration.com/badge/playlist/PL532F30A36E392932.svg" alt="Watch time: 1d 15m · 151 videos" width="210" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PL532F30A36E392932 returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.