IIRF Online > Finance & Accounting > Money Management Tools > Excel Analytics > Master Data Analytics in Excel
Master Data Analytics in Excel by Great Learning
Master excel for data analytics and gain proficiency in formulas, functions, data cleaning, & problem-solving techniques through guided, real-world projects. Develop the skills to analyze and manipulate data effectively.
Skills you will learn!
Curriculum
2 Topics
Components of Analytics
Analytics Lifecycle
12 Topics
Introduction to Excel
Excel Navigation
Rows Columns & Cells
Basic Math with Excel
Boolean Operations
Cell Referencing
Information Functions
Counting
Filtering & Sorting
Finding & Searching Text
Joining Text
Quiz to test your understanding of excel fundamentals
8 Topics
Basics of Date and Time
Finding Difference Between Dates
Advanced Text Operations
Conditional Operations
Aggregation
Conditional Aggregation
Indexing & Matching
Data handling quiz to test your understanding
7 Topics
Data Cleaning using Functions
Conditional Formatting
Data Validation
Lookup Functions in Excel
Pivot Tables
Data Visualization using Excel
Quiz to test your understanding of Data Cleaning and Analysis
11 Topics
Introduction to Exploratory Data Analysis with Excel
Problem Statement
Data Understanding
Questions & Hypothesis
Data Cleaning & Manipulation
Univariate Analysis
Exploratory Data Analysis- Hands-on- Part 1
Exploratory Data Analysis- Hands-on- Part 2
Exploratory Data Analysis- Hands-on- Part 3
Quick peek into the final insights
Quiz to test your understanding of EDA concepts
Master Data Analytics in Excel
Related Excel Analytics Courses
Thank You!
Your review has been submitted successfully.