Business Analytics Certification Course with Excel

Course Content

Business Analytics with Excel

• Lesson 01: Course Introduction
  • 1.01 Introduction
  • 1.02 What Will You Learn
• Lesson 02: Introduction to Business Analytics
  • 2.01 Introduction to Business Analytics
  • 2.02 Learning Objectives
  • 2.03 Types of Analytics
  • 2.04 Areas of Analytics
  • 2.05 Quick Recap
  • Knowledge Check
• Lesson 03: Data Cleaning and Preparation
  • 3.01 Learning Objectives
  • 3.02 Sort and filter
  • 3.03 Group by and subtotal
  • 3.04 Text to Column
  • 3.05 Removing Duplicates
  • 3.06 Data Validation
  • 3.07 Quick Recap
  • Knowledge Check
• Lesson 04: Formatting, Conditional Formatting, and Important Functions
  • 4.01 Introduction
  • 4.02 Learning Objectives
  • 4.03 Introduction to Custom Formatting
  • 4.04 Custom Formatting: Example
  • 4.05 Introduction to Conditional Formatting
  • 4.06 Conditional Formatting: Example One
  • 4.07 Conditional Formatting: Example Two
  • 4.08 Conditional Formatting: Example Three
  • 4.09 Logical Functions
  • 4.10 Lookup and reference functions
  • 4.11 VLOOKUP Function
  • 4.12 HLOOKUP Function
  • 4.13 MATCH Function
  • 4.14 INDEX and OFFSET Function
  • 4.15 Statistical functions
  • 4.16 SUMIFS Function
  • 4.17 COUNTIFS Function
  • 4.18 PERCENTILE and QUARTILE
  • 4.19 STDEV, MEDIAN and RANK Function
  • 4.20 Exercise: Introduction
  • 4.21 Exercise
  • 4.22 Quick Recap
  • Knowledge Check
• Lesson 05: Spotlight
  • Spotlight
• Lesson 06: Analyzing Data with Pivot Tables
  • 6.01 Introduction
  • 6.02 Learning Objectives
  • 6.03 Introduction to Pivot tables clas
  • 6.04 Creating a Pivot Table
  • 6.05 Grouping in Pivot tables
  • 6.06 Grouping in Pivot Table: Example One
  • 6.07 Grouping in Pivot Table: Example Two
  • 6.08 Custom Calculation
  • 6.09 Calculated Field and Calculated Item
  • 6.10 Calculated Field Example
  • 6.11 Calculated Item Example
  • 6.12 Slicer introduction
  • 6.13 Creating a Slicer
  • 6.14 Exercise Introduction
  • 6.15 Exercise
  • 6.16 Quick Recap
  • Knowledge Check
• Lesson 07: Dashboarding
  • 7.01 Introduction
  • 7.02 Learning Objectives
  • 7.03 What is a Dashboard
  • 7.04 Principles of a Great Dashboard Design
  • 7.05 How to Create Charts in Excel
  • 7.06 Chart Formatting
  • 7.07 Thermometer Chart
  • 7.08 Pareto Chart
  • 7.09 Speedometer chart
  • 7.10 Create a Speedometer Chart
  • 7.11 Stacked Column Chart
  • 7.12 Funnel chart
  • 7.13 Pivot Chart
  • 7.14 Form Controls in Excel
  • 7.15 Interactive Dashboard with Form Control
  • 7.16 Chart with Checkbox
  • 7.17 Chart With Combobox
  • 7.18 Chart With Scrollbar
  • 7.19 Interactive Chart
  • 7.20 Exercise: Introduction
  • 7.21 Exercise One
  • 7.22 Exercise Two
  • 7.23 Quick Recap
  • Knowledge Check
• Lesson 08: Business Analytics With Excel
  • 8.01 Introductio
  • 8.02 Learning Objectives
  • 8.03 Histog
  • 8.04 Solver Add in
  • 8.05 Goal Seek
  • 8.06 Data Table
  • 8.07 Descriptive Statistics
  • 8.08 Exercise: Introduction
  • 8.09 Excercise
  • 8.10 Quick Re
  • Knowledge Check
• Lesson 09: Spotlight
  • Spotlight
• Lesson 10: Data Analysis Using Statistics
  • 10.01 Introduction
  • 10.02 Learning Objectives
  • 10.03 Moving Average
  • 10.04 Hypothesis Testing
  • 10.05 ANOVA
  • 10.06 Covariance
  • 10.07 Correlation
  • 10.08 Regression
  • 10.09 Multiple Linear Regression
  • 10.10 Logistic Regression
  • 10.11 Normal Distribution
  • 10.12 Exercise One: Introduction
  • 10.13 Exercise On
  • 10.14 Exercise Two: Introduction
  • 10.15 Exercise Two
  • 10.16 Exercise Three: Introduction
  • 10.17 Exercise Three
  • 10.18 Quick Recap
  • Knowledge Check
• Lesson 11: Using Macros for Analytics
  • 11.01 Learning Objectives
  • 11.02 Using Macros for Analytics
  • 11.03 Mean of Data Using Macro
  • 11.04 5 Point Summary Using Macros
  • 11.05 Correlation Coefficient Using Macros clas
  • 11.06 Removing Duplicates Using Macros
  • 11.07 Quick Recap
  • Knowledge Check
• Lesson 12: Spotlight
  • Spotlight

What do I need to do to unlock my certificate?

• Complete 85 percent of the Business Analytics certification course.
• Complete one project.

FAQs

• What is Business Analytics?

  Business Analytics, a subset of business intelligence is a process of collating, sorting, processing, and studying the data, and using statistical models and methodologies such as data mining and predictive analytics to analyze and transform data into actionable insights. business analytics has applications in a wide array of different businesses to solve problems, make data-driven business decisions, and increase efficiency, productivity, and revenue.

• How can beginners learn Business Analytics?

  Beginners can comfortably learn Business Analytics if they have an analytical mindset and basic knowledge of Microsoft Excel. This Business Analytics course helps you learn everything from scratch and gives you hands-on experience in the field as well.

• How do I enrol in this online training?

  You can enrol in this training on our website and make an online payment using any of the following option

  • Visa Credit or Debit Card
  • MasterCard
  • American Express
  • Diners Club
  • PayPal

  Once payment is received, you will automatically receive a payment receipt and access information via email.