Business Analytics Excel Dashboard Skills you will learn

  • Excel Sort and Filter
  • Functions in Excel
  • Charts
  • Building Dashboard

Who should learn Business Analytics Excel Dashboard

  • Freshers
  • Business Executives
  • Data Professionals
  • Sales Professionals

What you will learn Business Analytics Excel Dashboard

  • 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

Get a Completion Certificate

Share your certificate with prospective employers and your professional network on LinkedIn.

FAQs

  • What are the prerequisites to attend the free Business Analytics with Excel Dashboard course?

    To attend this course, you do not need any prerequisites.

  • How do beginners learn this free Business Analytics with Excel Dashboard course?

    Beginners can directly start with this course to understand Excel Dashboarding from scratch.

  • How long is the free Business Analytics with Excel Dashboard course?

    This course consists of 2 hours of video content to help you thoroughly understand the concepts.

  • Will I get a certificate after completing the free Excel Dashboard course?

    Yes, You will receive a course completion certificate after completing the course.

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
  • *According to Simplilearn survey conducted and subject to terms & conditions with Ernst & Young LLP (EY) as Process Advisors