| | 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: Teach Me IT

Data Management and Analysis with Excel 2002

Click here for more information or to take this course

Get More Information

Search for Training

Find Your Genius!

Training Provided by Teach Me IT

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. 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 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

Training Avaliability and Delivery

This is primarily online training
	This is an online eLearning or CBT training program
	This course may be available for home-study
	Contact Teach Me IT for more information

Schedule:	flexible
Training Presented in:	English

Related Keywords: office xp excel 2002 data management analysis data management with excel 2002

Training Program Details

Other Courses in the Curriculum

Getting Started with Excel 2002

Using Advanced Data Management Techniques

Enhancing and Securing Data

Course Name	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.
Course Requirements	You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above. Plug-in Requirements ØMacromedia Shockwave plug-in for Windows for IE/NN ØMacromedia Flash plug-in for Windows for IE/NN Note: Macromedia Flash plug-in comes built in with IE 5.5 and above and NN 6.x. To download the plug-ins, click on the relevant icon below.
Pre-requisites	The users should be comfortable with the Excel interface and basic data entry techniques. Additionally, they should be familiar with basic operations in Excel, such as formatting data and navigating worksheets.
Course Duration	6.1 hours
Course Objectives	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. 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 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
Course Outline	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

About Teach Me IT - Training Provider

Teach Me IT - TeachMeIT is a comprehensive repository for online training courses and provides high quality, state-of-the-art IT and business related e-learning trainings and courses. With offerings ranging from desktop and MS office to networking and database courses, TeachMeIT provides training in both web-based as well as CD-based formats. Competitive prices, rich quality content, exhaustive...

More Office XP: Excel 2002 Training from Teach Me IT

Click here for more information or to take this course

Custom Search

Training Directory \| New Training Seminars \| New Training Providers \| Search \| Site Map \| Promote Training \| Login \| Links

	Training-Classes.com by Skillbox® 07/19/08 Copyright 1998-2008 skillbox, inc. All rights reserved

Are you an Office xp training provider?

You could be on this page today - for FREE!