Format: On-demand
This course is for Microsoft® Windows Excel 2013 and newer versions, including 365. This course will be an overview of:
- Learn how Excel’s various IF functions can be used to supercharge your spreadsheets. Formulas involving the IF function are among the most important formulas in Excel. IF statements allow you to enter values in a cell based on logical conditions. For example, you can use an IF formula to compute a salesperson’s commission based on his sales.
Becker’s Microsoft® Excel Series features Wayne Winston, Microsoft® Press author for more than a decade with 40 teaching awards for his instruction. Wayne is sought out by many of the Big 4 and larger corporations to bring their personnel to a level playing field with Microsoft® Excel, necessary today for success in the accounting profession.
Wayne’s success as a Microsoft® Excel instructor is closely tied to his teaching style that has students watch and then do realistic, engaging problems in the software. Students learn through using Microsoft® Excel to cement their understanding before progressing to the next building block.
Learning Objectives
After completing this course, the learner should be able to:
- Learn how to harness the power of the IF and IFS functions.
- Learn to use the IFERROR function to ensure your colleagues don’t see ugly errors.
- Learn how to use ISERROR, ISERR, ISNA, ISNUMBER, ISTEXT.