Course Highlights
  • Government certification
  • Certification valid for life
  • Lifelong e-learning access
  • Learning Hours: 10+ hrs
  • Life Time Job Support
  • Job Profile Tagging
Curriculum

3 Topics
Introduction to the Course
Navigating Excel
Data Types in Excel

6 Topics
Viewing and Entering Data
Formatting and Data Types in Excel
Excel Formula Basics
Exploring Excel Functions
Referencing Data in Formulas
Exercise 1

6 Topics
Introduction to Data Quality
Importing File Data
Removing Duplicate Data
Identifying Data Attributes
Cleaning Data
Exercise 2

12 Topics
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

9 Topics
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

  Write a Review

Certificate in Data Analytics using Excel

Go to Paid Course