|
|
|
|
Microsoft Excel Beginning
Course Outline
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 A Template
Becoming Familiar With The Excel 2003 Screen
How To Use The Menu
How To Show Or Hide Toolbars
How To Move A Toolbar Or The Menu Bar
How To Use Buttons On A Toolbar
How To Access The Shortcut Menu The Mouse
How To Use The Shortcut Keys
Getting Help And Maintenance
How To Search Help
How To Use The Help Contents
How To Use Microsoft Office Online
How To Type A Question To Get Help
How To Use The Office Assistant
How To 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 The Keyboard
How To Move Around Using The Go To Command
How To Move To A Cell Using The Name Box
How To Move Within A Selected Range
How To Move To Other Sheets Within A Workbook
Selecting A Range Of Cells In Workbook
How To Select A Single Cell
How To Select A Range of Cells
How To Select A Range Of Cells Using
How To Select An 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 The Contents Of A Cell
How To Edit Text In A Cell Using The Formula Bar
How To Replace The Contents Of A Cell
How To Delete The Contents Of A Cell
How To Undo And Redo Changes
How To Enter A Number As A Value In A Cell
How To Enter A Number As A Label In 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 A Sequence Of Numbers
How To Customize AutoFill
How To Use A 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 On 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 A Simple Formula
How To Enter A Formula Using The Keyboard
How To Enter A Cell or A Range Reference Using The Mouse
How To Use AutoSum To Calculate Totals
How To Use Relative References
How To Use Absolute References
Using Simple Functions
How To Enter A Function Directly
How To Insert A Function
Using AutoCalculate And Labels
How To Use AutoCalculate To Do A Calculation Without Using A Formula
How To Accept Labels In Formulas
How To Use A Label (Natural Language) In A Formula
MANAGING WORKSHEETS AND WORKBOOK INFORMATION
Managing Worksheet Information
How To Move Information Using Cut And Paste
How To Drag And Drop Information
How To Copy And Paste Information
How To Use Paste Options
How To Drag And Drop To Copy Information
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 A New Worksheet
How To Rearrange Worksheets
How To Copy Worksheet
How To Hide And Unhide A Worksheet
How To Hide And Unhide A Workbook
How To Format A Worksheet Tab
How To Add A Background To A Worksheet
How To Delete A Worksheet
| |
|
|
|