Please note, this is a STATIC archive of website www.simplilearn.com from 27 Mar 2023, cach3.com does not collect or store any user information, there is no "phishing" involved.
Simplilearn Live

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.

Related Courses

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.