Learn basic business analytics using the latest version of Microsoft Excel

William Davis

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
77 Videos (19h 56m)
    • Basic Excel Business Analytics #01 Basic Business Analytics using Excel

      5:03
    • Basic Excel Business Analytics #02 Good Spreadsheet Model Design, Fixed Variable Cost Example

      37:23
    • Basic Excel Business Analytics #03 Goal Seek For What If Analysis

      5:28
    • Basic Excel Business Analytics #04 Excel Formula for Units Break Even Point and a Unit Defect Rate

      4:46
    • Basic Excel Business Analytics #05 1 Variable Data Table For What If Analysis

      11:31
    • Basic Excel Business Analytics #06 2 Variable Data Table For What If Analysis

      9:46
    • Basic Excel Business Analytics #07 X Y Scatter Chart Fixed Cost Variable Cost Model

      14:26
    • Basic Excel Business Analytics #08 Total Revenue Calculation VLOOKUP or LOOKUP SUMPRODUCT

      19:51
    • Basic Excel Business Analytics #09 Shortest Distance Shipping Costs INDEX, MATCH, & IF Functions

      10:57
    • Basic Excel Business Analytics #10 Find & Fix Excel Formula Errors in Spreadsheet Models

      17:16
    • Basic Excel Business Analytics #11 Dynamic Grading Model Excel Table feature & VLOOKUP

      9:49
    • Basic Excel Business Analytics #12 Raw Data, Data, Proper Data Sets and Data Terminology

      15:47
    • Basic Excel Business Analytics #13 Excel Data Analysis Features Sort, Filter, Pivot Tables

      21:38
    • Basic Excel Business Analytics #14 Logical Formulas & Conditional Formatting to Visualizing Data

      13:29
    • Basic Excel Business Analytics #15 Count Transactions by Web Site Report & Chart

      11:51
    • Basic Excel Business Analytics #16 Count Transactions by Hour Report & Chart

      7:29
    • Basic Excel Business Analytics #17 FREQUENCY Array Function for Frequency Distribution & Histogram

      23:01
    • Basic Excel Business Analytics #18 Data Analysis Add in for Frequency Distribution & Histogram

      9:33
    • Basic Excel Business Analytics #19 Why PivotTables Rule for Frequency Distributions & Histograms

      16:29
    • Basic Excel Business Analytics #20 Skew Shape of Histogram, Shape of Quantitative Data

      3:18
    • Basic Excel Business Analytics #21 AVERAGE, MEDIAN, MODE

      9:03
    • Basic Excel Business Analytics 22 Geometric Mean Average Compounding Rate GEOMEAN RRI Function

      11:32
    • Basic Excel Business Analytics #23 Variability Variance, Standard Deviation, Z score and more

      18:20
    • Basic Excel Business Analytics #24 Empirical Rule, Calculating Probability NORM

      13:58
    • Basic Excel Business Analytics #25 Percentiles, Quartiles, 5 Number Summary using Excel Functions

      13:16
    • Basic Excel Business Analytics #26 Box & Whisker Plot

      5:21
    • Basic Excel Business Analytics #27 Clean & Transform Data Formulas, Flash Fill, Power Query, TTC

      29:48
    • Basic Excel Business Analytics #28 Power Query Import Multiple Text Files & Build Grade Dashboard

      21:53
    • Basic Excel Business Analytics #29 Power Query Import Multiple Large CSV Files Into Data Model

      11:19
    • Basic Excel Business Analytics #30 Excel 2016 Power Query Data Ribbon Tab, Get and Transform

      5:13
    • Basic Excel Business Analytics #31 Power Query Import Multiple Excel Files with 1 Sheet Each

      12:06
    • Basic Excel Business Analytics #32 Power Query Import Multiple Excel Files with Multiple Sheets

      8:58
    • Basic Excel Business Analytics #33 Power Query Transform Many Bad Data Files into Proper Data Set

      11:21
    • Basic Excel Business Analytics #34 Power Query Import & Merge Multiple Sources Access, Text, Excel

      5:00
    • Basic Excel Business Analytics #35 Power Query to Get Data From Web Site & Import into Excel

      3:00
    • Basic Excel Business Analytics #36 Power Query to Unpivot Data (Multiple Columns to Single Column)

      6:15
    • Basic Excel Business Analytics #37 Excel 2016 Data Tab, Get & Transform Unpivot feature

      6:51
    • Excel Magic Trick 1243 Transform GDP Data Set Power Query 2nd Method or Advanced Filter

      10:40
    • Mr Excel & excelisfun Trick 174 Clean & Transform GDP Data Set Advanced Filter Or Power Query

      9:20
    • Excel Magic Trick 1242 Transform Large Data Set to Final GDP Report TTC, MATCH, Filter & Format

      9:48
    • Basic Excel Business Analytics #38 PivotTable from 4 Million Records with Power Query & Data Model

      10:55
    • Excel Business Analytics #39 Import Related Tables Power Query Merge Data Model Relationships

      12:18
    • Basic Excel Business Analytics #40 Introduction to PowerPivot & Data Modeling

      36:22
    • Basic Excel Business Analytics #41 Excel 2016 Introduction to PowerPivot & Data Model

      10:52
    • Basic Excel Business Analytics #42 Comprehensive PowerPivot, Data Model, DAX & Reporting Example

      61:04
    • Basic Excel Business Analytics #43 Visualizing Data Table & Chart Guidelines

      41:38
    • Basic Excel Business Analytics #44 Intro To Linear Regression & Scatter Chart

      15:45
    • Basic Excel Business Analytics #45 Covariance and Correlation to Measure Linear Relationship

      15:57
    • Basic Excel Business Analytics #46 Slope & Intercept for Estimated Simple Liner Regression Equation

      18:28
    • Basic Excel Business Analytics #47 SST SSR + SSE & R Squared & Standard Error of Estimate

      30:23
    • Basic Excel Business Analytics #51 Testing Significance of Regression Relationship with p value

      20:44
    • Basic Excel Business Analytics #50 Introduction to Multiple Regression, Data Analysis Regression

      13:33
    • Basic Excel Business Analytics #49 LINEST Array Function for Simple Linear Regression

      4:44
    • Basic Excel Business Analytics #48 Data Analysis Regression feature

      6:36
    • Basic Excel Business Analytics 52 LINEST, F

      8:30
    • Basic Excel Business Analytics #53 Line Charts for Time Series Data

      12:26
    • Basic Excel Business Analytics #54 Basic Forecasting Methods & Measures of Forecast Error

      32:12
    • Basic Excel Business Analytics #56 Forecasting with Linear Regression Trend & Seasonal Pattern

      25:21
    • Basic Excel Business Analytics #55 Summary of 4 Basic Forecasting Methods & Mean Square Error

      8:13
    • Basic Excel Business Analytics #57 Intro To Linear Programming using Algebra, Pencil & Paper

      27:42
    • Basic Excel Business Analytics #58 Excel Solver to Maximize Contribution Margin

      16:36
    • Basic Excel Business Analytics #60 Excel Solver Minimize Transportation Costs, Integer Variable

      12:54
    • Basic Excel Business Analytics #61 Find Alternative Optimal Solution For Transportation Problem

      5:32
    • Basic Excel Business Analytics #59 Linear Program Special Cases Infeasible, Unbound, Alternative

      5:02
    • Basic Excel Business Analytics #62 Excel Solver Maximize Portfolio Returns

      11:33
    • Basic Excel Business Analytics #63 Excel Solver Binary Variable Choose Projects Limited Resources

      7:25
    • Basic Excel Business Analytics #64 Introduction To Monte Carlo Simulation In Excel

      23:44
    • Excel Magic Trick 1298 Group By Date in Power Pivot Data Model, New in Excel 2016

      2:48
    • Highline Excel 2016 Class 19 Transform Data Sets using Advanced Filter (8 Examples)

      33:41
    • Highline Excel 2016 Class 17 How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting

      36:15
    • Highline Excel 2016 Class 15 Excel Charts to Visualize Data Comprehensive Lesson 11 Chart Examples

      52:26
    • Basic Excel Business Analytics #69 Monte Carlo Simulation for Baseball World Series

      9:41
    • Basic Excel Business Analytics #68 Monte Carlo Simulation Histogram for Construction Project Length

      15:55
    • Basic Excel Business Analytics #65 Create Random Variables Custom, Binomial, Uniform, Normal

      22:41
    • Basic Excel Business Analytics #67 Monte Carlo Simulation for Marketing Analysis Binomial Variable

      11:45
    • Basic Excel Business Analytics #66 Monte Carlo Simulation for New Product, 3 Uncertain Variables

      18:32
    • Excel Magic Trick 1299 Automatic Calendar Table in Data Model, New in Excel 2016

      3:46

About This Class

Learn basic business analytics using the latest version of Microsoft Excel to make meaning of the torrent of data that business people our given each day.

We will learn that basics of descriptive, predictive and prescriptive statistical methods and learn how to build efficient Excel models to solve business problems and to convert large data sets of unorganized raw data into useful information for decision making. Topics like: Building Good Spreadsheet Models, Descriptive Statistics, Data Cleaning, Data Transformation, Data Model Building, Data Visualization, Simple Linear Regression, Multiple Linear Regression, Time Series Analysis and Forecasting, Simple Optimization Models and Monte Carlo Simulations in an Excel Spreadsheet.

--

Students

--

Projects

0

Reviews (0)