Excel 2007 Advanced Functions

Excel Advanced Functions [3.5 hrs]

Learn how to use advanced functions in Excel such as IF, COUNTIF, OR and more. These functions can help make your data give you the results you need! You'll learn:

• Use the Formula Auditing bar to which cells are dependent upon each other.
• Auto calculate using Dates
• Simple functions such as SUMIF, COUNTIF, and AVERAGE
• Use IF, OR, COUNTA to make your formulas more advanced

This class is taught in Excel 2007 and is not appropriate for users of older versions.

Prerequisites: Excel 2007 Foundations or equivalent knowledge.

« Back to Class Catalog