IIRF Online > Finance & Accounting > Financial Modeling & Analysis > Excel > Certificate in Data Analytics using Excel
Certificate in Data Analytics using Excel by Vskills
Course Highlights
- Government certification
- Certification valid for life
- Lifelong e-learning access
- Learning Hours: 10+ hrs
- Life Time Job Support
- Job Profile Tagging
Skills you will learn!
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
Certificate in Data Analytics using Excel
Related Excel Courses
Thank You!
Your review has been submitted successfully.