Logical Functions in Excel Tutorial
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 ⏩www.simonsezit...
🔥Check out our FREE 300+ hour training course playlist here 👉 • Simon Sez IT Long Trai...
🚀Level up your data analysis skill set with this free playlist 👉 • Data Visualization - M...
📝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 ⏩ • Simon Sez IT Live Webi...
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit...
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT...
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
www.youtube.co...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Пікірлер: 13
✅Download the exercise file and follow along here ⏩www.simonsezit.com/article/how-to-use-logical-functions-in-microsoft-excel 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first-month-free ✅For more recorded webinars from Simon Sez IT, take a look at this playlist ⏩kzread.info/head/PLzj7TwUeMQ3i4Byo1_NLrPDrxNp2NK66s
Great. Thanks.
@SimonSezIT
2 жыл бұрын
You are welcome, Frank White :-)
Thank you Ma'am!
@SimonSezIT
2 жыл бұрын
You're welcome 😊
Thank you, but could you please do a full screen demo? is it possible with that soft you got?
Thanks for sharing
@SimonSezIT
2 жыл бұрын
Thanks for watching!
@HamdanYouTuber
2 жыл бұрын
@@SimonSezIT You're welcome
Great tutorial but the only complain is the screen is not full screen so the numbers look so small when watching on a tablet.
@shardagovender4465
2 жыл бұрын
Yes, that pop up on the side reduced the Excel window.
Hi, If possible could you please share the workbook, it will be a great help to practice.
@SimonSezIT
2 жыл бұрын
Hi! You can find the excel file here: www.simonsezit.com/article/how-to-use-logical-functions-in-microsoft-excel/