PREMIUM

Master Data Analytics in Excel

6.5 hrs 2 projects

Master data analytics with Excel! Gain proficiency in formulas, functions, data cleaning, and problem-solving techniques through guided, real-world projects. Develop the skills to analyze and manipulate data effectively for action

$40 $80 50% off

Start Learning

Preview Course

Resolve doubts with AI Mentor

Guided Projects for hands-on learning

Personalised Mock Interviews

Skills you will gain

Excel Basics

Formulas and Functions

Data Cleaning

Conditional Functions

Lookup Functions

Data Validation

Conditional Formatting

Text Functions

Date & Time Functions

AI-powered support to help you learn

AI Mentor
Resolve doubts using AI Mentor
AI Mentor answers questions, explains topics, and provides examples to help you understand concepts better.

Mock Interviews
Get personalised feedback and prepare for roles in tech
Enhance your professional skills with AI-powered feedback and build confidence for job interviews.

Get exclusive access to premium features and personalised learning

Start Learning

Guided Projects

Solve real-world projects with a step-by-step guide, starter code templates, and access to model solutions to boost your skills and build a standout resume.

GUIDED PROJECT 1
AeroMax Airways: Data-Driven Insights for Optimizing Airline Operations and Passenger Experience
This project involves analyzing a large dataset from the aviation sector, including flight delays, passenger demographics, ticket pricing, and operational costs. Participants will uncover insights into flight delays, identify congested airports, analyze passenger satisfaction trends, and evaluate financial performance. The project emphasizes data cleaning, processing, and visualization to derive actionable recommendations for improving punctuality, enhancing customer experience, and optimizing profitability in the airline industry.

Data Analysis

Data Cleaning

Data Processing

PivotTables

Data Visualization

Statistical Analysis

Customer Insights

GUIDED PROJECT 2
StellarMart Analytics: Optimizing Retail Performance Through Data Insights
This project focuses on analyzing a retail dataset from StellarMart to identify sales trends, seasonal patterns, regional performance, and underperforming product categories. We will clean and process data, create dynamic visualizations, and generate actionable insights to support strategic decisions and drive profitability. Deliverables include an organized Excel workbook with cleaned data, aggregated metrics, and visualizations tailored for retail analytics

Data Analysis

Excel

Data Cleaning

Data Processing

PivotTables

Data Visualization

Sales Trend Analysis

Seasonal Trends

Regional Performance

Statistical Functions

Retail Analytics

Customer Insights

Business Intelligence

Industry-focused curriculum

Introduction to Data Analytics

2 Videos

Basics of data analytics, SQL, and Excel, including their roles in analytics

2 videos

20 mins

Components of Analytics
Analytics Lifecycle

Preview module

Fundamentals of Excel in Data Analytics

11 Videos

1 Quiz

Subqueries, window functions, and advanced aggregations

11 videos

1 hour 20 mins

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

1 Quiz

Quiz to test your understanding of excel fundamentals

Data Handling and Analysis in Excel

7 videos

1 Quiz

Excel functions, conditional operations, and data manipulation

7 videos

1 hour and 14 mins

Basics of Date and Time
Finding Difference Between Dates
Advanced Text Operations
Conditional Operations
Aggregation
Conditional Aggregation
Indexing & Matching

1 Quiz

Data handling quiz to test your understanding

Data Cleaning, Analysis, and Visualization in Excel

6 videos

1 Quiz

Data Cleaning, Analysis, and Visualization in Excel

6 videos

1 hour and 15 mins

Data Cleaning using Functions
Conditional Formatting
Data Validation
Lookup Functions in Excel
Pivot Tables
Data Visualization using Excel

1 Quiz

Quiz to test your understanding of Data Cleaning and Analysis

Exploratory Data Analysis (EDA)

10 videos

1 Quiz

Conducting univariate, bivariate, and multivariate analysis using Excel

10 videos

2 hours

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

1 Quiz

Quiz to test your understanding of EDA concepts

Guided Excel Project 1 : E-Commerce

Guided Project 1

E-Commerce Project : Functional requirements and step-by-step guide

Guided Excel Project 2 : Aviation Sector Analysis using Excel

Guided Project 2

Aviation Sector Analysis Project : Functional requirements and step-by-step guide

Mock Interview - Excel Specialist

1 Mock Interview

1 Personalised Mock Interview to help you land an Excel specialist role

Course instructors

Denver Dias

Senior Data Science Consultant

Data Science Leader with over 8 years of experience in building advanced Machine Learning models and leveraging Data Engineering skills to facilitate data-driven decision-making. Proven track record of delivering high-impact solutions for Fortune 500 clients, leading cross-functional teams, and generating substantial cost savings. Currently working with Getty Images to revamp their A/B Testing platform to better measure the effectiveness of newly developed algorithms and experiments in production.

Denver Dias

Senior Data Science Consultant

Gaelim Holland

Senior Data Analyst | Power BI Expert | Data Visualization | Data Scientist

Gaelim is an innovative Data Analyst and Data Scientist with extensive expertise in omnichannel analytics, integrating both online and offline data in funnel analysis. Highly skilled in optimizing online sales, revenue, and call-to-actions through conversion rate optimization, statistical science, and A/B testing, Gaelim has a deep command of statistical testing tools, data extraction, and data science. With aspirations to take on managerial or consulting roles, Gaelim seeks to apply their expertise in data-driven marketing, targeted acquisition, and data science to drive impactful results.

Gaelim Holland

Senior Data Analyst | Power BI Expert | Data Visualization | Data Scientist