In these step-by-step tutorials, learn how to use Microsoft Excel. Find out how to get started with MS Excel in under 10 minutes. Learn about Pivot Tables, formulas and functions, vlookup, shortcuts. Also, find out about the latest new features and the top tips and tricks.
Curated by: Kevin Stratvert (120 videos)
๐ฅ Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com Learn how to use the IF function, one of the most popular functions in Microsoft Excel. The IF function allows you to make logical comparisons between a value and what you expect. An IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF(C2=โYesโ,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2). Microsoft support article on using the IF Function: https://support.office.com/en-us/article/IF-function-69AED7C9-4E8A-4755-A9BC-AA8BBFF73BE2 Access the sample data that I use in this video here: https://1drv.ms/x/s!AmxrofZZlZ-whIZwdMF_j150IEu-cA?e=Z5YZYQ Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com As full-disclosure, I work at Microsoft as a full-time employee.