Table of Content
1. Course Introduction
- Introduction to the Course
- Navigating Excel
- Data Types in Excel
2. Using Excel Spreadsheets for Data Analysis
- Viewing and Entering Data
- Formatting and Data Types in Excel
- Excel Formula Basics
- Exploring Excel Functions
- Referencing Data in Formulas
- Exercise 1
3. Cleaning and Managing Data
- Introduction to Data Quality
- Importing File Data
- Removing Duplicate Data
- Identifying Data Attributes
- Cleaning Data
- Exercise 2
4. Analyzing Data
- 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
5. What-If Analysis and Analysis ToolPak
- 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
Apply for the Certification
https://www.vskills.in/certification/data-analytics-using-excel-online-certification-course