How to Learn Excel

@UCPjqzT2D49bN7OxSfw1bvug - 10.5K subscribers

If you're learning Excel, you're in the right place. I'm Yaroslav Drohomyretskyi, an analyst from Ukraine. I use Excel and Power Query every day at work, and this channel is where I share what I’ve learned — clearly, simply, and without any nonsense. You'll find: 🟢 Expect clear, structured tutorials. 🟢 No filler, no fluff — just focused, practical Excel tips. 🟢 And a bit of curiosity-driven fun along the way. I don’t pretend to know everything. I just try to explain things the way I wish someone had explained them to me. If you're learning Excel — whether you're just starting out or trying to level up — I hope this channel helps.

Home Videos Live Playlists

Clean Unstructured Data Fast with Regex Formulas - Excel Challenge 17

Clean Unstructured Data Fast with Regex Formulas - Excel Challenge 17 How to Learn Excel

13 views - 3 hours ago

The Problem Isn’t Group By (Most People Fail This PQ Challenge) - PQ124

The Problem Isn’t Group By (Most People Fail This PQ Challenge) - PQ124 How to Learn Excel

318 views - 2 weeks ago

Can Power Query Detect These 5 Broken Headers? (Crash Test)

Can Power Query Detect These 5 Broken Headers? (Crash Test) How to Learn Excel

489 views - 2 weeks ago

Fix Multi-Row Headers in Power Query (Once and for All)

Fix Multi-Row Headers in Power Query (Once and for All) How to Learn Excel

561 views - 3 weeks ago

This One Pattern Replaces Multiple Helper Columns in Power Query PQ123

This One Pattern Replaces Multiple Helper Columns in Power Query PQ123 How to Learn Excel

426 views - 1 month ago

Power Query Magic Track User Journeys! PQ122

Power Query Magic Track User Journeys! PQ122 How to Learn Excel

413 views - 1 month ago

This Tiny Power Query Trick Makes Code Much More Readable - PQ121

This Tiny Power Query Trick Makes Code Much More Readable - PQ121 How to Learn Excel

656 views - 1 month ago

You’re Using Split Column Wrong in Power Query - PQ120

You’re Using Split Column Wrong in Power Query - PQ120 How to Learn Excel

504 views - 2 months ago

Too Many Categories in Excel? This Trick Changes Everything

Too Many Categories in Excel? This Trick Changes Everything How to Learn Excel

267 views - 2 months ago

Need All Dates Between Two Dates Power Query Has the Answer!

Need All Dates Between Two Dates Power Query Has the Answer! How to Learn Excel

377 views - 2 months ago

Build a Keyword Categorizer with LAMBDA in 5 MINUTES!

Build a Keyword Categorizer with LAMBDA in 5 MINUTES! How to Learn Excel

803 views - 2 months ago

The Easiest Way to Split Text by Line Breaks & Tabs in Power Query - PQ119

The Easiest Way to Split Text by Line Breaks & Tabs in Power Query - PQ119 How to Learn Excel

483 views - 2 months ago

SMART SWAP Trick Most Excel Users Missed - PQ118

SMART SWAP Trick Most Excel Users Missed - PQ118 How to Learn Excel

606 views - 2 months ago

Find First Purchase Date FAST - PQ117

Find First Purchase Date FAST - PQ117 How to Learn Excel

665 views - 2 months ago

Power Query + Dropdown Filters: Build a Fully Interactive Report

Power Query + Dropdown Filters: Build a Fully Interactive Report How to Learn Excel

872 views - 3 months ago

The Smart Way to Combine Tables (Even When Columns Don’t Match)

The Smart Way to Combine Tables (Even When Columns Don’t Match) How to Learn Excel

1.5K views - 3 months ago

Power Query Merge Mistake You MUST Avoid!

Power Query Merge Mistake You MUST Avoid! How to Learn Excel

3.6K views - 3 months ago

Clean Power Query Logic: From Text to Numbers in 3 Steps - PQ116

Clean Power Query Logic: From Text to Numbers in 3 Steps - PQ116 How to Learn Excel

481 views - 3 months ago

This Pattern Makes Power Query Calculations Much Cleaner - PQ Challenge 115

This Pattern Makes Power Query Calculations Much Cleaner - PQ Challenge 115 How to Learn Excel

655 views - 3 months ago

Got 100 Columns? Use This Power Query Trick

Got 100 Columns? Use This Power Query Trick How to Learn Excel

607 views - 3 months ago

This Group By Pattern Changes Everything - Power Query Challenge 114

This Group By Pattern Changes Everything - Power Query Challenge 114 How to Learn Excel

607 views - 4 months ago

This Data Cleaning Pattern Every Analyst Should Know - Power Query Challenge 113

This Data Cleaning Pattern Every Analyst Should Know - Power Query Challenge 113 How to Learn Excel

819 views - 4 months ago

Grouping Without Helper Columns! - Excel Challenge 16

Grouping Without Helper Columns! - Excel Challenge 16 How to Learn Excel

383 views - 4 months ago

TIE-PROBLEM SOLVED! The Pattern Every Analyst Should Know - Power Query Challenge 112

TIE-PROBLEM SOLVED! The Pattern Every Analyst Should Know - Power Query Challenge 112 How to Learn Excel

481 views - 4 months ago

Try This Medal Ranking Challenge! - Power Query Challenge 111

Try This Medal Ranking Challenge! - Power Query Challenge 111 How to Learn Excel

684 views - 4 months ago

Replace Unique Values - Power Query Challenge 110

Replace Unique Values - Power Query Challenge 110 How to Learn Excel

475 views - 5 months ago

Rebuild a Table from a Single Messy Column - Power Query Challenge 109

Rebuild a Table from a Single Messy Column - Power Query Challenge 109 How to Learn Excel

666 views - 5 months ago

Why Group By Is More Powerful Than You Think - Power Query Challenge 108

Why Group By Is More Powerful Than You Think - Power Query Challenge 108 How to Learn Excel

683 views - 5 months ago

Simple Steps to Awesome Sales Reports - Power Query Challenge 107

Simple Steps to Awesome Sales Reports - Power Query Challenge 107 How to Learn Excel

522 views - 5 months ago

Comparing THREE Methods to Group Data - Power Query Challenge 106

Comparing THREE Methods to Group Data - Power Query Challenge 106 How to Learn Excel

390 views - 6 months ago

Excel Regex Magic You Need to See! - Excel Challenge 15

Excel Regex Magic You Need to See! - Excel Challenge 15 How to Learn Excel

226 views - 6 months ago

Text.Combine + Group By Explained Simply - Power Query Challenge 105

Text.Combine + Group By Explained Simply - Power Query Challenge 105 How to Learn Excel

615 views - 6 months ago

Split Column into Rows Like a Pro - Power Query Challenge 104

Split Column into Rows Like a Pro - Power Query Challenge 104 How to Learn Excel

348 views - 6 months ago

Power Query Hack: Automatically Replace Nulls in All Columns

Power Query Hack: Automatically Replace Nulls in All Columns How to Learn Excel

510 views - 6 months ago

Excel Dates Not Grouping? Try This!

Excel Dates Not Grouping? Try This! How to Learn Excel

395 views - 6 months ago

Stack Multiple Columns into One in Power Query (2 Easy Methods!)

Stack Multiple Columns into One in Power Query (2 Easy Methods!) How to Learn Excel

619 views - 7 months ago

Conditional Lookup: The Power Query Trick Nobody Told You About

Conditional Lookup: The Power Query Trick Nobody Told You About How to Learn Excel

740 views - 7 months ago

How to Sum All Number Columns in Power Query Like a PRO

How to Sum All Number Columns in Power Query Like a PRO How to Learn Excel

1.1K views - 7 months ago

Explore Any Table in Power Query: Profile & Schema Tips How to Learn Excel

688 views - 7 months ago

Turn Stepped Data into Clean Columns Instantly - Excel Challenge 14

Turn Stepped Data into Clean Columns Instantly - Excel Challenge 14 How to Learn Excel

291 views - 7 months ago

Group Rows + Merge Text Like a Pro - Power Query Challenge 103

Group Rows + Merge Text Like a Pro - Power Query Challenge 103 How to Learn Excel

605 views - 7 months ago

Unpivot Multi-Section Tables Automatically - Power Query Challenge 102

Unpivot Multi-Section Tables Automatically - Power Query Challenge 102 How to Learn Excel

401 views - 7 months ago

How to Group Data and Generate Custom Text Reports - Power Query Challenge 101

How to Group Data and Generate Custom Text Reports - Power Query Challenge 101 How to Learn Excel

374 views - 7 months ago

How to Reshape Tables Without Coding Like a PRO! - Power Query Challenge 100

How to Reshape Tables Without Coding Like a PRO! - Power Query Challenge 100 How to Learn Excel

951 views - 8 months ago

Excel TRANSPOSE, WRAPROWS & WRAPCOLS Explained – Step by Step

Excel TRANSPOSE, WRAPROWS & WRAPCOLS Explained – Step by Step How to Learn Excel

353 views - 8 months ago

Fix Misaligned Rows Like a PRO! - Power Query Challenge 99

Fix Misaligned Rows Like a PRO! - Power Query Challenge 99 How to Learn Excel

1K views - 8 months ago

When Your Data Has Groups but No Structure - Power Query Challenge 98

When Your Data Has Groups but No Structure - Power Query Challenge 98 How to Learn Excel

483 views - 8 months ago

Rebuild a Table from a Text String - Power Query Challenge 97

Rebuild a Table from a Text String - Power Query Challenge 97 How to Learn Excel

434 views - 8 months ago

How to Sum Odd and Even Rows Separately - Power Query Challenge 96

How to Sum Odd and Even Rows Separately - Power Query Challenge 96 How to Learn Excel

285 views - 8 months ago

The Power Query Mistake You Don’t Know You’re Making - Keep the Latest Record

The Power Query Mistake You Don’t Know You’re Making - Keep the Latest Record How to Learn Excel

747 views - 9 months ago

Clean Hidden Headers & Empty Rows Like a Pro - Power Query 95

Clean Hidden Headers & Empty Rows Like a Pro - Power Query 95 How to Learn Excel

628 views - 9 months ago

Remove Duplicates Across Columns in Excel | Power Query Challenge 94

Remove Duplicates Across Columns in Excel | Power Query Challenge 94 How to Learn Excel

402 views - 9 months ago

How to Get the Top 3 Performers with One Formula - Excel Challenge 13

How to Get the Top 3 Performers with One Formula - Excel Challenge 13 How to Learn Excel

608 views - 9 months ago

Power Query Custom Sort in 3 Minutes | Quick Excel PQ Tutorial

Power Query Custom Sort in 3 Minutes | Quick Excel PQ Tutorial How to Learn Excel

600 views - 9 months ago

How to Split Total Sales by Day - Power Query Challenge 93

How to Split Total Sales by Day - Power Query Challenge 93 How to Learn Excel

337 views - 9 months ago

Filter by a List in Power Query: 4 Methods Every Analyst Should Know

Filter by a List in Power Query: 4 Methods Every Analyst Should Know How to Learn Excel

1.3K views - 9 months ago

How to Count Working Days - Power Query Challenge 92

How to Count Working Days - Power Query Challenge 92 How to Learn Excel

676 views - 9 months ago

How to Split Messy Text THE SMART WAY - Power Query Challenge 91

How to Split Messy Text THE SMART WAY - Power Query Challenge 91 How to Learn Excel

802 views - 9 months ago

How to Pivot Without Pivoting: Power Query Challenge 90

How to Pivot Without Pivoting: Power Query Challenge 90 How to Learn Excel

313 views - 9 months ago

Excel HSTACK & VSTACK Made Simple (You’ll Never Go Back)

Excel HSTACK & VSTACK Made Simple (You’ll Never Go Back) How to Learn Excel

700 views - 9 months ago