Basic Excel Course 2003

Quick Links to Other Excel Courses

1. Microsoft Excel Intermediate Course
2. Microsoft Excel Advanced Course
3. Microsoft Excel VBA Course

Duration:

1 day

Prerequisites:

Windows 2000: Basic or equivalent experience

GETTING STARTED

• What's New In Excel 2003

• How To Start Excel 2003

• How To Create a New Default Excel Workbook

• 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

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

• 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

• 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

How To Enter A Formula Using Keyboard

• How To Enter A Cell or A Range Reference Using Mouse

• How To Use AutoSum To Calculate A Total Quickly

• How To Use Relative References

• How To Use Absolute References

• How To Enter A Function Directly

• How To Use Paste Function

• How To Use AutoCalculate To Calculation Without Using Formula

MANAGING WORKSHEETS

• 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

FORMATTING WORKSHEETS

• 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

• How To Change Font

• How To Change Font Size

• How To Bold

• How To Italic

• How To Underline

• How To Change Font Colour

• How To Align Data In A Cell

• How To Indent Data In A Cell

• How To Merge Cells And Centre Data

• How To Change Number To Percentage

• How To Increase / Decrease Decimal Points

• How To Copy Format Using Format Painter

• How To Format Table Using AutoFormat

CREATING CHARTS

• 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

• 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

PAGE SETUP AND PRINT

• 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 Centre Of Page

• How To Add Header / Footer

• How To Print Preview

• How To Print Active Sheets

• How To Print Selected Cells

• How To Print Chart

• How To Multiple Copies