Course Content
Essential Excel Functions for Data Analysis
0/25
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
0/6
AdventureWorks Dataset – For Pivot Tables & Visualization
Pivot Tables 1: Create, Sort & Add Calculated Fields
05:09
Pivot Tables 3: Value Field Settings & Slicers
11:14
Pivot Tables 4: Timeline Slicers & Refreshing Data
03:02
🧩 How to Solve the Next Quiz
Quiz 1
Excel Data Visualization
0/6
Advanced Numbers Formatting
06:51
Adding Dynamic Arrows
02:32
Conditional Formatting from basics to advanced
00:00
Pivot Charts vs Regular Charts
00:00
Excel Charts 2: Line Charts Explained
05:56
Excel Charts 3: Long Field Slicer Solution
02:50
Power Query (ETLs)
Introduction to ETLs (Extract Transform Load) how to build data pipeline and automate the data transformation process
0/3
21-ETL & Power Query Overview
11:56
22-Power Query: Part 1 – Data Extraction & Transformation
07:41
23-Power Query: Part 2 – Data Cleaning & Automation
07:34
Data Modeling
0/6
Introduction To Data Modeling
02:38
Building Your First Data Model in Excel (Step-by-Step)
09:20
Practice Data Modeling with power query
03:16
Introduction to DAX in Excel – The Power Behind Data Models
06:40
Understanding DAX Syntax in Excel Data Models
08:04
How to Add a Calculated Column in DAX (Excel Power Pivot)
07:02
Dashboard Design in Excel (Digital Marketing Dashboard)
How to design and implement a dashboard in excel step by step
0/3
Digital Marketing Dataset
Digital Marketing Dashboard Design [Part 1]
25:00
Digital Marketing Dashboard Design [Part 2]
00:00
Data Analysis With Excel

Learn how to use Vlookup through an interview question in one of the big companies in the middle east

Exercise Files
Excel Dataset used in Functions videos.xlsx
Size: 210.97 KB
Previous
Next
0% Complete
Facebook-f Whatsapp Linkedin Youtube
DataSkool
Logo
Shopping cart