IF Function - DataSkool

IF Function - DataSkool

Data Analysis With Excel IF Function

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

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

Assignment 1 sheet solution

Video - 00:00:00 mins

All What You Need to know about Pivot Tables

AdventureWorks Dataset – For Pivot Tables & Visualization

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

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

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

download the logical operators summary from the exercise files tab

Exercise Files

logical operators (png)

46.90 KB

Scroll to Top