|
Table
of Contents: Module 1
GETTING
STARTED
Creating
An Excel 2003 Workbook
What's
New In Excel 2003 
How
To Start Excel 2003
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 And Maintenance
How
To Search Help
How To Use Content Help
How To Use Microsoft Office Online
How To Use Type A Question For Help Box
How To Use Office Assistant Help
How To Use Get Help In A Dialog Box
How To
Get Office Updates From Microsoft Office Online
How To Detect And Repair Errors In Excel
How To Recover Excel When It Is Not Responding
How To Set The AutoRecover Options
How To Recover An Excel File
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 Contents Using Formula Bar
How To Replace Contents In A Cell
How To Delete Contents In A Cell
How
To Undo And Redo
How To Enter Number As A Value Into A Cell
How To Enter Number As A Label Into A Cell
How To Enter Date
Into A Cell
How To Use AutoFill To Enter Text
How
To Use AutoFill Options
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 Save Into A Different File Format
How To Close The Current Workbook
How To Open A Workbook
How To Exit Excel 2003
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 Use Paste Options
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 Hide And Unhide Worksheet
How
To Hide And Unhide Workbook
How
To Format Worksheet Tab
How
To Add Worksheet Background
How To Delete Worksheet
EXERCISES
Exercise - Getting Started
Exercise - Performing Calculations
Exercise - Managing Worksheet and Workbook Information
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
How
To Hide / Unhide Rows / Columns
How
To Freeze A Column / A Row
How
To Slit A Worksheet In Panes
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
How
To Copy Format Using Format Painter
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 Insert And Remove Page Break
How
To Set And Clear Print Area
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
|