playlistduration

Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more.

by excelisfun · 78 videos

Total watch time

19h 18m

at 1× speed · exactly 19 hours, 17 minutes, 51 seconds at 1×

1×19h 17m 51s
1.25×15h 26m 17s
1.5×12h 51m 54s
1.75×11h 1m 38s
2×9h 38m 56s
Average video14m 51s
Longest1h 1m 5s
Shortest55s
Compare Open on YouTube JSON

Plan to finish

About 20 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 20 days. Turn on JavaScript to plan around your week.

Videos (78)

19h 18m in total · tick what you've watched

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

Videos to
Watched
1 Free Excel Business Analytics (Statistics & Math) Course at YouTube 0:55 2020-10-26
2 Basic Excel Business Analytics #01: Basic Business Analytics using Excel 5:04 2015-09-17
3 Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example 37:24 2015-09-17
4 Basic Excel Business Analytics #03: Goal Seek For What-If Analysis 5:29 2015-09-21
5 Basic Excel Business Analytics #04: Excel Formula for Units Break Even Point and a Unit Defect Rate 4:47 2015-09-21
6 Basic Excel Business Analytics #05: 1 Variable Data Table For What-If Analysis 11:32 2015-09-22
7 Basic Excel Business Analytics #06: 2 Variable Data Table For What-If Analysis 9:47 2015-09-22
8 Basic Excel Business Analytics #07: X-Y Scatter Chart: Fixed Cost Variable Cost Model 14:27 2015-09-23
9 Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT? 19:52 2015-09-24
10 Basic Excel Business Analytics #09: Shortest Distance Shipping Costs: INDEX, MATCH, & IF Functions 10:58 2015-09-26
11 Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models 17:17 2015-10-02
12 Basic Excel Business Analytics #11: Dynamic Grading Model: Excel Table feature & VLOOKUP 9:50 2015-10-02
13 Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology 15:48 2015-10-09
14 Basic Excel Business Analytics #13: Excel Data Analysis Features: Sort, Filter, Pivot Tables 21:39 2015-10-09
15 Basic Excel Business Analytics #14: Logical Formulas & Conditional Formatting to Visualizing Data 13:30 2015-10-09
16 Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart 11:52 2015-10-09
17 Basic Excel Business Analytics #16: Count Transactions by Hour Report & Chart 7:30 2015-10-09
18 Basic Excel Business Analytics #17: FREQUENCY Array Function for Frequency Distribution & Histogram 23:02 2015-10-10
19 Basic Excel Business Analytics #18: Data Analysis Add-in for Frequency Distribution & Histogram 9:34 2015-10-10
20 Basic Excel Business Analytics #19: Why PivotTables Rule for Frequency Distributions & Histograms 16:30 2015-10-10
21 Basic Excel Business Analytics #20: Skew: Shape of Histogram, Shape of Quantitative Data 3:19 2015-10-10
22 Basic Excel Business Analytics #21: AVERAGE, MEDIAN, MODE.MULT functions & PivotTable Mode 9:04 2015-10-10
23 Basic Excel Business Analytics 22 Geometric Mean Average Compounding Rate GEOMEAN RRI Function 11:33 2015-10-10
24 Basic Excel Business Analytics #23: Variability: Variance, Standard Deviation, Z-score and more 18:21 2015-10-10
25 Basic Excel Business Analytics #24: Empirical Rule, Calculating Probability NORM.DIST & NORM.S.DIST 13:59 2015-10-10
26 Basic Excel Business Analytics #25: Percentiles, Quartiles, 5 Number Summary using Excel Functions 13:17 2015-10-10
27 Basic Excel Business Analytics #26: Box & Whisker Plot. Chart Example in Excel 2016. 5:22 2015-10-10
28 Basic Excel Business Analytics #27: Clean & Transform Data: Formulas, Flash Fill, Power Query, TTC 29:49 2015-10-18
29 Basic Excel Business Analytics #28: Power Query: Import Multiple Text Files & Build Grade Dashboard 21:54 2015-10-19
30 Basic Excel Business Analytics #29: Power Query: Import Multiple Large CSV Files Into Data Model 11:20 2015-10-19
31 Basic Excel Business Analytics #30: Excel 2016 Power Query: Data Ribbon Tab, Get and Transform 5:14 2015-10-19
32 Basic Excel Business Analytics #31: Power Query: Import Multiple Excel Files with 1 Sheet Each 12:07 2015-10-20
33 Basic Excel Business Analytics #32: Power Query Import Multiple Excel Files with Multiple Sheets 8:59 2015-10-20
34 Basic Excel Business Analytics #33: Power Query: Transform Many Bad Data Files into Proper Data Set 11:22 2015-10-21
35 Basic Excel Business Analytics #34: Power Query: Import & Merge Multiple Sources Access, Text, Excel 5:01 2015-10-21
36 Basic Excel Business Analytics #35: Power Query to Get Data From Web Site & Import into Excel. 3:01 2015-10-21
37 Basic Excel Business Analytics #36: Power Query to Unpivot Data (Multiple Columns to Single Column) 6:16 2015-10-21
38 Basic Excel Business Analytics #37: Excel 2016 Data Tab, Get & Transform: Unpivot feature 6:52 2015-10-21
39 Basic Excel Business Analytics #38: PivotTable from 4 Million Records with Power Query & Data Model 10:56 2015-10-22
40 Excel Business Analytics #39: Import Related Tables: Power Query Merge? Data Model Relationships? 12:19 2015-10-22
41 Basic Excel Business Analytics #40: Introduction to PowerPivot & Data Modeling 36:23 2015-10-26
42 Basic Excel Business Analytics #41: Excel 2016: Introduction to PowerPivot & Data Model 10:53 2015-10-28
43 Basic Excel Business Analytics #42: Comprehensive PowerPivot, Data Model, DAX & Reporting Example 1:01:05 2015-10-29
44 Basic Excel Business Analytics #43: Visualizing Data: Table & Chart Guidelines 41:39 2015-11-03
45 Excel Magic Trick 1242: Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format 9:49 2015-11-06
46 Excel Magic Trick 1243: Transform GDP Data Set: Power Query 2nd Method or Advanced Filter? 10:41 2015-11-07
47 Basic Excel Business Analytics #44: Intro To Linear Regression & Scatter Chart 15:46 2015-11-26
48 Basic Excel Business Analytics #45: Covariance and Correlation to Measure Linear Relationship 15:58 2015-11-26
49 Basic Excel Business Analytics #46: Slope & Intercept for Estimated Simple Liner Regression Equation 18:29 2015-11-26
50 Basic Excel Business Analytics #47: SST = SSR + SSE & R Squared & Standard Error of Estimate 30:24 2015-11-26
51 Basic Excel Business Analytics #48: Data Analysis Regression feature 6:37 2015-11-26
52 Basic Excel Business Analytics #49: LINEST Array Function for Simple Linear Regression 4:45 2015-11-26
53 Basic Excel Business Analytics #50: Introduction to Multiple Regression, Data Analysis Regression 13:34 2015-11-26
54 Basic Excel Business Analytics #51: Testing Significance of Regression Relationship with p-value 20:45 2015-11-26
55 Basic Excel Business Analytics 52: LINEST, F.DIST.RT, T.DIST.2T & ABS Functions Test of Significance 8:31 2015-11-26
56 Basic Excel Business Analytics #53: Line Charts for Time Series Data 12:27 2015-12-04
57 Basic Excel Business Analytics #54: Basic Forecasting Methods & Measures of Forecast Error 32:13 2015-12-04
58 Basic Excel Business Analytics #55: Summary of 4 Basic Forecasting Methods & Mean Square Error 8:13 2015-12-04
59 Basic Excel Business Analytics #56: Forecasting with Linear Regression: Trend & Seasonal Pattern 25:22 2015-12-04
60 Basic Excel Business Analytics #57: Intro To Linear Programming using Algebra, Pencil & Paper 27:43 2015-12-12
61 Basic Excel Business Analytics #58 Excel Solver to Maximize Contribution Margin 16:37 2015-12-12
62 Basic Excel Business Analytics #59: Linear Program Special Cases: Infeasible, Unbound, Alternative 5:03 2015-12-12
63 Basic Excel Business Analytics #60: Excel Solver: Minimize Transportation Costs, Integer Variable 12:55 2015-12-12
64 Basic Excel Business Analytics #61: Find Alternative Optimal Solution For Transportation Problem 5:33 2015-12-12
65 Basic Excel Business Analytics #62: Excel Solver: Maximize Portfolio Returns 11:34 2015-12-12
66 Basic Excel Business Analytics #63: Excel Solver Binary Variable Choose Projects Limited Resources 7:26 2015-12-12
67 Basic Excel Business Analytics #64: Introduction To Monte Carlo Simulation In Excel 23:45 2015-12-23
68 Basic Excel Business Analytics #65: Create Random Variables: Custom, Binomial, Uniform, Normal 22:42 2015-12-24
69 Basic Excel Business Analytics #66: Monte Carlo Simulation for New Product, 3 Uncertain Variables 18:33 2015-12-25
70 Basic Excel Business Analytics #67: Monte Carlo Simulation for Marketing Analysis Binomial Variable 11:46 2015-12-26
71 Basic Excel Business Analytics #68: Monte Carlo Simulation Histogram for Construction Project Length 15:56 2015-12-28
72 Basic Excel Business Analytics #69: Monte Carlo Simulation for Baseball World Series 9:42 2015-12-30
73 Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups 30:33 2017-07-01
74 Excel Magic Trick 1444 Part 2: Count Customer Names for 8 Sales Coupon Groups 7:44 2017-07-02
75 Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups 18:09 2017-07-02
76 Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups 27:23 2017-07-06
77 Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719 7:19 2021-01-20
78 PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720 7:02 2021-01-25

Embed a badge

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

Watch time: 19h 18m · 78 videos

Markdown
[![Watch time: 19h 18m · 78 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ.svg" alt="Watch time: 19h 18m · 78 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/PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ 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.