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.
How to Learn Excel
Which function is used to create custom reusable functions in Excel without VBA?
8 hours ago | [YT] | 2
View 0 replies
How to Learn Excel
Hey friends 👋 The Modern Excel Challenges are back!
In this new episode, we’re tackling dynamic array formulas again — this time building a Top 3 leaderboard in just one formula.
I also tried something new with the editing to make it easier on the eyes and more fun to follow. Honestly, I’d love your feedback: does it feel better to watch now? If yes, I’ll stick with this style for future videos.
Thanks for being here — your comments really shape how I make these tutorials. 🙏
1 day ago | [YT] | 3
View 0 replies
How to Learn Excel
Which shortcut opens the Name Manager?
5 days ago | [YT] | 6
View 0 replies
How to Learn Excel
Are merged cells appropriate?
1 week ago | [YT] | 3
View 0 replies
How to Learn Excel
Hey everyone! I just published a brand-new Power Query tutorial: “4 Methods to Filter by a List in Power Query Every Analyst Should Know”.
If you’ve ever struggled with filtering tables by a list — whether it’s exact matches, partial matches, or combining multiple conditions — this video has you covered. I walk you through 4 practical methods, explain the pros and cons of each, and show tips to avoid common pitfalls like case sensitivity.
Check it out and let me know in the comments: which method will you try first?
1 week ago | [YT] | 7
View 0 replies
How to Learn Excel
What does the # symbol mean after a cell reference like A1#?
1 week ago | [YT] | 7
View 5 replies
How to Learn Excel
Which Power Query function keeps only the first 10 rows?
2 weeks ago | [YT] | 7
View 0 replies
How to Learn Excel
Is Excel a database?
2 weeks ago | [YT] | 4
View 0 replies
How to Learn Excel
If you’re curious about dynamic arrays but still haven’t tried HSTACK or VSTACK — this is your sign.
They make combining ranges, tables, and arrays effortless, and I’ve just posted a new video walking through real examples.
Check it out here 👇
3 weeks ago | [YT] | 5
View 0 replies
How to Learn Excel
Where do you mainly use Excel?
3 weeks ago | [YT] | 6
View 2 replies
Load more