#### William Davis

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
77 Videos (19h 56m)

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

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)