Data Analysis With Excel

0 (0 Ratings)

Data Analysis With Excel

Categories Data analytics

Wishlist

Course Curriculum

Essential Excel Functions for Data Analysis

Getting Started with Excel

05:07
Introduction to Formulas and Functions in Excel

08:02
Basic Statistics Functions in Excel

02:37
Cell References

03:09
IF Function

04:45
Tables in Excel

03:13
VLOOKUP – Interview Question Explained

04:07
Calculate Employee bonus based on the salary – Conditional Logic in Excel

01:28
HLOOKUP Function – Horizontal Lookup Explained

02:23
SUMIF & COUNTIF – Conditional Summaries

08:52
Introduction to Smart Reporting with Excel

01:26
Data Validation Lists

03:33
Building report using Vlookup and Match functions

02:56
Building report using index and match functions

03:07
Text Functions Overview: RIGHT(), LEFT(), LEN()

02:35
Text Functions: MID()

03:59
Text Functions: IF() + SEARCH()

06:57
Text Functions: MID() + SEARCH()

03:12
Text Functions: TRIM()

01:34
Text Functions: CONCATENATE() & UPPER()

01:54
Text Functions: MID() + LEN() Combo

01:43
Working with Date Functions in Excel

05:10
Quiz DataSet
Functions Quiz
Assignment 1 sheet solution

00:00

All What You Need to know about Pivot Tables

Excel Data Visualization

Power Query (ETLs)
Introduction to ETLs (Extract Transform Load) how to build data pipeline and automate the data transformation process

Data Modeling

Dashboard Design in Excel (Digital Marketing Dashboard)
How to design and implement a dashboard in excel step by step

Student Ratings & Reviews

No Review Yet

Level

Beginner
Total Enrolled

366
Last Updated

January 12, 2026
Certificate

Certificate of completion

Data Analysis With Excel

What I will learn?

Course Curriculum

Essential Excel Functions for Data Analysis

Quiz DataSet

Functions Quiz

Assignment 1 sheet solution

All What You Need to know about Pivot Tables

AdventureWorks Dataset – For Pivot Tables & Visualization

Pivot Tables 1: Create, Sort & Add Calculated Fields

Pivot Tables 3: Value Field Settings & Slicers

Pivot Tables 4: Timeline Slicers & Refreshing Data

🧩 How to Solve the Next Quiz

Quiz 1

Excel Data Visualization

Advanced Numbers Formatting

Adding Dynamic Arrows

Conditional Formatting from basics to advanced

Pivot Charts vs Regular Charts

Excel Charts 2: Line Charts Explained

Excel Charts 3: Long Field Slicer Solution

Power Query (ETLs) Introduction to ETLs (Extract Transform Load) how to build data pipeline and automate the data transformation process

21-ETL & Power Query Overview

22-Power Query: Part 1 – Data Extraction & Transformation

23-Power Query: Part 2 – Data Cleaning & Automation

Data Modeling

Introduction To Data Modeling

Building Your First Data Model in Excel (Step-by-Step)

Practice Data Modeling with power query

Introduction to DAX in Excel – The Power Behind Data Models

Understanding DAX Syntax in Excel Data Models

How to Add a Calculated Column in DAX (Excel Power Pivot)

Dashboard Design in Excel (Digital Marketing Dashboard) How to design and implement a dashboard in excel step by step

Digital Marketing Dataset

Digital Marketing Dashboard Design [Part 1]

Digital Marketing Dashboard Design [Part 2]

Student Ratings & Reviews

Power Query (ETLs)
Introduction to ETLs (Extract Transform Load) how to build data pipeline and automate the data transformation process

Dashboard Design in Excel (Digital Marketing Dashboard)
How to design and implement a dashboard in excel step by step