Introduction to Course

0m 19s

Delegate pack

Introduction to Modules

0m 47s

Pre course Reading

What is Business Analytics

4m 23s

What is Business Analytics? - Assessment

What is MS Excel?

1m 9s

Features of MS Excel

8m 24s

What is MS Excel? Features of MS Excel - Assessment

Basic Worksheet Modelling, Range Names

4m 32s

Basic Worksheet Modelling, Range Names - Assessment

Lookup Functions

4m 48s

INDEX Function

5m 39s

Lookup Functions INDEX Function - Assessment

MATCH Function, Text Functions

5m 23s

NPV and XNPV Functions

3m 38s

MATCH Function Text Functions NPV and XNPV Functions - Assessment

IRR, XIRR, and MIRR Functions

4m 12s

More Excel Financial Functions

4m 5s

IRR, XIRR, and MIRR Functions , More Excel Financial Functions - Assessment

IF, IFERROR, IFS, CHOOSE, and SWITCH Functions

13m 10s

COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions

5m 36s

SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS Functions

7m 40s

IF, IFERROR, IFS, CHOOSE, and SWITCH Functions COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS Functions - Assessment

OFFSET Function

5m 36s

INDIRECT Function

5m 18s

OFFSET Function INDIRECT Function - Assessmentt

Case Study - Financial Forecasting Using NPV and IRR Functions

Case Study - Market Basket Analysis Using COUNTIFS and SUMIFS Functions

Using Solver to Determine the Optimal Product Mix

13m 7s

Using Solver to Schedule Your Workforce

5m 11s

Using Solver to Determine the Optimal Product Mix and Using Solver to Schedule Your Workforce - Assessment

Using Solver to Solve Transportation or Distribution Problems

5m 31s

Using Solver for Capital Budgeting

4m 21s

Using Solver for Capital Budgeting and Using Solver for Financial Planning - Assessment

Case Study - Optimising Inventory Management with Excel Solver

Case Study - Capital Budgeting Decisions Using Solver

Case Study - Optimising Staffing with Solver

Importing Data from a Text File or Document Geography and Stock Data Types

4m 37s

Validating Data

6m 0s

Importing Data from a Text File or Document , Geography and Stock Data Types and Validating Data - Assessment

Using Pivot Tables and Slicers to Describe Data

5m 38s

Summarising Data by Using Histograms and Pareto Charts, Summarising Data by Using Descriptive Statistics and Using Pivot Tables and Slicers to Describe Data - Assessment

Summarizing Data by Using Histograms and Pareto Charts and Summarizing Data by Using Descriptive Statistics

4m 23s

Summarizing Data by Using Histograms and Pareto Charts Summarizing Data by Using Descriptive Statistics

4m 23s

Data Model Summarizing Data with Database Statistical Functions Consolidating Data

13m 37s

Data Model, Summarising Data with Database Statistical Functions, Consolidating Data - Assessment

Case Study - Analysing Sales Data with Pivot Tables and Slicers

An Introduction to Random Variables

3m 49s

Binomial, Hypergeometric, and Binomial Random Variables

8m 22s

An Introduction to Random Variables, Binomial, Hypergeometric, and Binomial Random Variables and Poisson and Exponential Random Variable - Assessment

Poisson and Exponential Random Variable Normal Random Variable and Z-Scores Using the Lognormal Random Variable to Model Stock Prices

7m 1s

Normal Random Variable and Z-Scores, Using the Lognormal Random Variable to Model Stock Prices - Assessment

Case Study - Credit Risk Assessment Using Logistic Regression in Excel

Post Course Quiz - 1

Let's Prepare for Interview