Тёмный

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

Simon Sez IT
Подписаться 607 тыс.
Просмотров 133 тыс.
50% 1

Опубликовано:

 

2 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 78   
@SimonSezIT
@SimonSezIT 9 месяцев назад
✅ Download the exercise files and follow along here: ➡www.simonsezit.com/article/logical-functions-in-excel/
@TrumpISAgentORANGE
@TrumpISAgentORANGE 2 года назад
I've already watched a lot of great tutorials on IF, other functions and nesting. I just got overwhelmed and did not feel very confident. This tutorial was so helpful and relieved so much of my stress. Thank you so much!!!!!
@SimonSezIT
@SimonSezIT 2 года назад
Glad it was helpful. Thanks for watching ;-)
@TheHoshmanddeeba
@TheHoshmanddeeba 4 года назад
thanks for this, very nice, when you zoomed in, that was when I really began to see your sheet properly. It was fuzzy before that. Best Regards, from Birmingham UK
@SimonSezIT
@SimonSezIT 4 года назад
The video quality is usually automatically chosen dependent on your internet strength. To change the quality please select the settings Cog Icon at the bottom of the video and select "Quality" and choose a higher quality video such as" 1080p" I hope that helps !
@rph247
@rph247 2 года назад
After watching a great deal of tutorials looking at Logical Functions in Excel, I attest this one was helpful and then some! It helped me understand and apply its magic to solve an assigment involving nested IF functions; the solution to the assigment worked like a dream! Thank you very much!
@SimonSezIT
@SimonSezIT 2 года назад
Thanks 😊 There is additional Excel training here if you need it -> ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@thechannel7072
@thechannel7072 3 года назад
Learning these things on internet makes internet very useful. Thanks for putting your hours and sharing knowledge for free to the people who are needed it.
@cheryllin4079
@cheryllin4079 5 месяцев назад
very good tutorial
@SimonSezIT
@SimonSezIT 5 месяцев назад
Glad you enjoyed it. Thanks for watching! 🙂
@AveyAvey
@AveyAvey 4 года назад
Deborah Ashby is undoubtedly ,the top 5 excel trainers currently living! She should be given Knighthood!
@SimonSezIT
@SimonSezIT 4 года назад
Let's start a petition haha! I'm pleased to hear you enjoyed the tutorial!
@AveyAvey
@AveyAvey 4 года назад
@@SimonSezIT indeed, thoroughly.... Looking forward for the BI tutorial... . dosent seem, your star trainer won't be the instructor for that course :-(
@Absadumar
@Absadumar Месяц назад
Hello, thank you for the tutorial. It would have been better if you had zoomed in to be clear.
@SimonSezIT
@SimonSezIT Месяц назад
Thanks for the feedback 😊 We have the latest Logical Function tutorial. Hope this helps: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uHv9HRxrWLg.html
@timothytabor7887
@timothytabor7887 3 года назад
I like these webinars. It's a lot of fun trying to figure out all the processes. I learned Excel 20 years ago at a local Community College. Since then, I have used it from time to time; within that time, Microsoft keeps adding to its application. It is like 'standing on the shoulders of giants'.
@SimonSezIT
@SimonSezIT 3 года назад
Glad you like them Timothy!
@arv-Hackney-London
@arv-Hackney-London 2 года назад
Is there an issue with the exercise file? This is the message that is flagging up when I tried to open it 'file format or file extension is not valid.' All of us would appreciate it someone at Simon Sez It can solve the problem. Thank you so much.
@Rich-rp9xy
@Rich-rp9xy 8 месяцев назад
Is this still relevant to excel if i want to learn for example a job where excel is required
@Christian-ll3wk
@Christian-ll3wk Год назад
This is probably the BEST excel tutorial I've used. Thank you!
@DavidBasseyIkpeme-mx8nu
@DavidBasseyIkpeme-mx8nu 9 месяцев назад
Can u please always zoom when teaching for clearer view....i can see it clearly
@TheSason666
@TheSason666 8 месяцев назад
22:34 27:39 34:54 40:55
@vineetp1861
@vineetp1861 Год назад
Hi, Thanks for the video. I am looking for a solution which can help me to extract specific word from a string present in one cell and replace the same with different word from another cell. How to do it ?
@sanmi1752
@sanmi1752 Год назад
This is sooooooooo impactful!, WOW-It's worth the time and not boring. Thank you Simon Sez IT team.
@darrylmorgan
@darrylmorgan 4 года назад
Thumbs Up!Excellent Tutorial Thank You Debs :):):)
@SimonSezIT
@SimonSezIT 4 года назад
Thank you Daryl, I'm glad you enjoyed it!
@williamredmond8128
@williamredmond8128 7 месяцев назад
"Let me reduce my employee's to value ratings."
@madvasto
@madvasto 2 года назад
It was very well explained! It helped me understand better the combined IF functions. Thank you!!!
@SimonSezIT
@SimonSezIT 2 года назад
You're very welcome, Madlen! Here's some additional training if you need it -> ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oN82Umc9MCQ.html
@Amitsingh-pu7qv
@Amitsingh-pu7qv Месяц назад
CAN I DOWNLOAD PRACTICE FILE FREE ?
@howardslade267
@howardslade267 Год назад
Wonderful Tutorial. I am trying to create an Automatic Bowling Scoresheet. Any suggestions for an Existing Template or what function to use to calculate scores for Strikes, Spares, etc.?
@BEEMOKOPU
@BEEMOKOPU 5 месяцев назад
DIDNT I JUST CALM DOWN AFTER WATCHING THIS, THANKS A LOT BUT IM STILL HAVING PROBLEM WITH UNDERSTANDING IF FUNCTION, I KEEP ON FAILING AND FAILING
@SimonSezIT
@SimonSezIT 5 месяцев назад
Keep on practicing. Here are more Microsoft Excel Tips and Tricks to try on ➡️ ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@unknownhippieexplorer8848
@unknownhippieexplorer8848 3 года назад
can you provide this excel file for practice, Please
@MOHAMEDHASSAN-gp1nt
@MOHAMEDHASSAN-gp1nt 4 года назад
عمل رائع شكرا جزيلا
@tharunkumar9682
@tharunkumar9682 3 года назад
Thanks a lot ,excellent job ,Easy understandable accented tutorial ,clearly explained much needed logics 👍
@SimonSezIT
@SimonSezIT 3 года назад
Glad it was helpful!
@CardExpressions
@CardExpressions 2 года назад
How can I do an IF to read (Data Cell) and if that cell contains data...A Date. I want an auto-fill from a specific cell (Cost cell) to go into the new cell next to the data cell?
@lawrencekazibwe9751
@lawrencekazibwe9751 2 года назад
Thanks alot Deborah,has been very informative
@SimonSezIT
@SimonSezIT 2 года назад
Glad it was helpful!
@angelaanil
@angelaanil 3 месяца назад
Can somebody share the excel files.?? Am not able to access them
@SimonSezIT
@SimonSezIT 3 месяца назад
Download the exercise files and follow along here: www.simonsezit.com/article/logical-functions-in-excel/
@emmanuelpenada7423
@emmanuelpenada7423 9 месяцев назад
how can i download that helpful tools?
@SimonSezIT
@SimonSezIT 9 месяцев назад
Hello Emmanuel. Thanks for watching. You can download the exercise files 👉www.simonsezit.com/article/logical-functions-in-excel/
@angelaanil
@angelaanil 3 месяца назад
@@SimonSezITthe exercise files aren’t here… please help
@bubwar9716
@bubwar9716 Год назад
Highly appreciated for your Tutorials, good revision for me. Many many thanks. B. M War, Additional Chief Engineer Civil, Meghalaya Energy Corporation ltd.
@SimonSezIT
@SimonSezIT Год назад
Thanks for taking the time to leave some positive comments 😊 We have additional free Excel training if you need it 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@Heuschele
@Heuschele 8 месяцев назад
Helpful, thank you.
@SimonSezIT
@SimonSezIT 8 месяцев назад
You are very welcome! Glad it was helpful. 🙂 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@brandonculbengan9564
@brandonculbengan9564 Год назад
Thanks, I learned a lot.
@shirleywickremachci7831
@shirleywickremachci7831 2 года назад
You’re such a good tuitor in excel.. I am currently learning about Microsoft,, and I watched many videos regarding about formulas, which giving me hard time to understand..but when I watched your video,, I was amaze the way you explained,, it’s understandable and I figured out finally in my mind , ,all the functions of each formulas,may god bless you😊😊😊😊thank you
@SimonSezIT
@SimonSezIT 2 года назад
Glad you liked it, Shirley. Thanks for taking the time to watch and comment :-)
@mohanasharank759
@mohanasharank759 2 года назад
very super
@SimonSezIT
@SimonSezIT 2 года назад
Thank you! Cheers!
@rodolfojr.delrosario4512
@rodolfojr.delrosario4512 2 года назад
This tutorial is the best in terms of EXcel!!!! This is about creating a very useful videos. Subscribed!!!
@SimonSezIT
@SimonSezIT 2 года назад
Welcome aboard!
@mahamedali6158
@mahamedali6158 9 дней назад
very excellent presentation
@SimonSezIT
@SimonSezIT 8 дней назад
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@AhmedMaher-kg5en
@AhmedMaher-kg5en 3 года назад
More than excellent
@SimonSezIT
@SimonSezIT 3 года назад
Thanks Ahmed!
@አንዲትኢትዮጵያ
@አንዲትኢትዮጵያ 5 месяцев назад
አመሰግናለሁ!!
@Team8LA
@Team8LA 2 года назад
Watching tutorial makes everything looks easy until I have to do it on my own. Your file is so easy to download for practice, thank you!
@SimonSezIT
@SimonSezIT 2 года назад
Glad you liked it, Michelle 🙂 If you need it, you can get additional Excel training here ➡️ ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@lisaaustin3187
@lisaaustin3187 2 года назад
Is it possible to ask the IF function to leave the cell blank if the value is false?
@cindy7lee
@cindy7lee 2 года назад
Yes. Put " " in negative condition.
@subhashini4242
@subhashini4242 Год назад
very much helpful. thank you.
@SimonSezIT
@SimonSezIT 11 месяцев назад
Glad it was helpful! 🙂 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
@questionresearch8721
@questionresearch8721 Год назад
Deborah makes Sumifs fun and easy.
@SimonSezIT
@SimonSezIT Год назад
She makes everything look easy. 😊
@ghettoghost2657
@ghettoghost2657 8 месяцев назад
absolutely fantastic lesson
@SimonSezIT
@SimonSezIT 8 месяцев назад
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@oskarhaas824
@oskarhaas824 Год назад
That's great training
@SimonSezIT
@SimonSezIT Год назад
Glad you are enjoying the training. 😀
@አንዲትኢትዮጵያ
@አንዲትኢትዮጵያ 5 месяцев назад
Thanks!!
@SimonSezIT
@SimonSezIT 5 месяцев назад
You are very welcome! Glad it was helpful. 🙂
@rubelmahmud328
@rubelmahmud328 9 месяцев назад
Great channel to excel effectively for free
@SimonSezIT
@SimonSezIT 8 месяцев назад
Glad you enjoyed it. Thanks for watching! 🙂 🔥Please check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Далее
Excel Formulas for Beginners - 1+ Hour Class!
1:07:31
Просмотров 22 тыс.
Обменялись песнями с POLI
00:18
Просмотров 333 тыс.
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
Excel Formulas and Functions | Full Course
52:40
Просмотров 1,5 млн
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Master the IF Formula in Excel (Beginner to Pro)
11:16
Просмотров 475 тыс.
Top 10 Most Important Excel Formulas - Made Easy!
27:19