Data Management and Analysis with Excel 2002 The Data Management and Analysis with Excel 2002 WBT is the second course in the Office XP: Excel 2002 curriculum. This course teaches the user how to effectively manage data in Excel and analyse data based on certain functions. The functions dealt with in this course include mathematical, logical, date and time, text, lookup and reference, financial, and statistical functions. Additionally, the more...
Data Management and Analysis with Excel 2002 ...dditionally, the course teaches the usage of the Analysis ToolPak Data Analysis tools to perform various calculations in a single step. After completing this course, the student will be able to:
Insert formulas in an Excel worksheet
Define and manage cell and range names
Use array formulas and array constants
Audit formulas
Identify and troubleshoot formula errors
Use selected more...