Microsoft Excel 2000 Training Manual

Table of Contents: Module 1

GETTING STARTED

Creating An Excel Workbook

How To Start Excel 2000

How To Create a New Default Excel Workbook
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 2000

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

©2003 EBook Publishing. All rights reserved.

Web Site: http://www.computertrainingmanual.com
Email: info@computertrainingmanual.com