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

download the logical operators summary from the exercise files tab

Exercise Files
logical operators.png
Size: 46.90 KB
Previous
Next
0% Complete
Facebook-f Whatsapp Linkedin Youtube
DataSkool
Logo
Shopping cart