Free Business Analytics with Excel Dashboard Tutorial for Beginners

Business Analytics with Excel Beginner Course

• Lesson 01 - Introduction to Business Analytics

  09:47

  • 1.001 Introduction

    02:20

  • 1.003 Types of Analytics

    02:18

  • 1.004 Areas of Analytics

    04:06

  • 1.005 Quiz

  • 1.006 Key Takeaways

    00:52

  • 1.007 Conclusion

    00:11

• Lesson 02 - Dashboarding

  44:37

  • 2.01 Introduction

    01:14

  • 2.02 Learning Objectives

    00:39

  • 2.03 What is a Dashboard

    00:45

  • 2.04 Principles of a Great Dashboard Design

    02:09

  • 2.05 How to Create Charts in Excel

    02:35

  • 2.06 Chart Formatting

    01:27

  • 2.07 Thermometer Chart

    04:01

  • 2.08 Pareto Chart

    02:51

  • 2.09 Speedometer chart

    00:55

  • 2.10 Create a Speedometer Chart

    03:23

  • 2.11 Stacked Column Chart

    01:27

  • 2.12 Funnel chart

    01:09

  • 2.13 Pivot Chart

    02:22

  • 2.14 Form Controls in Excel

    01:19

  • 2.15 Interactive Dashboard with Form Control

    03:48

  • 2.16 Chart with Checkbox

    04:57

  • 2.17 Chart With Combobox

    00:31

  • 2.18 Chart With Scrollbar

    00:38

  • 2.19 Interactive Chart

    04:20

  • 2.20 Exercise Introduction

    00:51

  • 2.21 Exercise One

    01:18

  • 2.22 Exercise Two

    01:14

  • 2.23 Quick Recap

    00:44