Excel 2002 Basic

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 Clip
Deleting A Clip
Modifying A Search
The Microsoft Clip Organizer
Using The Mouse To Resize A Clip
Design Gallery Live
Inserting WordArt
Repositioning WordArt
Formatting WordArt
Using AutoShapes
Resizing An AutoShape
Repositioning An AutoShape
Formatting An AutoShape
Replicating An AutoShape
Adding An Arrow Shape
Using Connectors
Adding A Text Box
Formatting Text In A Text Box
Repositioning A Text Box
Replicating A Text Box
Adjusting An Arrow Shape
Changing Text Box Orientation
Adding A Title
Merging And Centering Cells
Inserting A Picture From A File
Formatting A Picture
Reviewing Your Work

Lesson 4: Charts & OLE
Introduction
Lesson Objectives
Opening An Existing Spreadsheet
Selecting A Range Of Data
The F11 Key
Chart Elements
The Legend
The X Axis
The Y Axis
Deleting A Chart
The Chart Wizard
Bar Charts
The Line Chart
Pie Charts
Column Charts
Previewing A Chart Type
Altering The Data Range
Adding A Title To A Chart
Showing Or Hiding Axis Labels
Altering Gridlines
Altering A Chart Legend
Data Labels
The Data Table
Chart Placement
Modifying An Existing Chart
Changing The Chart Area
Fill Effects
Modifying Chart Area Fonts
Increasing Chart Area Font Size
Changing Font Style
Changing The Chart Area Font Color
Deleting A Series
Formatting The Legend
Undoing A Change
Resizing A Chart Component
Formatting The Chart Title
Formatting Data Series
Changing Series Order
Adding A Picture As A Background
Object Linking
Other Chart Types
Copying A Chart To A Spreadsheet
Saving Your Work

Lesson 5: Document Setup, Printing & The Help System
Introduction
Lesson Objectives
Opening A Workbook
Page Setup
Page Orientation
Scaling
Changing Paper Size
Print Quality
Centering A Spreadsheet
Adjusting Margins
Headers And Footers
Creating A Custom Footer
Printing Gridlines
Printing In Black & White
Printing Comments & Cell Errors
Page Order
Print Preview
Print Preview Zoom
Changing Margins In Print Preview
Page Break Preview
Updating Page Setup
The Print Dialog Box
Changing The Number Of Copies
Collate
Print Area
Previewing A Selection
Increasing The Scale
Adjusting Orientation
Clearing The Print Area
The Help System
What's This?
Microsoft Excel Help
The Answer Wizard
Hiding The Office Assistant
The Help Window
The Contents Tab
The Index Tab
The Auto Tile Button
The Hide Button
The Show Button
The Back & Forward Buttons
The Print & Options Buttons

CD

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