Excel Business Analytics - Forecasting, Linear Programming, Simulation and More

Excel Business Analytics - Forecasting, Linear Programming, Simulation and More

ExcelIsFun via YouTube Direct link

Free Excel Business Analytics (Statistics & Math) Course at YouTube

1 of 78
Next

1 of 78

Free Excel Business Analytics (Statistics & Math) Course at YouTube

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Business Analytics - Forecasting, Linear Programming, Simulation and More

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.