MyOnlineTrainingHub's video: Most Excel Users Don t Know Excel Logic

Discover why 99% of Excel users might be missing out on their full potential and learn how mastering this skill can revolutionize your use of advanced filters, formulas, and conditional formatting in Excel. It's a dive deep into the world of Excel's logical tests! In this video, I unravel the mystery behind how logical tests are evaluated, as well as lesser-known but powerful functions like XOR. Whether you're an Excel newbie or a seasoned pro, this video is bound to shed light on functionalities you might have overlooked. ⬇️DOWNLOAD the example file here: https://www.myonlinetraininghub.com/excel-logical-functions 🍿WATCH RELATED LESSONS NEXT: ============================== Excel FILTER function: https://www.youtube.com/watch?v=ZCQAweoAdOw Excel IF, IFS and Nested IF: https://www.youtube.com/watch?v=0zTeXujtOZI WHO AM I? ========= If we haven't met yet, hi! 👋 I'm Mynda Treacy. I'm a CIMA qualified accountant turned Excel and Power BI trainer. In 2014, and every year since, I've received the Microsoft Most Valuable Professional award for my contribution to the Microsoft 365 community. I love sharing Excel and Power BI tips and techniques that will get you noticed and promoted. 🎓LEARN MORE ============== 🏫 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 📢 Please leave me a COMMENT. I read them all! 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum ⏲ TIMESTAMPS ============== 0:00 Importance of understanding logical tests in Excel. 4:30 Using the 'AND' function and the alternative. 5:40 The 'double unary' and how to use it with logical tests. 6:50 Using the 'OR' function and its implications. 8:00 Introduction to the 'NOT' function and its use cases. 9:00 'XOR' function and a practical example. 10:30 When to use 'IF' and its alternatives. 12:00 Nested 'IFs' and the newer 'IFS' function 13:15 Limitations of 'OR', 'AND', 'XOR', and 'NOT' 14:20 Introduction to the 'FILTER' function in Excel 2021. 15:30 Nuances and tricks with the 'FILTER' function and Boolean values in Excel. 💪Thor Original Videos ======================== Original Team Thor short film: https://www.youtube.com/watch?v=bPNBKT6JLSU Part 2 - Where are they now: https://www.youtube.com/watch?v=PiGWHnZry94