Calculate Employee bonus based on the salary – Conditional Logic in Excel - DataSkool
Data Analysis With Excel Calculate Employee bonus based on the salary – Conditional Logic in Excel
Data Analysis With Excel
0% Completed
Essential Excel Functions for Data Analysis
Getting Started with Excel
Video - 00:5:7 mins
Introduction to Formulas and Functions in Excel
Video - 00:8:2 mins
Basic Statistics Functions in Excel
Video - 00:2:37 mins
Cell References
Video - 00:3:9 mins
IF Function
Video - 00:4:45 mins
Tables in Excel
Video - 00:3:13 mins
VLOOKUP – Interview Question Explained
Video - 00:4:7 mins
Calculate Employee bonus based on the salary – Conditional Logic in Excel
Video - 00:1:28 mins
HLOOKUP Function – Horizontal Lookup Explained
Video - 00:2:23 mins
SUMIF & COUNTIF – Conditional Summaries
Video - 00:8:52 mins
Introduction to Smart Reporting with Excel
Video - 00:1:26 mins
Data Validation Lists
Video - 00:3:33 mins
Building report using Vlookup and Match functions
Video - 00:2:56 mins
Building report using index and match functions
Video - 00:3:7 mins
Text Functions Overview: RIGHT(), LEFT(), LEN()
Video - 00:2:35 mins
Text Functions: MID()
Video - 00:3:59 mins
Text Functions: IF() + SEARCH()
Video - 00:6:57 mins
Text Functions: MID() + SEARCH()
Video - 00:3:12 mins
Text Functions: TRIM()
Video - 00:1:34 mins
Text Functions: CONCATENATE() & UPPER()
Video - 00:1:54 mins
Text Functions: MID() + LEN() Combo
Video - 00:1:43 mins
Working with Date Functions in Excel
Video - 00:5:10 mins
Quiz DataSet
Reading
Functions Quiz
Quiz
Assignment 1 sheet solution
Video - 00:00:00 mins
All What You Need to know about Pivot Tables
AdventureWorks Dataset – For Pivot Tables & Visualization
Reading
Pivot Tables 1: Create, Sort & Add Calculated Fields
Video - 00:5:9 mins
Pivot Tables 2: Value Field Settings & Slicers
Video - 00:11:14 mins
Pivot Tables 3: Timeline Slicers & Refreshing Data
Video - 00:3:2 mins
🧩 How to Solve the Next Quiz
Reading
Quiz 1
Quiz
Excel Data Visualization
Advanced Numbers Formatting
Video - 00:6:51 mins
Adding Dynamic Arrows
Video - 00:2:32 mins
Conditional Formatting from basics to advanced
Video - 00:00:00 mins
Pivot Charts vs Regular Charts
Video - 00:00:00 mins
Excel Charts 2: Line Charts Explained
Video - 00:5:56 mins
Excel Charts 3: Long Field Slicer Solution
Video - 00:2:50 mins
Power Query (ETLs)
21-ETL & Power Query Overview
Video - 00:11:56 mins
22-Power Query: Part 1 – Data Extraction & Transformation
Video - 00:7:41 mins
23-Power Query: Part 2 – Data Cleaning & Automation
Video - 00:7:34 mins
Data Modeling
Introduction To Data Modeling
Video - 00:2:38 mins
Building Your First Data Model in Excel (Step-by-Step)
Video - 00:9:20 mins
Practice Data Modeling with power query
Video - 00:3:16 mins
Introduction to DAX in Excel – The Power Behind Data Models
Video - 00:6:40 mins
Understanding DAX Syntax in Excel Data Models
Video - 00:8:4 mins
How to Add a Calculated Column in DAX (Excel Power Pivot)
Video - 00:7:2 mins
Dashboard Design in Excel (Digital Marketing Dashboard)
Digital Marketing Dataset
Reading
Digital Marketing Dashboard Design [Part 1]
Video - 00:25:00 mins
Digital Marketing Dashboard Design [Part 2]
Video - 00:00:00 mins
Announcements Reviews Live Classes Gradebook Certificate Course Info
PreviousNext
Scroll to Top