Free Business Analytics with Excel Certification Course | @learninghome99

Free Business Analytics with Excel Certification Course 

This course includes:

• 4 Hr on-demand video
• 3 articles
• 1 downloadable resource
• Full lifetime access
• Access on mobile and TV
• Certificate of completion

What you'll learn

• 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

Requirements 

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

Course Description :

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
• 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 Introduction
• 8.02 Learning Objectives
• 8.03 Histogram
• 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 Recap
• 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 One
• 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 Macros
• 11.04 5 Point Summary Using Macros
• 11.05 Correlation Coefficient Using Macros
• 11.06 Removing Duplicates Using Macros
• 11.07 Quick Recap
• Knowledge Check

Lesson 12: Spotlight

• Spotlight

Who this course is for:

• Take this Introduction to Business Analytics with Excel for beginners free course to boost your Microsoft Excel skills. Including the Introduction to Power BI course, this program will drive you to the path of success with business analytics basics. Learn business analytics fundamentals like data analysis and statistics to enhance your data-driven decision-making skills.

How Do I Subscribe to Free Business Analytics with Excel Certification Course ?

• Sign Up for SkillUp.com
• Subscribe Here ( Free Business Analytics with Excel Certification Course ): You have to wait 35 seconds.