|
Provided by: Serebra Learning Corporation Data Management and Analysis with Excel 2002Excel |
 |
Training
Provided by Serebra Learning Corporation
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 course teaches the usage of the Analysis ToolPak Data Analysis tools to perform various calculations in a single step. This course is designed for users who are familiar with the Excel 2002 interface and need to use numeric data for performing mathematical calculations and data analysis. The user should have some prior knowledge of financial and statistical calculations.
|
|
||||||||||
Data Management and Analysis with Excel 2002
Audience
This course is designed for users who are familiar with the Excel 2002 interface and need to use numeric data for performing mathematical calculations and data analysis. The user should have some prior knowledge of financial and statistical calculations.
Topics
Using Formulas
- Performing Basic Calculations with Formulas
- Using Names and Array Formulas
- Auditing Formulas and Troubleshooting Errors
- Quiz
Using Functions
- Using Simple Functions
- Using Date and Time Functions
- Quiz
Using Logical and Text Functions
- Using Logical and Lookup Functions
- Using Text Functions in Excel
- Quiz
Using Financial and Statistical Functions
- Performing Financial Analysis
- Performing Statistical Analysis
- Using the Analysis ToolPak
- Quiz
Objectives
Upon completion of 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 mathematical functions
- Use date and time functions, and specialized date functions
- Use logical, lookup, and reference functions
- Use basic text functions in Excel, and manipulate strings and substrings
- Use basic financial functions
- Use functions for calculating depreciation and analyzing securities
- Use basic functions for statistical analysis
- Calculate linear and exponential regression
- Use the Analysis Toolpak Data Analysis tools
- Generate random numbers using the Analysis ToolPak
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
