Most Excel Users Dont Know Excel Logic! @MyOnlineTrainingHub
Most Excel Users Dont Know Excel Logic!  @MyOnlineTrainingHub
Uploaded October 2023 | Updated November 2026, 6 days ago
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: myonlinetraininghub.com/excel-logical-functions

🍿WATCH RELATED LESSONS NEXT:
==============================
Excel FILTER function: youtube.com/watch?v=ZCQAweoAdOw
Excel IF, IFS and Nested IF: 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: myonlinetraininghub.com

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: 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: 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: 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: youtube.com/watch?v=bPNBKT6JLSU
Part 2 - Where are they now: youtube.com/watch?v=PiGWHnZry94
Most Excel Users Dont Know Excel Logic!Convert an Excel Spreadsheet to an App in Minutes Using GlideEveryones Talking About This NEW Excel Function (TRIMRANGE)The Underrated Excel Tool You’re Missing Out On (Saves Time)Before You Send That AI Report, Run These Excel ChecksEASIEST Excel Data Entry Form in 2026 | No VBA RequiredExcel Python Keyboard Shortcuts for 10x Productivity #shortsThis Excel Hack Instantly Flags Important Data (File Included)Excel Chart Mistakes That Make Data Experts CringeCreate Excel Datasets Free & Easy with ChatGPT (+ Best Prompts)The Excel Data Cleaning Process I Use on Every File15 Excel Functions Every Professional Should Know in 2026
MyOnlineTrainingHub |

Most Excel Users Don't Know Excel Logic!

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER