This course is for those people who have mastered Excel on at least an introductory level and need to create larger, more complex worksheets. Learn about range names and how to use them in formulas. Learn the most efficient ways to work with multiple-sheet workbooks. Discover how to link data from one sheet to other sheets and from one workbook to other workbook files using 3-D and array formulas. Learn to use the functions TODAY, NOW, IF, PMT, VLOOKUP AND HLOOKUP.Understand formula errors ans how to fix them.
PRE-REQUISITES:
Excel Level 1 (2000, 2002 or 2003)