Yaroslav Drohomyretskyi - HowToLearnExcel

YouTube video by How to Learn Excel Dynamic Arrays in Excel: Finally Explained for Beginners

Dynamic Arrays in Excel — Intro
One formula → multiple results. No more dragging.

If this is new to you, you're right on time.
▶️ Watch now: www.youtube.com/watch?v=R38R...
#Excel #DynamicArrays #HowToLearnExcel

YouTube video by How to Learn Excel Power Query Filtering Mistake That Can Ruin Your Reports! (Fix It Now!)

🚨 Power Query Filtering Mistake! 🚨
Missing data in your reports? It could be due to a common filter issue!
Learn how Power Query processes filters, why it hides data, and how to fix it with a simple formula for accurate reports.

🎥 Watch now: www.youtube.com/watch?v=7R9N...

#PowerQuery #ExcelTips

YouTube video by How to Learn Excel Convert Monthly Sales to Seasonal Sales: Excel Challenge 07

Convert Monthly Sales to Seasonal Sales – Excel Challenge 07 🍂☀️❄️🌸

Manually summing sales by season? In this tutorial, we’ll use modern Excel formulas to group monthly sales into seasonal totals—fast & dynamically!

🎥 Watch here:
www.youtube.com/watch?v=SGSJ...

#Excel #HowToLearnExcel

YouTube video by How to Learn Excel Transform Data Like a Pro! - Power Query Challenge 62

Reshape Data Like a Pro! – Power Query Challenge 62 🚀

Messy financial data? No problem! In this challenge, we’ll clean up a dataset with years, revenues, and costs, then calculate yearly profit—all in Power Query!

🎥 Tutorial: www.youtube.com/watch?v=Lxov...

#PowerQuery #Excel #HowToLearnExcel

YouTube video by How to Learn Excel Combine Excel Files into One Sheet with Power Query – Quick & Easy!

🚀 Combine Excel Files into One Sheet
Tired of copy-pasting from multiple workbooks? Use Power Query to effortlessly merge Excel files in seconds.

💡 Works even when new files are added!

🎥 Tutorial here: www.youtube.com/watch?v=vRYj...

#ExcelTips #PowerQuery #HowToLearnExcel

YouTube video by How to Learn Excel Mastering Powerful Regex Functions: Excel Challenge 05

Master REGEXREPLACE in Excel – Count Uppercase, Lowercase, Numbers & Special Characters! 🚀

📌 Why It’s Useful:

✅ No need for complex formulas or extra columns.
✅ Works with dynamic arrays for bulk analysis.
✅ Perfect for text validation & data cleanup.

www.youtube.com/watch?v=tRNj...

Just finished the latest episode of the Unpivot podcast—loved it! 😂 The presentation tips and Mark's ideas are great.

The part about @cwebbbi.bsky.social was spot on.
Never fails to amaze me how he's always lightyears ahead.

Awesome Excel content here: blog.crossjoin.co.uk

YouTube video by How to Learn Excel Extract Emails Using REGEXEXTRACT: Excel Challenge 04

🚀 Extract Emails in Excel with REGEXEXTRACT! 📨

Just dropped a quick tutorial on using Excel’s new REGEXEXTRACT function to pull emails from text—powerful yet super simple!

🔗 Watch now: www.youtube.com/watch?v=ykgY...
💬 Want a deeper dive? Let me know in the comments!
#Excel #Regex #HowToLearnExcel

Interesting. I thought these two approaches would take the same time. Great advice.
Thank you, @cwebbbi.bsky.social

YouTube video by How to Learn Excel Clean & Organize Data Like a Pro! - Power Query Challenge 54

Clean & Organize Data Like a Pro! - Power Query Challenge 54

Messy reports? Power Query makes it easy! Learn to:
📌 Reshape scattered data into a structured summary
📌 Use List.Combine() & List.Alternate() for clean lists

🎥 Watch now: www.youtube.com/watch?v=bZ0G...

#PowerQuery #HowToLearnExcel

Power Query is like chess. ♟️

Every move (step) shapes your final position.
A bad move early on? You’ll struggle later.
A well-placed transformation? Sets up a winning position.

Think ahead. Anticipate pitfalls. Win! ✅♜

Are you planning your steps, or just hoping for a lucky move? 🤔

#PowerQuery

YouTube video by How to Learn Excel Power Query Basics: Understanding Lists, Records & Tables Like a Pro!

Power Query Basics: Lists, Records & Tables
📌 Lists {} – Store single-column values for quick calculations.
📌 Records [] – Hold named fields, great for lookups.
📌 Tables – The most powerful structure for merging & transforming data.

🎥 Watch now: www.youtube.com/watch?v=2YFC...

#PowerQuery

@excelguru.ca, great technique! I've used it a lot.
I also like to add the List.Buffer function to significantly enhance speed. It works wonders with large datasets, providing up to a 12X improvement.

YouTube video by How to Learn Excel RESHAPING Tables with TOCOL and WRAPROWS: Excel DAF Challenge 01

Reshape Tables with TOCOL & WRAPROWS in Excel

Transform messy tables effortlessly! Learn to reshape tables using Dynamic Array Formulas like TOCOL, WRAPROWS, and VSTACK. Ideal for Excel 365/2021 users.

🎥 Watch now: www.youtube.com/watch?v=5GHb...

#ExcelTips #DynamicArrays #HowToLearnExcel

After 15+ years in Excel, it’s mind-blowing how fast it’s evolving! 🤯

Dynamic Arrays, Office Scripts, LAMBDA, Python integration, REGEX—it’s like Excel has become the ultimate Swiss Army knife 🛠️.

But with all these features, is it becoming overwhelming for new users? Or is it okay? 🧐
#Excel

YouTube video by How to Learn Excel Shared Drive Full? Power Query to the Rescue!

Clean Up Shared Drives with Power Query

Messy shared drive? Use Power Query in Excel to analyze folders, uncover large or duplicate files, and create reports. Learn to transform data, group by file types, and find storage hogs—all within Excel.

🎥 Watch now: www.youtube.com/watch?v=KcvB...

YouTube video by How to Learn Excel Group Every N Rows - Power Query Challenge 49

Group Every N Rows - Power Query Challenge 49

Learn to group every N rows and calculate totals in Power Query!
Use a custom column with Table.PositionOf and Number.RoundDown functions to batch rows efficiently. Perfect for summarizing sales or surveys.

🎥 Watch: www.youtube.com/watch?v=7gRb...

YouTube video by How to Learn Excel Running Totals with a Condition - Power Query Challenge 48

Running Totals with a Condition - Power Query Challenge 48

Learn to calculate running totals for specific rows, like defect-free units.
Use Table.PositionOf, Table.FirstN, and List.Sum for precision. Perfect for production or sales tracking!

🎥 Watch: www.youtube.com/watch?v=nVuo...

Oh, wow! I hadn’t seen that. There are so many all-star PQ creators... That’s awesome! I’m definitely going to check it out between the 'Unpivot' podcasts.
Thank you!

Great point. With LLMs used everywhere 'dead internet' theory no longer seems so absurd to me. I hope we won't go there.

People will always find a way to optimize all the fun out of a process. But with social media, I’d say AI should be limited to tweaking formats and fixing typos—let the humans handle the rest.

YouTube video by How to Learn Excel Excel Pivot Tables 101: From Raw Data to Actionable Insights

Excel Pivot Tables 101: Turn Raw Data into Insights

Master pivot tables in minutes! From creating your first table to advanced tricks like calculated fields and pivot charts, this tutorial covers it all.

🎥 Watch now: www.youtube.com/watch?v=ots9...

#Excel #PivotTables #DataAnalysis

YouTube video by How to Learn Excel Group Customers by Month - Power Query Challenge 47

Group Customers by Month - Power Query Challenge 47

Need to group data by month in Excel?

📌 Key Steps:
Transform dates into month names.
Group customers by month.
Combine customer names with Text.Combine.

🎥 Learn how: www.youtube.com/watch?v=7Xuj...

#PowerQuery #ExcelTips #HowToLearnExcel

YouTube video by How to Learn Excel Power Query Reshaping Trio: Transpose, Pivot, and Unpivot in 3 MINUTES!

Power Query: Transpose, Pivot, and Unpivot

1️⃣ Transpose: Flip rows to columns.
2️⃣ Pivot: Turn rows into columns for summaries and reports.
3️⃣ Unpivot: Convert wide tables into clean, tall tables for analysis.

🎥 Watch this: www.youtube.com/watch?v=UQ3N...

#PowerQuery #ExcelTips #HowToLearnExcel

YouTube video by How to Learn Excel Excel vs Power Query: The Rounding Difference That Can Ruin Your Reports!

Did you know Excel and Power Query round differently?

Excel: Round Half Away From Zero
Power Query: Round Half to Even

This can cause issues in finance reports. Fix it with Number.RoundAwayFromZero in Power Query.

🎥 Learn how: www.youtube.com/watch?v=c0Qm...

#ExcelTips #PowerQuery

YouTube video by How to Learn Excel Power Query Partial Lookups: Automate Text Categorization Like a Pro in 5 MINUTES!

Automate Text Categorization in Power Query!
Stop wasting time with manual sorting—use partial lookups to categorize data with keywords in just 5 minutes. Perfect for bank statements, surveys, or sales records.
🎥 Tutorial: www.youtube.com/watch?v=W_Kr...
✅ Subscribe: www.youtube.com/@howtolearne...

YouTube video by How to Learn Excel Test Grading Process - Power Query Challenge 45

Ever graded tests with Power Query? Challenge 45 shows you how to mark answers, calculate scores, and pivot data for clean results—all in one query! Perfect for test results, surveys, or logic-based datasets.

📺 Watch now: www.youtube.com/watch?v=QTSz...

#PowerQuery #ExcelTips #DataCleaning

YouTube video by How to Learn Excel How to Group Data by Quarters - Power Query Challenge 44

Ever wondered how to group data by quarters in Power Query? This tutorial shows you how to take Year and Month columns and turn them into a seasonal summary.

📺 Watch here: www.youtube.com/watch?v=IuCm...

#PowerQuery #ExcelTips #HowToLearnExcel

Quick thought: Should Power Query’s default behavior be more forgiving with MissingField.Ignore?

✅ Pro: Fixes those annoying column errors
✅ Pro: Keeps queries running smoothly
❌ Con: Might hide unexpected issues
❌ Con: Could make debugging harder

Would you switch? 🤔
#PowerQuery #ExcelTips

YouTube video by How to Learn Excel Create Dynamic Columns from Nested Lists - Power Query Challenge 43

🔄 Power Query Challenge 43: Create Dynamic Columns from Nested Lists!
🎥 New tutorial: Learn to transform nested data into clean columns with ease.
✔ Extract & transform lists
✔ Master nested table manipulations
📺 Watch here: www.youtube.com/watch?v=dvUX...

#PowerQuery #ExcelTips #HowToLearnExcel