Auditing Tools, Circular References, and IF Functions

Auditing Tools, Circular References, and IF Functions

$99.00 for 1 year

Course Overview:

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.

Key Topics:

  • How to use trace precedents and trace dependents, showing you which cells are dependent on a calculation
  • How to use IF Statements to return values based on true and false arguments
  • How to use the AGGREGATE Function to ignore certain values in a calculation
  • The power of the IFERROR function
  • Nesting IF functions with other functions such as VLOOKUP, MATCH, and INDEX

Who Will Benefit?

Any professional that uses Microsoft Excel. Learning IF functions is critical to being proficient in Microsoft Excel.