Custom Search
Provided by: Last Minute Training

Microsoft Excel - Module 2 Functions and Multiple Worksheets

Excel

Last Minute Training
Training Provided by Last Minute Training This course is the second of six modules (levels) that we have to offer for Microsoft Excel 2000/2002/2003...

Objectives

* Use labels and reference names in formulas
* Use simple and complex mathematical
* functions
* Manage workbook worksheets
* Perform calculations with references to multiple
* worksheets and multiple workbooks
* Summarize data with data consolidation
* Exchange data between Office applications
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:intermediate
Duration:1 days
Training Presented in:English
Microsoft Excel - Module 2 Functions and Multiple Worksheets .Use functions to do calculations
Use label in formulas
Create reference name
Apply a reference name to a value
Go to a reference name
Use a reference name in formulas
Substitute a name in a formula
.Use functions to do calculations
Enter and edit function syntax
Perform statistical and time calculations
Introduce and develop conditional formulas
Change the appearance of text data with text functions
.Organize workbook worksheets
Introduce and manipulate
workbook worksheets
Rename worksheets
Group worksheets
Insert, delete and hide
worksheets
Copy or move worksheets
.Introduce and manipulate linking
Introduce worksheets linking and maintain formulas
Maintain links
Open a workbook that has lost its links
List auxilary workbooks
.Consolidate data
Introduce and perform data
consolidation by position or
by category
Modify a consolidation
.Verify workbook formulas
Access formula Audit functions
Find antecedents and dependents
Select antecedents and dependents
.Exchange data between Office applications
Reproduce data in another
Office application
Know differents data
reproduction formats
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Advertise With Us
Want to Sell More microsoft excel training?
This page was last updated on sb5- 09/07/08 at 13:08:13 - 08:55:05