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