Skip to content
Vskills LMS
  • Home
  • Courses
  • Certificate in Data Analytics using Excel

Certificate in Data Analytics using Excel

Current Status
Not Enrolled
Price
5
Get Started
This course is currently closed
You must login before you access the courses page.
Course Home Expand All
Course Introduction
3 Topics | 1 Quiz
Introduction to the Course
Navigating Excel
Data Types in Excel
Using Excel Spreadsheets for Data Analysis
6 Topics | 1 Quiz
Viewing and Entering Data
Formatting and Data Types in Excel
Excel Formula Basics
Exploring Excel Functions
Referencing Data in Formulas
Exercise 1
Cleaning and Managing Data
6 Topics | 1 Quiz
Introduction to Data Quality
Importing File Data
Removing Duplicate Data
Identifying Data Attributes
Cleaning Data
Exercise 2
Analyzing Data
12 Topics | 1 Quiz
Sort and Filter Data
Concatenation and SUMIF
Tackling Complicated “OR” Criteria
Summarizing Data Using Pivot Tables
Creating a Pivot Chart
Working with Excel Charts
Analyzing Financial Data
Waterfall Charts
Conditional Formatting
Using Database Functions
Evading Formula Errors
Exercise 3
What-If Analysis and Analysis ToolPak
9 Topics | 1 Quiz
Scenario Manager in What-If Analysis
Data Tables in What-If Analysis
Goal Seek in What-If Analysis
Loading the Analysis ToolPak
Correlation and Covariance in Analysis ToolPak
Descriptive Statistics, Moving Average, and Exponential Smoothing
Additional Analytical and Statistical Applications
Exercise 4
Closing
Copyright © 2025 Vskills