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
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
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
🚀 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
🚀 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
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
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
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
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
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
🔄 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
🔓 Master Multiple Excel Windows!
🎥 New tutorial: Learn 3 easy ways to open multiple Excel instances for smoother workflows in Power Query, VBA & more.
✔ Boost productivity
✔ Manage tasks efficiently
📺 Watch now: www.youtube.com/watch?v=nAvT...
#ExcelTips #PowerQuery #HowToLearnExcel
🚀 Make Running Totals 12x Faster in Power Query!
🎥 New tutorial: Learn how to calculate running totals efficiently with buffering.
✔ Handle 100k+ rows
✔ Boost performance by 12x
✔ Perfect for large datasets!
📺 Watch here: www.youtube.com/watch?v=IqTY...
#PowerQuery #ExcelTips #HowToLearnExcel
🔄 Power Query Challenge 42: Advanced Conditional Splitting!
🎥 Learn how to split text dynamically based without helper columns.
✔ Split IDs into 2 or 3 parts
✔ Master List.Transform & conditional logic
📺 Watch here: www.youtube.com/watch?v=_ILr...
#PowerQuery #ExcelTips #HowToLearnExcel
🧵 Excel 365 Regex: Extract Any Data from Text!
🎥 Learn how to use Regex functions to pull specific data from messy text.
✔ Extract emails, phone numbers, codes & more
✔ Simplify complex text operations
📺 Watch here: youtube.com/shorts/SwKmz...
#ExcelTips #Regex #HowToLearnExcel
📊 Tired of repetitive column creation in Power Query?
🎥 Discover how to create multiple custom columns in just one step.
✔ Faster calculations
✔ Cleaner workflows
✔ Easy for everyone!
📺 Check it out: www.youtube.com/watch?v=qI8K...
#PowerQuery #ExcelTips #HowToLearnExcel #PowerQueryAdvanced #excel
✉️ Say goodbye to manual typing!
🎥 New tutorial: Use Flash Fill to create email addresses in Excel—fast and easy.
✔ Extract names
✔ Format email domains
✔ Save time like a pro!
📺 Watch here: www.youtube.com/watch?v=mjiH...
#ExcelTips #FlashFill #HowToLearnExcel #excel #excelflashfill #productivity
🗂️ Dynamic File Imports: Power Query Made Smarter!
🎥 New tutorial: Learn how to use relative folder paths in Power Query
✔ Automate file imports
✔ Keep your queries dynamic
✔ No more manual updates!
📺 Watch here: www.youtube.com/watch?v=T83t...
#PowerQuery #ExcelTips #HowToLearnExcel #excel #powerbi
📊 Master Waterfall Charts in just 3 minutes!
🎥 New tutorial: Create stunning visuals to track profits, expenses & more!
✔ Quick, simple, and perfect for busy Excel users.
📺 Watch now: www.youtube.com/watch?v=UyUs...
#ExcelTips #WaterfallCharts #HowToLearnExcel #excel t #exceldatavisualization
🧹 Got messy Excel data? Fix it fast!
🎥 Check out my new tutorial: "Excel Basics: Data Cleaning Made Easy!"
Learn to:
✔ Remove duplicates
✔ Trim spaces
✔ Split & merge text
✔ Fix formatting
📺 Watch now: www.youtube.com/playlist?lis...
#ExcelTips #DataCleaning #HowToLearnExcel #excel #msexcel
