Logical Functions In Excel Tutorial (IF, IFS, AND, OR, COUNTIF, SUMIF): Excel Formulas and Functions

✅ Download the exercise files and follow along here: ➡️https://www.simonsezit.com/article/lo...

In this Excel tutorial, we take a look at Logical Functions in Excel. That's functions such as IF, IFS, COUNTIF and SUMIF. This is an Excel tutorial for beginners or those who need to brush up on their Excel.

This was taken from a live, recorded session. You can download the Excel files that Debs uses below and follow along.

Download the exercise files and follow along here ► https://www.simonsezit.com/article/lo...

In this session we covered:

- The IF Function
- Nested IF in Excel
- The IFS Function
- The AND and OR Functions
- COUNTIF and SUMIF
- Error checking Functions IFERROR and IFNA

🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first...

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️
   • Simon Sez IT Long Training Courses  

✅ Check out our free video playlist for Excel beginners 👉   • Microsoft Excel 2019 Training Tutoria...  

✅ Pivot Table Tutorials for Beginners here 👉   • How to Use Microsoft Excel Pivot Tabl...  

✅ Microsoft Excel Tips and Tricks 👉   • Microsoft Excel Tips and Tricks  

✅ Microsoft Office 2021 and Office 365 Training here 👉   • Microsoft Office 2021 and Office 365 ...  

🔥Check out our FREE 300+ hour training course playlist here ➡️
   • Simon Sez IT Long Training Courses  

💬Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn:   / simon-sez-it  
FaceBook:   / simonsezit  

🔔 Subscribe to our channel:
https://www.youtube.com/simonsezittra...

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)