Business Analytics 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 Business Analytics with Excel

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

What you will learn in Business Analytics with Excel

  • 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 Introduction to Business Analytics
        02:04
      • 2.02 Learning Objectives
        00:45
      • 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:05
      • 4.01 Introduction
        01:54
      • 4.02 Learning Objectives
        00:49
      • 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:20
      • 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 Introduction
        01:20
      • 6.02 Learning Objectives
        00:42
      • 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:40
      • 7.01 Introduction
        01:14
      • 7.02 Learning Objectives
        00:39
      • 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:26
      • 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:01
      • 8.01 Introduction
        01:52
      • 8.02 Learning Objectives
        00:37
      • 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

Course Advisors

  • Ronald van Loon

    Ronald van Loon

    CEO, Principal Analyst Intelligent World,Top10 AI-Data-IoT-Influencer

    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

Why you should learn Business Analytics

26.98% CAGR by 2025

For the business intelligence market

2.72 million job openings

For business analysts as per IBM research

Career Opportunities

FAQs

  • What are the prerequisites to learn Business Analytics?

    Learners taking this free coursebusiness analytics fundamentals program only need to have an analytical mindset and familiarity with MS Excel.

  • What will you learn about Business Analytics?

    In this free course, you will learn about Business Analytics fundamentals. Aspiring Business Analysts are expected to be well-versed in SMART requirements, elicitation techniques, project reviews, as well as core BA skills. You will also develop an understanding of business analytics tools like SQL, Python and R, and statistical software.

  • How do beginners learn Business Analytics fundamentals?

    Business Analytics is a challenging domain and should only be started by professionals with real interest in this domain. We offer various resource articles and YouTube videos to give an overview of introduction to business analytics to beginners. Then it becomes easy to comprehend the concepts covered in this business analytics basics program.

  • Why learn Business Analytics?

    Business analytics is an indispensable tool in today's digital world. With enormous volumes of data being generated, the need for professionals who can interpret it and generate actionable insights is on the rise.

    Investing in business analytics helps enterprises make informed decisions, and generate profitability and operational efficiency. While forward-thinking enterprises add business analysts to their workforce, now is the time to learn business analytics to open up many exciting job opportunities.

  • What will I learn in the Business Analytics free course?

    The fundamentals of Business Analytics you will learn as a part of this free course include:

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

  • What are the top skills required for a career in Business Analytics?

    Below are the tops skills required for a career in Business Analytics:

    • Technical skills like SQL, and statistical software like SPSS, SAS, Sage, Mathematica, and Excel
    • Excellent communication and facilitation skills
    • Analytical thinking and problem solving skills
    • Organizational skills
    • Stakeholder analysis
    • Costs benefit analysis and processes modeling
    • An understanding of networks and databases 

  • How long does it take to learn Business Analytics?

    Depending on the educational background and prior knowledge of the field, the time taken to learn business analytics varies from person to person. The 3 hours of video lessons covered in this business analytics  fundamentals free course can give you that perfect start in this subject.

  • What should I learn first in the Business Analytics free course?

    Learners usually begin with the types of analytics and the sectors where analytics can be effectively used in a business analytics basics free course.

  • Is Business Analytics easy to learn?

    If you have a passion for data, statistics, and an innate curiosity for research, you can easily pick up the Business Analytics free course.  


     

  • What are the basics in a Business Analytics free course?

    The Business Analytics free courses includes basics like data collection, data mining, sequence identification, text mining, forecasting, predictive analytics, optimization, and data visualization.

  • What is Business Analytics used for?

    Business Analytics is used to drive practical, data-driven business decisions in an organization. It assists enterprises plan for the future, create new strategies, and avoid pitfalls based on actionable insights derived from data. 

  • Can I complete this Business Analytics fundamentals in 90 days?

    Yes. If you follow the schedule of the learning videos and adhere to the study plan accordingly, you can complete the free course in 90 days.

  • Will I get a certificate after completing the Business Analytics free course?

    Yes, You will receive a Course Completion Certificate from SkillUp upon completing the Business Analytics free program. You can unlock it by logging in to your SkillUp account. As soon as the certificate is unlocked, you will receive a mail with a link to your SkillUp learning dashboard on your registered mail address. Click the link to view and download your certificate. You can even add the certificate to your resume and share it on social media platforms.

  • What are my next best learning options after completing this Business Analytics free course?

    While this Business Analytics free course gives you a suitable start, you can learn more about the subject by taking Data Analyst Master’s Program or Professional Certificate Program in Data Analytics.

  • What are the career opportunities in Business Analytics?

    Career opportunities in Business Analytics include:

    • Market research analyst
    • Process analyst
    • Data scientist
    • Management analyst
    • Business consultant

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