A little learning is dangerous thing.

Alexander Pope

Ebooks:

Top 20

New

Free

Add Ebook

My Account

eBook Category

Search Ebooks:

Members Login: Login: Password:

Join Buy-eBook.com!
Gold Membership! 1000+ E-books.	$49.95
Silver Membership! Any 100 E-books.	$29.95

New Ebooks Newsletter:

Sign Up

And download free Ebooks!

Own a website or a blog?
Link to eLibrary and
download 1000+ Ebooks
for Free!

	Popular Ebooks:

	Sponsored Books:

	eLibrary News:

Microsoft Excel 2002 Training Manual Ebook

MS Excel 2002

visit|rate|error

E-book Category: Computers, Programming
E-book Title: Microsoft Excel 2002 Training Manual
Book Description: Microsoft Excel 2002 Training Manual

Our CompleteVISUALTM computer training manual is now used in over 60 countries worldwide! Why are we the best seller:

The first ever-created complete visual step-by-step training manuals
Unlimited printing rights
No annual renewal fees
Suitable for all levels of users
Low cost site license but high quality manuals
Independent hands on lessons and completely customizable

Microsoft Excel 2002 Training Manual
Table of Contents: Module 1

GETTING STARTED

Creating An Excel 2002 Workbook

How To Start Excel 2002

How To Create a New Default Excel Workbook Using Task Pane
How To Create A New Excel Workbook Using Template

Getting Familiar With The Excel Screen

How To Use Menu

How To Show Or Hide Toolbars

How To Move Toolbar And Menu Bar

How To Use Toolbar Button

How To Use Shortcut Menu Using Right Mouse Click

How To Use Shortcut Key

Getting Help

How To Use Office Assistant Help
How To Use Contents Help
How To Use Answer Wizard Help
How To Use Index Help
How To Use What's This Help

Moving Around Your Cursor

How To Activate A Cell Using The Mouse
How To Move To A Cell Using Keyboard
How To Move Using Go To Command
How To Move using Name Box
How To Move Within Selected Range
How To Move To Other Sheets within A Workbook

Selecting Range In Workbook

How To Select A Single Cell
How To Select A Range of Cells
How To Select A Range Of Cells Using Shift key
How To Select The Entire Column
How To Select The Entire Row
How To Select The Entire Worksheet
How To Select Non-Adjacent Ranges
How To Select Multiple Worksheets

Entering Data into Worksheet

How To Enter Text (Label) Into A Cell
How To Edit Cell Content
How To Edit Text Using Formula Bar
How To Replace Text In The Cell
How To Delete Text In The Cell
How To Enter Number (Value) Into A Cell
How To Enter Date (Value) Into A Cell
How To Use AutoFill To Enter Text
How To Use AutoFill To Enter Sequence Numbers
How To Customize AutoFill
How To Use Pick List To Enter Data
How To Enter Data Into A Range Of Cells
How To Fill A Range Of Cells With The Same Data
How To Save A Workbook For The First Time
How To Save Another Copy Using `Save As'
How To Save To Another Folder
How To Save Into A Diskette
How To Close The Current Workbook
How To Open A Workbook
How To Exit Excel 2002

PERFORMING CALCULATIONS

Using Simple Formula

How To Enter A Formula Using Keyboard
How To Enter A Cell or A Range Reference Using Mouse
How To Use AutoSum To Calculate Total Quickly
How To Use Relative References
How To Use Absolute References

Using Simple Functions

How To Enter A Function Directly
How To Use Paste Function

Using AutoCalculate And Labels

How To Use AutoCalculate To Calculation Without Using Formula
How To Accept Labels In Formulas
How To Use Label (Natural Language) In Formula

MANAGING WORKSHEET AND WORKBOOK INFORMATION

Managing Worksheet Information

How To Move Information Using Cut And Paste
How To Move Information Using Drag And Drop
How To Copy Information Using Copy And Paste
How To Copy Information Using Drag And Drop
How To Insert A New Row
How To Insert Multiple Rows
How To Delete Rows
How To Insert A New Column
How To Insert Multiple Columns
How To Delete Columns
How To Insert A Cell

Managing Workbook Information

How To Rename Worksheet
How To Add New Worksheet
How To Rearrange Worksheet
How To Copy Worksheet
How To Delete Worksheet

EXERCISES

Exercise - Getting Started
Exercise - Performing Calculations
Exercise - Managing Worksheet and Workbook Information

Microsoft Excel 2002 Training Manual
Table of Contents: Module 2

FORMATTING WORKSHEET

Adjusting Column Width / Row Height

How To Adjust Column Width Using Mouse
How To Adjust Column Width Using Menu
How To Adjust Row Height Using Mouse
How To Adjust Row Height Using Menu

Formatting Cell Using Toolbar

How To Change Font
How To Change Font Size
How To Bold
How To Italic
How To Underline
How To Change Font Color
How To Align Data In A Cell
How To Indent Data In A Cell
How To Merge Cells And Center Data
How To Change Number To Percentage
How To Increase / Decrease Decimal Points

Formatting Cell Using Menu Options

How To Double Underline Using Menu Option
How To Align Vertically
How To Change Text Orientation
How To Wrap Text In A Cell
How To Format Numbers
How To Format Date
How To Change Cell Background Color
How To Add Outline Border
How To Add Double Line Border
How To Format Table Using AutoFormat

CREATING CHART

Creating Chart using Chart Wizard

How To Use Chart Wizard
How To Move Chart
How To Resize Chart
How To Change Chart Type
How To Change Chart Source Data
How To Swap Data Series In Legend With The X-axis
How To Move Existing Chart To Another Worksheet

Changing Chart Options

How To Change Chart Title, X axis And Y axis Title
How To Change Gridlines
How To Change Legend Options
How To Change Data Labels
How To Add Data Table
How To Delete Data Series
How To Add Data Series Using Mouse
How To Delete Chart

Formatting Chart

How To Change Font Format
How To Change Text Orientation
How To Change Object Color
How To Change The Order Of Data Series
How To Use Combination Of Chart Type
How To Create A Pie Chart
How To Use 3-D View To Rotate Chart
How To Explode A Wedge In Pie Chart
How To Create A Picture Chart

SETTING UP PAGE AND PRINT

Setting Up Page

How To Change Page Orientation
How To Change Scaling
How To Change Paper Size
How To Change Page Margin
How To Align To Center Of Page
How To Add Header / Footer

Previewing and Printing

How To Print Preview
How To Print Active Sheets
How To Print Selected Cells
How To Print Chart
How To Multiple Copies

EXERCISES

Exercise - Formatting Worksheet
Exercise - Creating Chart
Exercise - Setting Up Page and Print

Microsoft Excel 2002 Training Manual
Table of Contents: Module 3

VALIDATING, PROTECTING, AUDITING FORM AND TEMPLATE
Using Data Validation

How To Validate Data Input
How To Compose Data Input Message
How To Create Error Alert Message

Creating New Workbook Using Template

How To Create A New Workbook Using Built-In Template
How To Create A New Template
How To Create New Workbook From Own Template
How To Edit The Template

Protecting Worksheet Style And Content

How To Protect The Worksheet
How To Unprotect The Worksheet
How To Enable Cell For Editing In Protected Sheet
How To Hide Cell Formula In Protected Sheet
How to Protect Workbook Content
How To Protect The Workbook Structure
How To Unprotect The Workbook Structure

Protecting Your Workbook From Unauthorized Users Access

How To Set Password To Open
How To Remove Password To Open
How To Set Password To Modify

Auditing Worksheets And Tracing Cell References

How To Find Precedents Cells
How To Find Dependent Cells
How To Hide All The Arrows

Tracing Errors

How To Circle And Remove Circle For Invalid Data

WORKING WITH ADVANCE FORMATTING, STYLE AND OUTLINING
Customizing Data Appearance With Advance Formatting

How To Use Build-In Number Formats
How To Custom Number Format
How To Custom Date Format

Using Conditional Formatting

How To Use Conditional Formatting

Maintaining Format Consistency With Style

How To Add Style Box Tool To The Toolbar
How To Create New Style
How To Apply Styles
How To Redefine Style
How To Delete Style
How To Merge Style From Another Workbook

Using Data Outlining

How To Create An Outline Automatically
How To Remove Outline
How To Create Outline Manually
How To Use Subtotal To Create Outline
How To Show / Hide Details Using Outline Symbols
How To Remove Subtotal

WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
Managing Data in Multiple Worksheets

How To Select Adjacent Worksheets
How To Select Non-Adjacent Worksheets
How To Enter Data Into Multiple Worksheets
How to Use 3-D Formula Across Worksheet
How To Enter 3-D Formula Across Worksheets
How To Enter 3-D Formula Across Worksheets Using Function

Using Range Name

How To Define A Range Name
How To Define A 3-D Range Name Using The Menu
How To Redefine The Cell References In Range Name
How To Delete A Range Name
How To Use Range Name In Formula

Combining Worksheets And Data From Different Workbooks

How To Consolidate Data
How To Move Or Copy Worksheets to Another Workbook
How to link information from different worksheets and workbook
How To Link Information Using Copy And Paste Link
How To Update Link

USING ADVANCE FUNCTIONS
Using Financial Functions

How To Use PMT Function
How To Use ABS Function
How To Use Logical Test
How To Use IF Function To Return A Text
How To Use IF Function To Return A Value
How To Use Nested IF Function
How To Use OR Function
How To Use AND Function
How To Use COUNTIF Function

USING WORKGROUP FEATURES
Using Comments

How To Add Comment Into A Cell
How To Show/Hide Comment Indicators
How To Edit And Delete Comments

Sharing Workbooks

How To Enable Workbook Sharing
How To Disable Workbook Sharing

How To Copies Of Shared Workbook

How To Track Changes In Shared Workbook

How To Accept Or Reject Changes

EXERCISES
Exercise - Validating, Protecting, Auditing Form And Template
Exercise - Using Advance Formatting, Style And Outlining
Exercise - Working With Multiple Worksheets And Workbooks
Exercise - Using Advance Functions
Exercise - Using Workgroup Features

Microsoft Excel 2002 Training Manual
Table of Contents: Module 4

CREATING POWERFUL DATABASE
Creating Database

How To Create Database Field
How To Add Records Manually
How To Add New Record Using A Built-In Data Form

Managing Record in Database

How To Search For The Record Using Data Form
How To Edit / Delete The Record Using Data Form

Sorting Records

How To Perform Simple Sort

Using AutoFilter

How To Enable / Disable AutoFilter
How To Apply / Remove The Criteria In The Database Using AutoFilter
How To Customize Criteria In AutoFilter
How To Use Wildcard In Criteria

Using Advance Filter

How To Define The Criteria Range Example Of The Criteria Range
How To Use The Advance Filter Command

Using Simple Database Functions

How To Find The Sum Of Specific Records Using Paste Function
How To Find The Average Of Specific Records
How To Find The Maximum / Minimum Value Of Specific Records
How To Find The Number Of Records

Using VLOOKUP Function

How To Use VLOOKUP To Find Data
How To Limit The Lookup Value For Exact Match
How To Use The Closest Match For The Lookup Value

CREATING PIVOT TABLE AND ANALYZING DATA
Creating Pivot Table

How To Create A Pivot Table

Updating Pivot Table

How To Update Information In Pivot Table
How To Add Information In Pivot Table
How To Arrange Information In Pivot Table
How To Remove Information In Pivot Table
How To Create Page In Pivot Table
How To Display Pages On Separate Sheets

Modifying Calculated Field in Pivot Table

How To Use Other Functions In Calculated Fields
How To Insert Calculated Fields
How To Hide Calculated Fields
How To Delete Calculated Fields

Creating Chart From Pivot Table

How To Create Chart From Pivot Table

Exploring What-If Table

How To Create One Variable What-If Table
How To Create Two Variable What-If Table

Using Scenarios

How To Create Scenarios
How To Apply Scenario
How To Edit Scenario
How To Delete Scenario

Implementing Problem Solving

How To Use Goal Seek

AUTOMATING ROUTINE TASKS WITH MACROS
Understanding Macros

How To Record New Macro

How To Run Macro With Menu

How To Create A Run Macro Button On Toolbar

How To Create Macro Command Button On Worksheet

How To Edit Command Button

Editing Macro

How To Edit Macro Coding
How To Rename Macro

How To Delete Macro

Using Relative Reference Macro

How To Record A Relative Reference Macro
How To Run Relative Reference Macro

IMPORTING AND EXPORTING DATA
Importing / Exporting Data

How To Use Text Import Wizard
How To Export Data To A Document
How To Copy Data From Other Applications
How To Insert Objects

EXERCISES

Exercise - Creating Powerful Database
Exercise - Creating Pivot Table And Analyzing Data
Exercise - Automating Routine Tasks With Macros
Exercise - Importing And Exporting Data

More...

	Recommended Product for "MS Excel 2002"

Related Ebooks:


	Microsoft Excel 2002 Training Manual Category: Computers, Programming Price: $350 microsoft excel e books manual		Microsoft Word 2002 Training Manual Category: Computers, Programming Price: $350 Start Excel and run macro
	Microsoft Excel 2000 Training Manual Category: Computers, Programming Price: $350 lookup values in another workbook		Microsoft Excel 2003 Training Manual Category: Computers, Programming Price: $350 ebook for MS Excel
	Microsoft Access 2002 Training Manual Category: Computers, Programming Price: $350 BUILT IN DATA FORM IN MS EXCEL		Microsoft Project 2002 Training Manual Category: Computers, Programming Price: $350 cell references in Excel 2002
	Microsoft Outlook 2002 Training Manual Category: Computers, Programming Price: $350 advance functions in MS excel		Microsoft Publisher 2002 Training Manual Category: Computers, Programming Price: $350
	Microsoft FrontPage 2002 Training Manual Category: Computers, Programming Price: $350		Microsoft PowerPoint 2002 Training Manual Category: Computers, Programming Price: $350
	Microsoft Word 2000 Training Manual Category: Computers, Programming Price: $350		Microsoft Word 2003 Training Manual Category: Computers, Programming Price: $350
	Microsoft Excel 2002 XP & 2003 Category: Computers, Programming Price: $19.95		Microsoft Windows 98 Training Manual Category: Computers, Programming Price: $350
	Microsoft Windows XP Training Manual Category: Computers, Programming Price: $350