Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Serebra Learning Corporation

Data Management and Analysis with Excel 2002

Click here for more information or to take this course 		Serebra Learning Corporation
  home  : Computer  : Microsoft Office  : Excel
Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

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.

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:5 hours
Training Presented in:English
Related Keywords:  microsoft   office   advanced   excel   2002   data   management   analysis   completion   this course   student   will   able   insert formulas   worksheet   define   manage cell   range   names   array   formulas   array constants   audit formulas   troubleshoot   formula   errors   selected   mathematical   functions   use date   time functions   specialized   date   use logical   lookup   reference   basic   text   manipulate strings   substrings   financial   use functions   calculating depreciation   analyzing   securities   statistical analysis   calculate linear   exponential   regression   toolpak   tools   generate   random   numbers 

Training Program Details

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 Serebra Learning Corporation - Training Provider

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...
More Microsoft Office XP Advanced Excel 2002 Training from Serebra Learning Corporation
Click here for more information or to take this course
Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links
Training-Classes.com by Skillbox® 07/18/08
Copyright 1998-2008 skillbox, inc. All rights reserved		 Connecting people who want to learn with people who love to teach
 Are you a Microsoft training provider?
You could be on this page today - for FREE!
This page was last updated on sb5 - 07/18/08 at 04:34:31 - 05:54:18