Excel 2003 Basic

Excel 2003 Basic

This course teaches the basic functions and features of Excel 2003. Students will learn how to enter and edit data, labels, and formulas, work with functions, format cells, print worksheets, and create charts.

Upon successful completion of this course, students will be able to:

create a basic worksheet.
modify a worksheet.
perform calculations.
format a worksheet.
develop a workbook.
print the contents of a workbook.
customize the layout of the Excel window.

GETTING STARTED
Creating An Excel 2003 Workbook
What’s New In Excel 2003
How To Start Excel 2003
Creating a New Default Excel Workbook

Getting Familiar With The Excel Screen
Using The Menu
How To Show Or Hide Toolbars
Moving The Toolbar And Menu Bar
How To Use The Toolbar Button
How To Use Shortcut Menu Using Right Mouse Click
Using the Shortcut Key
Searching for Excel 2003 Help
How To Use Content Help
Using Microsoft Office Online For Help
How To Use The Type A Question For Help Box
Using The Office Assistant Help

Moving Around Your Cursor
Activating A Cell Using The Mouse
Move To A Cell Using Your Keyboard
How To Move Using The Go To Command
How To Move using The Name Box
Moving Within A Selected Range
How To Move To Other Sheets Within A Workbook

Selecting Range In A Workbook

Selecting A Single Cell
How To Select A Range of Cells
Using The Shift Key To Select A Range Of Cells
How To Select An Entire Column
How To Select The Entire Row
Selecting 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
Editing Contents Using The Formula Bar
Replacing Contents In A Cell
How To Delete Contents In A Cell
How To Undo And Redo
Entering A Number As A Value Into A Cell
How To Enter A Number As A Label Into A Cell
Entering The Date Into A Cell
Using AutoFill To Enter Text
How To Use AutoFill Options
Using AutoFill To Enter Sequence Numbers
Customising AutoFill
How To Use The Pick List To Enter Data
Entering Data Into A Range Of Cells
How To Fill A Range Of Cells With The Same Data
Saving A Workbook For The First Time
How To Save Another Copy Using `Save As’
How To Save To Another Folder
Saving As A Different File Format
How To Close The Current Workbook
How To Open An Existing 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 The Mouse
Using AutoSum To Calculate A Total Quickly
How To Use Relative References
How To Use Absolute References

Using Simple Functions
How To Enter A Function Directly
How To Use The Paste Function

Using AutoCalculate
How To Use AutoCalculate For Calculations Without Using Formula
MANAGING WORKSHEETS
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
Using The Paste Options
How To Copy Information Using Drag And Drop
Inserting A New Row
How To Insert Multiple Rows
Deleting Rows
Inserting A New Column
How To Insert Multiple Columns
Deleting Columns
How To Insert A Cell

FORMATTING WORKSHEETS
Adjusting Column Width / Row Height
How To Adjust Column Width Using Mouse
How To Adjust Column Width Using Menu
Adjusting The Row Height Using Your Mouse
Adjusting The Row Height Using Menu
How To Hide / Unhide Rows / Columns
Freezing A Column / A Row
How To Split A Worksheet In Panes

Formatting Cells Using Toolbar
How To Change Font
How To Change Font Size
How To Bold
How To Italic
How To Underline
How To Change Font Colour
Aligning Data In A Cell
How To Indent Data In A Cell
How To Merge Cells And Centre Data
Changing A Number To A Percentage
How To Increase / Decrease Decimal Points
Using Format Painter To Copy Formatting
How To Format Table Using AutoFormat

CREATING CHARTS
Creating A Chart Using The Chart Wizard
How To Use The Chart Wizard
How To Move A Chart
How To Resize A Chart
Changing The Chart Type
Changing The Chart Source Data
How To Swap Data Series In The Legend With The X-axis
How To Move An Existing Chart To Another Worksheet

Changing Chart Options
How To Change Chart Title, X axis And Y axis Title
How To Change gridlines
Changing The Legend Options
How To Change The Data Labels
How To Add A Data Table
Deleting A Data Series
How To Add A Data Series Using The Mouse
How To Delete A Chart

PAGE SETUP AND PRINT
Page Setup
How To Insert And Remove Page Break
How To Set And Clear Print Area
Changing The Page Orientation
How To Change Scaling
Changing The Paper Size
Setting The Page Margins
How To Align To Centre Of Page
Adding A Header / Footer

Previewing and Printing
How To Print Preview
How To Print Active Sheets
How To Print Selected Cells
How To Print Chart
Printing Multiple Copies

Pages:- 1
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>