$99.00 / year
This course covers Auditing Tools, Circular References, and IF Functions. You will learn how to use Excel’s logic functions, such as IF statements to help return results based on if a statement is true and another result if a statement is false. MASTERING IF Statements is a must if you want to consider yourself an “Excel Guru.”
You will also learn how the IFERROR function will ensure that your boss does not complain about seeing ugly error messages such as #REF or #DIV/0.
Auditing tools which enable you to determine the spreadsheet formulas that depend on a model assumption or the inputs used to compute a spreadsheet formula are also covered.
Finally, you will learn how easy it is to resolve the circular references that baffle many Excel users.
Who Will Benefit?
Any professional that uses Microsoft Excel. Learning IF functions is critical to being proficient in Microsoft Excel.