The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyze data. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, HLOOKUP, INDEX, ROW, and COLUMNS. Math & Trig functions provide multiple methods of working with numbers and triangles. This course explores rounding functions, INT, TRUNC, AGGREGATE, COS, SIN, and TAN. Excel 2010 also provides a number of functions to make working with text easier. Text functions, such as TRIM, CLEAN, PROPER, SEARCH, and MID, as well as string concatenation, are covered.

Objectives

Use lookup functions in Excel 2010

Recognise when to use the lookup functions in Excel 2010

Use reference functions in Excel 2010

Use math functions in Excel 2010

Recognise when to use the rounding functions in Excel 2010

Use trig functions in Excel 2010

Use text functions in Excel 2010

Use advanced functions in Excel 2010

Audience

End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments