Course description

  • What is the focus of this course?

    Business Analytics with Excel training has been designed to help initiate you to the world of analytics, by using the most commonly used analytics tool (Microsoft Excel). This business analytics training will equip you with all the concepts and hard skills required for a strong analytics career basis. If you already have some experience in the IT or any core industry, this business analytics course will quickly teach you how to understand data and make data-driven decisions using Microsoft Excel. For those that are new to the analytics field, this course provides an excellent foundation of required concepts and skills. This business analytics training also delves into the statistical concepts that are important in deriving insights from available data in order to present findings using executive level dashboards. Finally, you will be introduced to Power BI, which is currently the latest and best tool provided by Microsoft for analytics and data visualization.

  • What are the course objectives?

    With Simplilearn’s training on business analytics with Excel, you will be able to:
    • Understand the meaning of business analytics and its importance in the industry
    • Grasp fundamentals of excel analytics functions and conditional formatting
    • Learn how to analyze with complex datasets using pivot tables and slicers
    • Solve stochastic and deterministic analytical problems using tools like scenario manager, solver and goal seek
    • Apply statistical tools and concepts like moving average, hypothesis testing, ANOVA and regression to data sets using Excel
    • Represent your findings using charts and dashboards
    • Get introduced to the latest Microsoft analytic and visualization tools i.e. Power BI

  • Who should take this course?

    Business Analytics with Excel is a great course for both beginners and experienced professionals who are inexperienced or have recently stepped into the field of analytics. This course is beneficial for:
    • IT developers and testers
    • Data analysts
    • Junior data scientists
    • Analytics professionals
    • BI and reporting professionals
    • Project managers
    • Students
    • Professionals working with data in any industry

  • What are the prerequisites for this course?

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

  • What projects are included?

    Project 1 (Submission and Evaluation) - E-commerce
    The analytics team of an online e-commerce company wants to design a sales dashboard to analyze the sales based on various product categories. The company’s main interest is to add user control for product category, so users can select a category and then see the trend by month and product. The analytics team also wants to create a histogram to analyze number of shipping days.

    Project 2 (Practice) – Pharmaceuticals and Healthcare
    The analytics team of a pharmaceutical company wants to design a dashboard to analyze the sales of products across various regions and brands. It wants to create a chart with user control functionality to enable users to easily see the total sales and commissions paid to external agents as categorized by brands and region.

Course preview

    • Lesson 00 - Introduction 05:27
      • 0.001 Course Introduction 05:27
    • Lesson 01 - Introduction to Business Analytics 09:52
      • 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:29
      • 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:32
      • 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:07
      • 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:48
      • 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:57
      • 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:01
      • 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
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Exam & certification

  • 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.

Course advisor

Ronald van Loon
Ronald van Loon Top 10 Big Data & Data Science Influencer, Director - Adversitement

Named by Onalytica as one of the three most influential people in Big Data, Ronald is also an author for 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.

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