Excel Functions Every Data Analyst Should Know in 20 Minutes
Автор: Kyle Walker
Загружено: 2025-10-10
Просмотров: 7557
Want to follow along with the same version of Excel I’m using?
👉 Download Microsoft Office here: https://amzn.to/3KJe1lQ
As an Amazon Associate, I earn from qualifying purchases — thanks for supporting the channel!
If you’re still using SUM, AVERAGE, and IF for every spreadsheet, you’re missing out on the formulas that real data analysts rely on daily.
In this video, we’ll break down 10 Excel functions every data analyst should know in 2025 — the same toolkit professionals use to clean messy data, automate analysis, and build dashboards that update themselves.
These aren’t random tips — they’re the exact formulas used in finance, analytics, and business intelligence teams worldwide. By the end, you’ll know how to clean, transform, and analyze data like a pro — all inside Excel.
💡 What You’ll Learn:
How to filter, sort, and deduplicate data instantly
The easiest way to clean text data without Power Query
Why XLOOKUP replaces VLOOKUP (forever)
How to create pivot-style summaries using SUMIFS & AVERAGEIFS
The magic of LET + LAMBDA for reusable formulas
How to generate sample data with SEQUENCE & RANDARRAY
How to reshape datasets using CHOOSECOLS,
How to bulletproof your formulas with IFERROR & ISBLANK
The hidden power of AGGREGATE for filtered analysis
And how to forecast future trends using FORECAST.LINEAR
🧠 Formulas Covered:
UNIQUE, SORT, FILTER, TEXTSPLIT, TEXTBEFORE, TEXTAFTER,
XLOOKUP, SUMIFS, AVERAGEIFS, COUNTIFS,
LET, LAMBDA, SEQUENCE, RANDARRAY,
CHOOSECOLS, TAKE, DROP, IFERROR, ISBLANK, ISNUMBER,
AGGREGATE, and FORECAST.LINEAR
📊 Perfect For:
Aspiring data analysts and financial analysts
Anyone who wants to move beyond basic Excel
Professionals building dashboards, reports, or data models
Timestamps:
00:00 — Intro
00:47 — UNIQUE + SORT + FILTER
02:47 — TEXTSPLIT / TEXTBEFORE / TEXTAFTER
05:29— XLOOKUP
07:08 — SUMIFS / AVERAGEIFS / COUNTIFS
09:43 — LET + LAMBDA
12:18 — SEQUENCE + RANDARRAY
13:37 — CHOOSECOLS / TAKE
15:30 — IFERROR
16:30 — AGGREGATE
18:15 — FORECAST.LINEAR
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
