Course Overview

This Business Analytics course teaches you the basic concepts of data analysis and statistics to help promote data-driven decision making. This training introduces you to Power BI and delves into the statistical concepts that will help you devise insights from available data in order to present your findings using executive-level dashboards.

Key Features

100% Money Back Guarantee
No questions asked refund*

At Simplilearn, we value the trust of our patrons immensely. But, if you feel that a course does not meet your expectations, we offer a 7-day money-back guarantee. Just send us a refund request via email within 7 days of purchase and we will refund 100% of your payment, no questions asked!
  • 12 hours of self-paced video
  • Two hands-on industry-based projects on healthcare and e-commerce
  • Includes training on business intelligence using Power BI
  • Eight practical exercises
  • Lifetime access to self-paced learning

Skills Covered

  • Excel analytics functions
  • Excel conditional formatting
  • Pivot tables and slicers
  • Scenario manager tool
  • Solver tool
  • Goal seek tool
  • ANOVA
  • Hypothesis testing
  • Power BI

Training Options

Self-Paced Learning

$ 399

  • Lifetime access to high-quality self-paced e-learning content curated by industry experts
  • 24x7 learner assistance and support

Course Curriculum

Eligibility

Business Analytics with Excel is a great course for both beginners and experienced professionals who are inexperienced or have recently entered the analytics field. This course is beneficial for IT developers and testers, data analysts, junior data scientists, analytics professionals, BI and reporting professionals, project managers, students, and professionals working with data in any industry.

Read More

Pre-requisites

There are no prerequisites for this business analytics certification other than an analytical mindset. However, we do expect the participants to have a basic knowledge of working with Microsoft Excel.

Read More

Course Content

  • Business Analytics with Excel

    Preview
    • Lesson 00 - Introduction

      05:27Preview
      • 0.001 Course Introduction
        05:27
    • Lesson 01 - Introduction to Business Analytics

      09:52Preview
      • 1.001 Introduction
        02:15
      • 1.002 What Is in It for Me
        00:10
      • 1.003 Types of Analytics
        02:18
      • 1.004 Areas of Analytics
        04:06
      • 1.5 Quiz
      • 1.006 Key Takeaways
        00:52
      • 1.007 Conclusion
        00:11
    • Lesson 02 - Formatting Conditional Formatting and Important Fuctions

      38:29Preview
      • 2.001 Introduction
        02:12
      • 2.002 What Is in It for Me
        00:21
      • 2.003 Custom Formatting Introduction
        00:55
      • 2.004 Custom Formatting Example
        03:24
      • 2.005 Conditional Formatting Introduction
        00:44
      • 2.006 Conditional Formatting Example1
        01:47
      • 2.007 Conditional Formatting Example2
        02:43
      • 2.008 Conditional Formatting Example3
        01:37
      • 2.009 Logical Functions
        04:00
      • 2.010 Lookup and Reference Functions
        00:28
      • 2.011 VLOOKUP Function
        02:14
      • 2.012 HLOOKUP Function
        01:19
      • 2.013 MATCH Function
        03:13
      • 2.014 INDEX and OFFSET Function
        03:50
      • 2.015 Statistical Function
        00:24
      • 2.016 SUMIFS Function
        01:27
      • 2.017 COUNTIFS Function
        01:13
      • 2.018 PERCENTILE and QUARTILE
        01:59
      • 2.019 STDEV, MEDIAN and RANK Function
        03:02
      • 2.020 Exercise Intro
        00:35
      • 2.21 Exercise
      • 2.22 Quiz
      • 2.023 Key Takeaways
        00:53
      • 2.024 Conclusion
        00:09
    • Lesson 03 - Analyzing Data with Pivot Tables

      19:32Preview
      • 3.001 Introduction
        01:47
      • 3.002 What Is in It for Me
        00:22
      • 3.003 Pivot Table Introduction
        01:03
      • 3.004 Concept Video of Creating a Pivot Table
        02:47
      • 3.005 Grouping in Pivot Table Introduction
        00:24
      • 3.006 Grouping in Pivot Table Example 1
        01:42
      • 3.007 Grouping in Pivot Table Example 2
        01:57
      • 3.008 Custom Calculation
        01:14
      • 3.009 Calculated Field and Calculated Item
        00:25
      • 3.010 Calculated Field Example
        01:22
      • 3.011 Calculated Item Example
        02:52
      • 3.012 Slicer Intro
        00:35
      • 3.013 Creating a Slicer
        01:22
      • 3.014 Exercise Intro
        00:58
      • 3.15 Exercise
      • 3.16 Quiz
      • 3.017 Key Takeaways
        00:35
      • 3.018 Conclusion
        00:07
    • Lesson 04 - Dashboarding

      32:07Preview
      • 4.001 Introduction
        01:18
      • 4.002 What Is in It for Me
        00:18
      • 4.003 What is a Dashboard
        00:45
      • 4.004 Principles of Great Dashboard Design
        02:16
      • 4.005 How to Create Chart in Excel
        02:26
      • 4.006 Chart Formatting
        01:45
      • 4.007 Thermometer Chart
        03:32
      • 4.008 Pareto Chart
        02:26
      • 4.009 Form Controls in Excel
        01:08
      • 4.010 Interactive Dashboard with Form Controls
        04:13
      • 4.011 Chart with Checkbox
        05:48
      • 4.012 Interactive Chart
        04:37
      • 4.013 Exercise Intro
        00:55
      • 4.14 Exercise1
      • 4.15 Exercise2
      • 4.16 Quiz
      • 4.017 Key Takeaways
        00:34
      • 4.018 Conclusion
        00:06
    • Lesson 05 - Business Analytics With Excel

      25:48Preview
      • 5.001 Introduction
        02:12
      • 5.002 What Is in It for Me
        00:24
      • 5.003 Concept Video Histogram
        05:18
      • 5.004 Concept Video Solver Addin
        05:00
      • 5.005 Concept Video Goal Seek
        02:57
      • 5.006 Concept Video Scenario Manager
        04:16
      • 5.007 Concept Video Data Table
        02:03
      • 5.008 Concept Video Descriptive Statistics
        01:58
      • 5.009 Exercise Intro
        00:52
      • 5.10 Exercise
      • 5.11 Quiz
      • 5.012 Key Takeaways
        00:39
      • 5.013 Conclusion
        00:09
    • Lesson 06 - Data Analysis Using Statistics

      31:57Preview
      • 6.001 Introduction
        01:51
      • 6.002 What Is in It for Me
        00:21
      • 6.003 Moving Average
        02:50
      • 6.004 Hypothesis Testing
        04:20
      • 6.005 ANOVA
        02:47
      • 6.006 Covariance
        01:56
      • 6.007 Correlation
        03:38
      • 6.008 Regression
        05:15
      • 6.009 Normal Distribution
        06:49
      • 6.010 Exercise1 Intro
        00:34
      • 6.11 Exercise 1
      • 6.012 Exercise2 Intro
        00:17
      • 6.13 Exercise 2
      • 6.014 Exercise3 Intro
        00:19
      • 6.15 Exercise 3
      • 6.16 Quiz
      • 6.017 Key Takeaways
        00:52
      • 6.018 Conclusion
        00:08
    • Lesson 07 - Power BI

      14:01Preview
      • 7.001 Introduction
        01:17
      • 7.002 What Is in It for Me
        00:18
      • 7.003 Power Pivot
        04:16
      • 7.004 Power View
        02:36
      • 7.005 Power Query
        02:45
      • 7.006 Power Map
        02:06
      • 7.7 Quiz
      • 7.008 Key Takeaways
        00:32
      • 7.009 Conclusion
        00:11

Industry Project

  • Project 1

    Project 1 Ecommerce

    Design a sales dashboard for an e-commerce company to help them analyze the sales based on various product categories. Also, create a histogram to analyze the number of shipping days.

  • Project 2

    Project 2 Pharmaceuticals and Healthcare

    Design a dashboard for a pharmaceutical company to help them analyze the sales of products across various regions and brands.

prevNext

Course Advisor

  • Ronald van Loon

    Ronald van Loon

    Top 10 Big Data and Data Science Influencer, Director - Adversitement

    Named by Onalytica as one of the three most influential people in Big Data, Ronald is also an author of a number of leading Big Data and Data Science websites, including Datafloq, Data Science Central, and The Guardian. He also regularly speaks at renowned events.

prevNext

Exam & Certification

Business Analytics with Excel
  • How do I get certified in business analytics with Excel?

    In order to get certified in business analytics with excel, you must complete and submit the evaluation project.

  • How are the projects conducted?

    • Problem statements along with data points are provided.
    • Projects will be submitted for evaluation by the course trainer through LMS.

  • How do I earn my Simplilearn certificate?

    Online Self-Learning:
    • Complete 85 percent of the course.
    • Complete one project.

Reviews

  • Abdul Azeez VP

    Abdul Azeez VP

    I was new to Simplilearn and enrolled in the Business Analytics Engineer with Excel course after deciding to pursue self-learning. Simplilearn is an excellent place to learn complex ideas online and has lifetime access to self-learning videos. I also got a good response from customer care & support whenever I had questions or issues.

  • Aman Saxena

    Aman Saxena

    I completed the Business Analytics with Excel course from Simplilearn. Through this course, I learned about how powerful and useful Microsoft Excel the modern era of IT. Excel is equipped with statistical tools and we learned techniques to help us to retrieve critical information from existing data. Simplilearn plays a vital role in teaching this.

prevNext

FAQs

  • What are the System Requirements?

  • Can I cancel my enrollment? Do I get a refund?

    Yes, you can cancel your enrollment. We provide a complete refund after deducting the administration fee. To know more, please review our Refund Policy.

  • Who provides the certification?

    The certification is provided by Simplilearn.

  • What are the payment options?

    Payments can be made using any of the following options and a receipt will be issued to you automatically via email.

    • Visa debit/credit card
    • American Express and Diners Club card
    • MasterCard
    • PayPal

  • Who are the instructors and how are they selected?

    All of our highly-qualified trainers are certified, with more than 15 years of experience in training and working professionally in the field. Each of them has gone through a rigorous selection process that includes profile screening, technical evaluation and live training demonstration before they are certified to train for us. We also ensure that only those trainers who maintain a high alumni rating continue to train for us.

  • What is Global Teaching Assistance?

    Our teaching assistants are a dedicated team of subject matter experts here to help you get certified in your first attempt. They engage students proactively to ensure the course path is being followed and help you enrich your learning experience, from class onboarding to project mentoring and job assistance. Teaching Assistance is available during business hours.

  • What is covered under the 24/7 Support promise?

    We offer 24/7 support through email, chat, and calls. We also have a dedicated team that provides on-demand assistance through our community forum. What’s more, you will have lifetime access to the community forum, even after completion of your course with us.

Find Business Analytics Certification Training with Excel in other cities

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