In this video, you’ll learn how to unlock one of Excel’s most underrated power moves, the Double Dash (--). The Double Dash (officially known as the double unary) converts TRUE/FALSE into numbers (1’s and 0’s) that can then be used in calculations. We’ll start off with a very simple explanation of the double dash in excel. Then move onto more real-life examples like comparing lists, looking at calculations the COUNTIF(s) would struggle with and finally how to calculate averages when the numbers are all in the same cell separated by commas. 📢* FREE RESOURCES* Mega Excel Keyboard Shortcut List Quick Reference Guide 🔥 THE PROF’S COLLECTION: 🛠 RECOMMENDED TOOLS AND DISCOUNTS NOTE: Please know I have experience with these products, and recommend them because they have been proven to be reliable and trustworthy, not because of the small commissions earned. ✅ InvideoAI ✅ Camtasia Use Promo Code: PROFESSORCUBS Affiliate Disclaimer: This video/ description may contain affiliate links, which means that if you decide to purchase any products, we will earn a small commission to support videos on this channel. The price you pay is the same. ABOUT PROFESSOR CUBS 🏆 My goal is to help you learn popular software apps so you can be more productive, save time in life, so you can spend it on activities that matter. Some of the app tutorials include: - Microsoft Excel, Power BI, PowerPoint, OneNote, Word, Tableau, Audacity, Reaper and other popular software applications 🎓 My background: 25+ years in corporate training teaching both software and business skills, along with working in the financial business. Degree in Finance, along with a list of certifications that would bore you to tears. 🚀 I remember first learning technology, how confusing and overwhelming it can be. So I strive to make things simple, easy and fun. Thanks, Professor Cubs