Yaroslav Drohomyretskyi - HowToLearnExcel
@howtolearnexcel.bsky.social
I'm passionate about exploring new tools and techniques, like Excel, Power Query, Power BI, and VBA, and I love sharing them with others.
My channel: https://youtube.com/@howtolearnexcel?feature=shared
My channel: https://youtube.com/@howtolearnexcel?feature=shared
Dynamic Arrays Lesson 2 is live! 🎯
12 real-world examples of UNIQUE, FILTER, SORT & SORTBY — all with a gaming dataset.
My first 15+ min deep dive on the channel.
www.youtube.com/watch?v=cdAU...
12 real-world examples of UNIQUE, FILTER, SORT & SORTBY — all with a gaming dataset.
My first 15+ min deep dive on the channel.
www.youtube.com/watch?v=cdAU...
Master Excel’s UNIQUE, FILTER, SORT & SORTBY – 12 Practical Examples
YouTube video by How to Learn Excel
www.youtube.com
August 9, 2025 at 6:15 AM
Dynamic Arrays Lesson 2 is live! 🎯
12 real-world examples of UNIQUE, FILTER, SORT & SORTBY — all with a gaming dataset.
My first 15+ min deep dive on the channel.
www.youtube.com/watch?v=cdAU...
12 real-world examples of UNIQUE, FILTER, SORT & SORTBY — all with a gaming dataset.
My first 15+ min deep dive on the channel.
www.youtube.com/watch?v=cdAU...
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
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
Dynamic Arrays in Excel: Finally Explained for Beginners
YouTube video by How to Learn Excel
www.youtube.com
July 6, 2025 at 7:02 PM
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
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
🚨 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
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
Power Query Filtering Mistake That Can Ruin Your Reports! (Fix It Now!)
YouTube video by How to Learn Excel
www.youtube.com
March 24, 2025 at 8:17 PM
🚨 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
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
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
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
Convert Monthly Sales to Seasonal Sales: Excel Challenge 07
YouTube video by How to Learn Excel
www.youtube.com
March 19, 2025 at 9:41 PM
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
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
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
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
Transform Data Like a Pro! - Power Query Challenge 62
YouTube video by How to Learn Excel
www.youtube.com
March 15, 2025 at 10:03 PM
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
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
🚀 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
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
Combine Excel Files into One Sheet with Power Query – Quick & Easy!
YouTube video by How to Learn Excel
www.youtube.com
February 23, 2025 at 8:48 AM
🚀 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
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
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...
📌 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...
Mastering Powerful Regex Functions: Excel Challenge 05
YouTube video by How to Learn Excel
www.youtube.com
February 18, 2025 at 10:35 PM
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...
📌 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
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
Excel Summit, ABBA and Presentation Tips
QotW: What are you tips for delivering good presentations?
🟢Mark explains why he doesn't like Chris Webb
🟢Giles is sick but soldiers on
🟢Sue did DP700 exam and presentation
🟢Wyn needs to work on Irish names
Links: bio.link/unpivot
#Excel #PowerBI
QotW: What are you tips for delivering good presentations?
🟢Mark explains why he doesn't like Chris Webb
🟢Giles is sick but soldiers on
🟢Sue did DP700 exam and presentation
🟢Wyn needs to work on Irish names
Links: bio.link/unpivot
#Excel #PowerBI
February 15, 2025 at 5:06 PM
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
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
🚀 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
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
Extract Emails Using REGEXEXTRACT: Excel Challenge 04
YouTube video by How to Learn Excel
www.youtube.com
February 15, 2025 at 4:54 PM
🚀 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
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
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
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
Clean & Organize Data Like a Pro! - Power Query Challenge 54
YouTube video by How to Learn Excel
www.youtube.com
February 9, 2025 at 8:57 PM
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
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
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
February 9, 2025 at 8:55 PM
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
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
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
📌 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
Power Query Basics: Understanding Lists, Records & Tables Like a Pro!
YouTube video by How to Learn Excel
www.youtube.com
February 8, 2025 at 12:37 PM
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
📌 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
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
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
RESHAPING Tables with TOCOL and WRAPROWS: Excel DAF Challenge 01
YouTube video by How to Learn Excel
www.youtube.com
January 25, 2025 at 7:02 PM
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
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
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
January 25, 2025 at 6:57 PM
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
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
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...
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...
Shared Drive Full? Power Query to the Rescue!
YouTube video by How to Learn Excel
www.youtube.com
January 19, 2025 at 9:21 PM
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...
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...
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...
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...
Group Every N Rows - Power Query Challenge 49
YouTube video by How to Learn Excel
www.youtube.com
January 19, 2025 at 12:43 PM
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...
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...
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...
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...
Running Totals with a Condition - Power Query Challenge 48
YouTube video by How to Learn Excel
www.youtube.com
January 19, 2025 at 12:40 PM
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...
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...
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
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
Excel Pivot Tables 101: From Raw Data to Actionable Insights
YouTube video by How to Learn Excel
www.youtube.com
January 14, 2025 at 7:57 PM
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
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
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
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
Group Customers by Month - Power Query Challenge 47
YouTube video by How to Learn Excel
www.youtube.com
January 14, 2025 at 7:54 PM
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
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
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
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
Power Query Reshaping Trio: Transpose, Pivot, and Unpivot in 3 MINUTES!
YouTube video by How to Learn Excel
www.youtube.com
January 12, 2025 at 9:32 AM
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
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
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
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
Excel vs Power Query: The Rounding Difference That Can Ruin Your Reports!
YouTube video by How to Learn Excel
www.youtube.com
January 10, 2025 at 5:22 AM
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
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
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...
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...
Power Query Partial Lookups: Automate Text Categorization Like a Pro in 5 MINUTES!
YouTube video by How to Learn Excel
www.youtube.com
January 4, 2025 at 3:15 PM
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...
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...
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
📺 Watch now: www.youtube.com/watch?v=QTSz...
#PowerQuery #ExcelTips #DataCleaning
Test Grading Process - Power Query Challenge 45
YouTube video by How to Learn Excel
www.youtube.com
January 2, 2025 at 8:36 PM
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
📺 Watch now: www.youtube.com/watch?v=QTSz...
#PowerQuery #ExcelTips #DataCleaning
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
📺 Watch here: www.youtube.com/watch?v=IuCm...
#PowerQuery #ExcelTips #HowToLearnExcel
How to Group Data by Quarters - Power Query Challenge 44
YouTube video by How to Learn Excel
www.youtube.com
December 27, 2024 at 10:30 PM
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
📺 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
✅ 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
December 21, 2024 at 8:13 PM
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
✅ 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