This one-day course will show you how go beyond the basic Excel formulas. You will learn to efficiently summarize your data in Excel using advanced logical, reference, text, and date functions.

Performance Objectives: Upon completion of this course, you should be able to:

• Use logical functions such as If, If Error, and Count If.
• Use reference functions such as VLookup, Match, and Index.
• Use text functions such as Concatenate, Large, Small, Left, Right, Upper, Proper, and Lower.
• Use date functions such as Today and Now.
• Use nested functions to combine formulas.
• Split a single column of data into multiple columns.
• Use data validation.
• Quickly calculate rows of related data.
• Use range names to simplify building function formulas.
• Recognize and handle typical formula errors.

Prerequisites: We recommend you have a good understanding of Excel before registering for this class.

Intended Audience: All audiences that work with large amounts of data in Excel.