Business Analytics with Excel Skills you will learn

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

Who should learn this free Business Analytics course?

  • IT Developers and Testers
  • Data Analysts
  • Junior Data Scientists
  • Analytics Professionals
  • BI and Reporting Professionals
  • Project Managers
  • Students

What you will learn in this free Business Analytics course?

  • Business Analytics with Excel

    • Lesson 01: Course Introduction

      05:12
      • 1.01 Introduction
        03:12
      • 1.02 What Will You Learn
        02:00

    • Lesson 02: Introduction to Business Analytics

      09:48
      • 2.01 Learning Objectives
        00:45
      • 2.02 Introduction to business analytics
        02:04
      • 2.03 Types of Analytics
        02:14
      • 2.04 Areas of Analytics
        03:57
      • 2.05 Quick Recap
        00:48
      • Knowledge Check

    • Lesson 03: Data Cleaning and Preparation

      09:53
      • 3.01 Learning Objectives
        00:50
      • 3.02 Sort and filter
        01:29
      • 3.03 Group by and subtotal
        02:10
      • 3.04 Text to column
        01:13
      • 3.05 Removing Duplicates
        02:07
      • 3.06 Data Validation
        01:31
      • 3.07 Quick Recap
        00:33
      • Knowledge Check

    • Lesson 04: Formatting, Conditional Formatting, and Important Functions

      36:06
      • 4.01 Learning Objectives
        00:49
      • 4.02 Introduction
        01:54
      • 4.03 Introduction to Custom Formatting
        00:57
      • 4.04 Custom Formatting: Example
        02:29
      • 4.05 Introduction to Conditional Formatting
        00:49
      • 4.06 Conditional Formatting: Example One
        01:38
      • 4.07 Conditional Formatting: Example Two
        02:04
      • 4.08 Conditional Formatting: Example Three
        01:21
      • 4.09 Logical Functions
        03:37
      • 4.10 Lookup and reference functions
        00:30
      • 4.11 VLOOKUP Function
        02:14
      • 4.12 HLOOKUP Function
        01:28
      • 4.13 MATCH Function
        02:57
      • 4.14 INDEX and OFFSET Function
        03:26
      • 4.15 Statistical functions
        00:27
      • 4.16 SUMIFS Function
        01:34
      • 4.17 COUNTIFS Function
        01:11
      • 4.18 PERCENTILE and QUARTILE
        01:55
      • 4.19 STDEV, MEDIAN and RANK Function
        02:38
      • 4.20 Exercise Introduction
        00:34
      • 4.21 Exercise
        00:54
      • 4.22 Quick Recap
        00:40
      • Knowledge Check

    • Lesson 05: Spotlight

      02:12
      • Spotlight
        02:12

    • Lesson 06: Analyzing Data with Pivot Tables

      20:57
      • 6.01 Learning Objectives
        00:42
      • 6.02 Introduction
        01:20
      • 6.03 Introduction to Pivot tables
        01:09
      • 6.04 Creating a Pivot Table
        02:33
      • 6.05 Grouping in Pivot tables
        00:24
      • 6.06 Grouping in Pivot Table: Example One
        01:55
      • 6.07 Grouping in Pivot Table: Example Two
        01:57
      • 6.08 Custom Calculation
        01:10
      • 6.09 Calculated Field and Calculated Item
        00:27
      • 6.10 Calculated Field Example
        01:26
      • 6.11 Calculated Item Example
        02:07
      • 6.12 Slicer introduction
        00:42
      • 6.13 Creating a Slicer
        01:26
      • 6.14 Exercise Introduction
        00:57
      • 6.15 Exercise
        02:00
      • 6.16 Quick Recap
        00:42
      • Knowledge Check

    • Lesson 07: Dashboarding

      44:37
      • 7.01 Learning Objectives
        00:39
      • 7.02 Introduction
        01:14
      • 7.03 What is a Dashboard
        00:45
      • 7.04 Principles of a Great Dashboard Design
        02:09
      • 7.05 How to Create Charts in Excel
        02:35
      • 7.06 Chart Formatting
        01:27
      • 7.07 Thermometer Chart
        04:01
      • 7.08 Pareto Chart
        02:51
      • 7.09 Speedometer chart
        00:55
      • 7.10 Create a Speedometer Chart
        03:23
      • 7.11 Stacked Column Chart
        01:27
      • 7.12 Funnel chart
        01:09
      • 7.13 Pivot Chart
        02:22
      • 7.14 Form Controls in Excel
        01:19
      • 7.15 Interactive Dashboard with Form Control
        03:48
      • 7.16 Chart with Checkbox
        04:57
      • 7.17 Chart With Combobox
        00:31
      • 7.18 Chart With Scrollbar
        00:38
      • 7.19 Interactive Chart
        04:20
      • 7.20 Exercise Introduction
        00:51
      • 7.21 Exercise One
        01:18
      • 7.22 Exercise Two
        01:14
      • 7.23 Quick Recap
        00:44
      • Knowledge Check

    • Lesson 08: Business Analytics With Excel

      21:15
      • 8.01 Learning Objectives
        00:41
      • 8.02 Introduction
        02:02
      • 8.03 Histogram
        05:03
      • 8.04 Solver Add-in
        04:28
      • 8.05 Goal Seek
        02:47
      • 8.06 Data Table
        01:47
      • 8.07 Descriptive Statistics
        01:30
      • 8.08 Exercise Introduction
        00:53
      • 8.09 Excercise
        01:18
      • 8.10 Quick Recap
        00:46
      • Knowledge Check

    • Lesson 09: Spotlight

      01:59
      • Spotlight
        01:59

    • Lesson 10: Data Analysis Using Statistics

      40:18
      • 10.01 Introduction
        01:53
      • 10.02 Learning Objectives
        00:40
      • 10.03 Moving Average
        02:32
      • 10.04 Hypothesis Testing
        03:54
      • 10.05 Anova
        02:32
      • 10.06 Covariance
        01:57
      • 10.07 Correlation
        03:44
      • 10.08 Regression
        05:08
      • 10.09 Multiple Linear Regression
        03:36
      • 10.10 Logistic Regression
        02:32
      • 10.11 Normal Distribution
        06:13
      • 10.12 Exercise One: Introduction
        00:34
      • 10.13 Exercise One
        01:12
      • 10.14 Exercise Two: Introduction
        00:22
      • 10.15 Exercise Two
        01:11
      • 10.16 Exercise Three: Introduction
        00:26
      • 10.17 Exercise Three
        00:48
      • 10.18 Quick Recap
        01:04
      • Knowledge Check

    • Lesson 11: Using Macros for Analytics

      07:22
      • 11.01 Learning Objectives
        00:35
      • 11.02 Using Macros for Analytics
        01:17
      • 11.03 Mean of Data Using Macros
        00:46
      • 11.04 5 Point Summary Using Macros
        01:50
      • 11.05 Correlation Coefficient Using Macros
        01:09
      • 11.06 Removing Duplicates Using Macros
        01:00
      • 11.07 Quick Recap
        00:45
      • Knowledge Check

    • Lesson 12: Spotlight

      02:12
      • Spotlight
        02:12

Get a Completion Certificate

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

Learn the Fundamentals of Business Analytics with Excel

Why you should learn Business Analytics with Excel?

26.98% CAGR by 2025

For the business intelligence market

2.72 million job openings

For business analysts as per IBM research

Career Opportunities

About The Course

In this Excel for business analytics course, you'll refine your Microsoft Excel skills with hands-on exercises and practical examples. You'll also get into the fundamentals of business analytics, mastering key concepts like data analysis and statistics.  You’ll apply these principles to real-world scenarios  through interactive lessons, honing your data-driven decision-making abilities. By the end of the business analyst Excel course, you'll have the expertise to confidently apply business analytics techniques, enhancing your proj

Read More

Get your team a digital skilling library

with unlimited access to live classes
Know More
digital skilling library

FAQs

  • What is business analytics with Excel?

    Business analytics with Excel involves using Microsoft Excel as a tool to analyze data and derive insights that can inform business decisions. It includes techniques such as data cleaning, formatting, pivot tables, and statistical analysis to extract valuable information from datasets.

  • Is Excel necessary for a business analyst?

    Excel is essential for a business analyst due to its widespread use in data analysis, reporting, and visualization tasks. Proficiency in Excel enables business analysts to  manipulate and analyze data efficiently, create meaningful visualizations, and generate insights to support decision-making processes.

  • Who should take this free Business Analytics with Excel Course?

    This business analytics with Excel course is suitable for anyone interested in learning about data analysis techniques using Excel. It is especially beneficial for professionals in business analysis, finance, marketing, operations, and other fields where data-driven decision-making is crucial.

  • What outcomes can I expect after completing the course?

    After completing the Excel for business analytics, you can expect to gain proficiency in using Excel for business analytics tasks. You will be able to clean and prepare data, perform various types of analysis using Excel functions and pivot tables, create informative dashboards, and automate repetitive tasks using macros. Additionally, you will receive a completion certificate to showcase your newfound skills.

  • How long is the training program and what is the format?

    The business analyst Excel training program consists of approximately 4 hours of self-paced video lessons. Learners can progress through the course at their own pace, accessing the video lessons and course materials at their convenience.

  • How long will I have access to the course materials?

    Learners will have access to the course materials for 90 days upon enrollment. During this period, you can review the video lessons, download supplementary materials, and practice the skills learned in the course.

  • Is certification provided after course completion?

    A completion certificate will be awarded upon completing the business analytics with Excel course. This certificate serves as formal recognition of your participation and completion of the Business Analytics with Excel course.

Learner Review

  • Ishita Pandey

    Ishita Pandey

    I have finally completed a course on Business Analytics with Excel from Skill Up by Simplilearn. The course secured sessions of Dashboarding, Data Analysis using Statistics, Power BI and many more. These learnings would unquestionably help me in my future.

  • Chetna Khera

    Chetna Khera

    Thank you Simplilearn for the well framed questions and perfect content, now I'm ready with some broader perspective and some innovative implementation of business analytics.

  • Dhamendra Kumar

    Dhamendra Kumar

    One more milestone added to my profile by completing Business Analytics with excel which adds weightage to management roles. This course helped me in developing a better understanding of business data to develop a positive attitude towards taking the perfect decision. Thanks to Simplilearn.

  • Mohamed Imran

    Mohamed Imran

    True education is not for a mere living but for a meaningful life. I have successfully completed my Business Analytics with Excel course from Simplilearn . I am looking forward to Up Skill myself with the latest technologies through Skill Up.

  • Nikhil Kumar

    Nikhil Kumar

    It was a great experience to learn Business Analytics with Excel. Thankyou Simplilearn for providing this course.

  • Rajnandini Mandal

    Rajnandini Mandal

    Thanks to Simplilearn apart from the courses on my dashboard they are also providing free courses, that I'm really grateful for, because it has given a deeper understanding in excel

  • Joseph Stanly

    Joseph Stanly

    Trade Marketing Executive , Life Pharmacy

    I have always believed in learning continually. I had a good experience learning the Business Analytics with Excel course.

  • Hassab Hussain

    Hassab Hussain

    The course content was practical-oriented. The templates taught in the course made it easy for me to apply the functions to my actual worksheets.

  • Aritra Duari

    Aritra Duari

    The interactive interface of the exercises in each lesson was amazing. Overall, the course material was good with many examples for better understanding.

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