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.
CPA PD
