Excel 2003, Beginner's Course
(Session 1)
Parts of An Excel Screen
Title Bar
- Application close button
- Minimize, Maximize / Restore button
Menu Bar
- Ask a Question Box
- Window close button
Toolbars
Name Box, Formula Bar
Work Area
- Select All button
- Active cell indicator
- Column, Row headings
- Split Boxes
- Scrollbars
Task Pane
Tab Scroll buttons, Sheet Tabs
Status Bar
- Indicators: AutoCalculate, etc
Create, Open and Save Workbook
Create
- Creating a new (empty) workbook
- From existing workbook
- Templates on Office online
- Templates on my computer
Open
- Opens the file normally
- Open Read-Only
- Open as Copy
- Open and Repair
Saving and closing workbooks
- Save normal
- file-saving options
- Save As
- Setting the workbook summary information
(Session 2)
Entering and Editing Worksheet data
Type of Data
- Numeric values
- Text
- Formulas
Selecting a range of input cells before entering data
List ranges
Selecting complete rows and columns
Selecting noncontiguous ranges
Selecting multi-sheet ranges (Group Mode)
Using Ctrl+Enter to place information into multiple cells simultaneously
Automatically moving the cell pointer after entering data
Using AutoFill to enter a series of values
Using AutoComplete to automate data entry
Forcing text to appear on a newline within a cell
Using AutoCorrect for shorthand data entry
Entering numbers with fractions
Simplifying data entry by using a form
Using the Office clipboard to paste
Copying by using drag-and-drop
Using Smart Tags when Inserting and Pasting
Copying a range to other sheets
Workshop
|