SkillSoft Explore Course – Lambers, Inc.

Productivity & Collaboration Tools Microsoft Office 2010 Microsoft Office 2010: Excel for Power Users

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.

Asset ID	mo_pexl_a03_dt_enus
Course Type	Video Course
Course Category	Microsoft Office 2010

Objectives
Advanced Functions in Excel 2010 use lookup functions in Excel 2010 recognize when to use the lookup functions in Excel 2010 use reference functions in Excel 2010 use math functions in Excel 2010 recognize 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