In this Excel 2021 tutorial, we take a look at Logical Functions in Excel such as IF, IFS, COUNTIF, and SUMIF. This is an Excel tutorial for beginners or those who need to brush up on their Excel knowledge.
This was taken from a live, recorded webinar. You can download the Excel demo file used in this tutorial below and follow along.
Download the exercise file and follow along here ⏩https://www.simonsezit.com/article/how-to-use-logical-functions-in-microsoft-excel
Check out our FREE 300+ hour training course playlist here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Level up your data analysis skill set with this free playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
Timestamps:
0:00:00 - What are Logical Functions?
0:01:04 - Simple Logical Tests
0:04:11 - Adding Meaning using IF Statements
0:08:57 - Using SUM and IF to Perform Logical Calculations
0:11:22 - Working with AND and OR
0:16:31 - Nested IF Statements
0:23:01 - The IFS Functions
0:27:48 - COUNTIF(S), SUMIF(S), and AVERAGEIF(S)
0:38:55 - Error Checking with IFNA and IFERROR
For more recorded webinars from Simon Sez IT, take a look at this playlist ⏩https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i4Byo1_NLrPDrxNp2NK66s
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-month-free
Watch more free popular training tutorials from Simon Sez IT:
Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up ;-)