GETTING STARTED
Creating An Excel 2003 Workbook
- What's New In Excel 2003
- Start Excel 2003
- Creating a New Default Excel Workbook
Getting Familiar With The Excel Screen
- Using The Menu
- Show Or Hide Toolbars
- Moving The Toolbar And Menu Bar
- Use The Toolbar Button
- Use Shortcut Menu Using Right Mouse Click
- Using the Shortcut Key
- Searching for Excel 2003 Help
- Use Content Help
- Using Microsoft Office Online For Help
- 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
- Move Using The Go To Command
- Move using The Name Box
- Moving Within A Selected Range
- Move To Other Sheets Within A
Workbook
Selecting Range In A Workbook
- Selecting A Single Cell
- Select A Range of Cells
- Using The Shift Key To Select A Range Of Cells
- Select An Entire Column
- Select The Entire Row
- Selecting The Entire Worksheet
- Select Non-Adjacent Ranges
- Select Multiple Worksheets
Entering Data Into Worksheet
- Enter Text (Label) Into A Cell
- Edit Cell Content
- Editing Contents Using The Formula Bar
- Replacing Contents In A Cell
- Delete Contents In A Cell
- Undo And Redo
- Entering A Number As A Value Into A Cell
- Enter A Number As A Label Into A Cell
- Entering The Date Into A Cell
- Using AutoFill To Enter Text
- Use AutoFill Options
- Using AutoFill To Enter Sequence Numbers
- Customising AutoFill
- Use The Pick List To Enter Data
- Entering Data Into A Range Of Cells
- Fill A Range Of Cells With The Same Data
- Saving A Workbook For The First Time
- Save Another Copy Using `Save As'
- Save To Another Folder
- Saving As A Different File Format
- Close The Current Workbook
- Open An Existing Workbook
- Exit Excel 2003
PERFORMING CALCULATIONS
Using Simple Formula
- Enter A Formula Using Keyboard
- Enter A Cell or A Range Reference Using The Mouse
- Using AutoSum To Calculate A Total Quickly
- Use Relative References
- Use Absolute References
Using Simple Functions
- Enter A Function Directly
- Use The Paste Function
Using AutoCalculate
- Use AutoCalculate For Calculations Without Using Formula
|
MANAGING WORKSHEETS
Managing Worksheet Information
- Move Information Using Cut And Paste
- Move Information Using Drag And Drop
- Copy Information Using Copy And Paste
- Using The Paste Options
- Copy Information Using Drag And Drop
- Inserting A New Row
- Insert Multiple Rows
- Deleting Rows
- Inserting A New Column
- Insert Multiple Columns
- Deleting Columns
- Insert A Cell
FORMATTING WORKSHEETS
Adjusting Column Width / Row Height
- Adjust Column Width Using Mouse
- Adjust Column Width Using Menu
- Adjusting The Row Height Using Your Mouse
- Adjusting The Row Height Using Menu
- Hide / Unhide Rows / Columns
- Freezing A Column / A Row
- Split A Worksheet In Panes
Formatting Cells Using Toolbar
- Change Font
- Change Font Size
- Bold
- Italic
- Underline
- Change Font Colour
- Aligning Data In A Cell
- Indent Data In A Cell
- Merge Cells And Centre Data
- Changing A Number To A Percentage
- Increase / Decrease Decimal Points
- Using Format Painter To Copy Formatting
- Format Table Using AutoFormat
CREATING CHARTS
Creating A Chart Using The Chart Wizard
- Use The Chart Wizard
- Move A Chart
- Resize A Chart
- Changing The Chart Type
- Changing The Chart Source Data
- Swap Data Series In The Legend With The X-axis
- Move An Existing Chart To Another Worksheet
Changing Chart Options
- Change Chart Title, X axis And Y axis Title
- Change gridlines
- Changing The Legend Options
- Change The Data Labels
- Add A Data Table
- Deleting A Data Series
- Add A Data Series Using The Mouse
- Delete A Chart
PAGE SETUP AND PRINT
Page Setup
- Insert And Remove Page Break
- Set And Clear Print Area
- Changing The Page Orientation
- Change Scaling
- Changing The Paper Size
- Setting The Page Margins
- Align To Centre Of Page
- Adding A Header / Footer
Previewing and Printing
- Print Preview
- Print Active Sheets
- Print Selected Cells
- Print Chart
- Printing Multiple Copies
|