How to Learn Excel
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.
Excel TRANSPOSE, WRAPROWS & WRAPCOLS Explained – Step by Step
Fix Misaligned Rows Like a PRO! - Power Query Challenge 99
When Your Data Has Groups but No Structure - Power Query Challenge 98
Rebuild a Table from a Text String - Power Query Challenge 97
How to Sum Odd and Even Rows Separately - Power Query Challenge 96
The Power Query Mistake You Don’t Know You’re Making - Keep the Latest Record
Clean Hidden Headers & Empty Rows Like a Pro - Power Query 95
Remove Duplicates Across Columns in Excel | Power Query Challenge 94
How to Get the Top 3 Performers with One Formula - Excel Challenge 13
Power Query Custom Sort in 3 Minutes | Quick Excel PQ Tutorial
How to Split Total Sales by Day - Power Query Challenge 93
Filter by a List in Power Query: 4 Methods Every Analyst Should Know
How to Count Working Days - Power Query Challenge 92
How to Split Messy Text THE SMART WAY - Power Query Challenge 91
How to Pivot Without Pivoting: Power Query Challenge 90
Excel HSTACK & VSTACK Made Simple (You’ll Never Go Back)
Group Small Values as “Other” Like a PRO: Power Query Challenge 89
Unpivot and Split Data Like a PRO: Power Query Challenge 88
Reshape Tables: Split vs Alternate - Power Query Challenge 87
Data Transformation for Step Charts - Power Query Challenge 86
Why SEQUENCE Is a Must-Know Excel Function
Double Grouping Trick You Didn’t Know - Power Query 85
Use List.Difference to Spot Missing Data Instantly - Power Query 84
Master Excel’s UNIQUE, FILTER, SORT & SORTBY – 12 Practical Examples
The Grouping Feature You Didn’t Know You Needed - Power Query 83
Expand Date Ranges Like a Pro! The Smart Way - Power Query Challenge 82
Split, Clean, and Pivot Messy Text Like a Pro! - Power Query Challenge 81
How Power Query Helped Me Catch a Costly Mistake
From Chaos to Clean Rows in Seconds: Excel Challenge 12
Excel Pivot Tables Now Update On Their Own!