The Excel Wildcard Tricks That Separate Beginners from Advanced Users
From MyOnlineTrainingHub · · 12 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Use wildcards (*, ?, ~) in Excel formulas for beginners and advanced users. 👩🏫 Learn more about my Excel Expert course: https://bit.ly/wildcards26course ⬇️ Download the example file here and follow along: https://bit.ly/wildcards26file
You might think you already know wildcards in Excel…
Most people use them in COUNTIF or maybe XLOOKUP and stop there.
But wildcards show up in more places than formulas, and when you start combining them with Excel’s other tools, you can solve problems much faster than most users realise.
In this video, I’ll show you both the basics and some less obvious uses that can really level up your workflow.
LEARN MORE ===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS ============== 0:00 Wildcards from the basics to advanced 0:24 XLOOKUP with wildcards 1:19 The solution to the previous setback 2:25 COUNTIF with wildcards 2:50 SUMIFS with wildcards 3:22 Data validation with wildcards 6:06 The easiest way to become an Excel expert 6:38 Advanced filter with wildcards 8:17 Find and Replace with wildcards 8:59 IF with wildcards 10:05 Escaping the wildcards 11:05 Conditional formatting with wildcards 12:17 The most important Excel functions everyone needs
#Excel #ExcelWildcards #ExcelTutorial