|
Provided by: 123-CBT Computer Based Training Excel 2002 Basic |
 |
Training
Provided by 123-CBT Computer Based Training
Lesson 1: The Excel 2002 Interface
Introduction
Lesson Objectives
Opening Excel
About Workbooks
The Title Bar
Menu Bar Overview
Standard Toolbar Overview
Formatting Toolbar Overview
Displaying Other Toolbars
Repositioning A Toolbar
Docking A Toolbar
Hiding A Toolbar
Overview Of Task Panes
Switching Between Task Panes
Hiding The Task Pane
Showing The Task Pane
The Formula Bar
The Insert Function Button
The Name Box
The Worksheet Area
Column Headings
Row Headings
The Select All Button
The Vertical Scroll Bar
The Horizontal Scroll Bar
Sheet Tabs
Inserting A Worksheet
The Insert Dialog Box
Renaming A Worksheet
Changing Sheet Tab Order
Deleting A Worksheet
The Tab Scrolling Buttons
The Status Bar
Overview Of Menus
The File Menu
The Edit Menu
The View Menu
The Insert Menu
The Format Menu
The Tools Menu
The Data Menu
The Window Menu
The Help Menu
The Ask A Question List Box
The New Blank Document Button
The Open Button
The Save Button
The E-mail Button
The Search Button
The Basic Search Task Pane
The Print Button
The Print Preview Button
The Spelling Button
The Cut, Copy & Paste Buttons
The Format Painter Button
The Undo & Redo Buttons
The Insert Hyperlink Button
The AutoSum Button
The Sort Ascending & Sort Descending Buttons
The Chart Wizard Button
The Drawing Button
The Zoom List Box
The MS Excel Help Button
The Toolbar Options Button
Selecting A Cell
Entering Data
The Enter And Cancel Buttons
The Font List Box
The Font Size List Box
The Bold Button
The Italic Button
The Underline Button
The Align Left Button
The Center Button
The Align Right Button
The Merge And Center Button
The Currency Style Button
The Percent Style Button
The Comma Style Button
The Increase Decimal Button
The Decrease Decimal Button
The Outside Border Button
The Fill Color Button
The Font Color Button
Accessing Hidden Buttons
The Increase Indent Button
Undoing The Last Action
Undoing Multiple Actions Simultaneously
Displaying The Office Assistant
Hiding The Office Assistant
Closing Excel
Lesson 2: Working With Data
Introduction
Lesson Objectives
Opening Excel
Preparing To Work
Renaming A Worksheet
Color Coding Sheet Tabs
Entering Text
Moving The Cell Marker
Changing Orientation Of Text
The Undo Command
Rotating Text
Moving The Cell Marker
Entering Numerical Values
The Name Box
Resizing A Column
Selecting Adjacent Cells
Selecting Non Adjacent Cells
Formatting Multiple Cells
Centering Text
Drawing A Border
Erasing A Border
Applying A Border To Multiple Cells
Applying A Fill
Deselecting Cells
Inspecting Changes
Inserting A Row
The Insert Options Button
Inserting A Column
Entering Formulas In A Worksheet
The AutoFill Handle
The AutoFill Options Button
Entering A Function
Correcting Errors
Formatting Decimal Places
The Number Tab
Adding More Rows
Shortcut Menus
Revising A Formula
Sorting
Inserting A Comment
Hiding A Comment
Deleting A Comment
The If Function
The Logical Test
Using Absolute Cell References
Reviewing Results
Saving A Workbook
The Save As Dialog Box
Lesson 3: Objects & Formatting
Introduction
Lesson Objectives
The New Workbook Task Pane
The Recently Used File List
Changing The Zoom Percentage
Selecting Non Adjacent Cells
Changing Font Color
Accessing The Clip Art Task Pane
Searching For Clip Art
Search Options
Viewing Results
Inserting A Cli
Introduction
Lesson Objectives
Opening Excel
About Workbooks
The Title Bar
Menu Bar Overview
Standard Toolbar Overview
Formatting Toolbar Overview
Displaying Other Toolbars
Repositioning A Toolbar
Docking A Toolbar
Hiding A Toolbar
Overview Of Task Panes
Switching Between Task Panes
Hiding The Task Pane
Showing The Task Pane
The Formula Bar
The Insert Function Button
The Name Box
The Worksheet Area
Column Headings
Row Headings
The Select All Button
The Vertical Scroll Bar
The Horizontal Scroll Bar
Sheet Tabs
Inserting A Worksheet
The Insert Dialog Box
Renaming A Worksheet
Changing Sheet Tab Order
Deleting A Worksheet
The Tab Scrolling Buttons
The Status Bar
Overview Of Menus
The File Menu
The Edit Menu
The View Menu
The Insert Menu
The Format Menu
The Tools Menu
The Data Menu
The Window Menu
The Help Menu
The Ask A Question List Box
The New Blank Document Button
The Open Button
The Save Button
The E-mail Button
The Search Button
The Basic Search Task Pane
The Print Button
The Print Preview Button
The Spelling Button
The Cut, Copy & Paste Buttons
The Format Painter Button
The Undo & Redo Buttons
The Insert Hyperlink Button
The AutoSum Button
The Sort Ascending & Sort Descending Buttons
The Chart Wizard Button
The Drawing Button
The Zoom List Box
The MS Excel Help Button
The Toolbar Options Button
Selecting A Cell
Entering Data
The Enter And Cancel Buttons
The Font List Box
The Font Size List Box
The Bold Button
The Italic Button
The Underline Button
The Align Left Button
The Center Button
The Align Right Button
The Merge And Center Button
The Currency Style Button
The Percent Style Button
The Comma Style Button
The Increase Decimal Button
The Decrease Decimal Button
The Outside Border Button
The Fill Color Button
The Font Color Button
Accessing Hidden Buttons
The Increase Indent Button
Undoing The Last Action
Undoing Multiple Actions Simultaneously
Displaying The Office Assistant
Hiding The Office Assistant
Closing Excel
Lesson 2: Working With Data
Introduction
Lesson Objectives
Opening Excel
Preparing To Work
Renaming A Worksheet
Color Coding Sheet Tabs
Entering Text
Moving The Cell Marker
Changing Orientation Of Text
The Undo Command
Rotating Text
Moving The Cell Marker
Entering Numerical Values
The Name Box
Resizing A Column
Selecting Adjacent Cells
Selecting Non Adjacent Cells
Formatting Multiple Cells
Centering Text
Drawing A Border
Erasing A Border
Applying A Border To Multiple Cells
Applying A Fill
Deselecting Cells
Inspecting Changes
Inserting A Row
The Insert Options Button
Inserting A Column
Entering Formulas In A Worksheet
The AutoFill Handle
The AutoFill Options Button
Entering A Function
Correcting Errors
Formatting Decimal Places
The Number Tab
Adding More Rows
Shortcut Menus
Revising A Formula
Sorting
Inserting A Comment
Hiding A Comment
Deleting A Comment
The If Function
The Logical Test
Using Absolute Cell References
Reviewing Results
Saving A Workbook
The Save As Dialog Box
Lesson 3: Objects & Formatting
Introduction
Lesson Objectives
The New Workbook Task Pane
The Recently Used File List
Changing The Zoom Percentage
Selecting Non Adjacent Cells
Changing Font Color
Accessing The Clip Art Task Pane
Searching For Clip Art
Search Options
Viewing Results
Inserting A Cli
|
|
||||||||
Excel 2002 Basic
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
