|
Provided by: 123-CBT Computer Based Training Excel 2002 Intermediate |
 |
Training
Provided by 123-CBT Computer Based Training
Lesson 1: The Document Window
Introduction
Lesson Objectives
Opening Excel
Opening An Existing Workbook
Splitting A Worksheet Vertically
Splitting A Worksheet Horizontally
Removing Splits
Freezing Panes
Unfreezing Panes
The Watch Window
Adding A Watch
Deleting A Watch
Hiding A Column
Displaying A Hidden Column
Hiding Rows
Manually Hiding Rows And Columns
Inserting A Column
The Insert Options Button
Deleting A Column
Inserting Multiple Columns
Inserting A Row
The Auto Fill Feature
Auto Fill Options
About Cell & Range References
The Average Function
The Range Finder
Formatting Numbers
The Go To Dialog Box
Naming A Range Of Cells
Inserting A Range of Cells
Defining A Name
Selecting A Named Range
Deleting A Range
Saving Your Work
Lesson 2: Functions, Formulas, & Charts
Introduction
Lesson Objectives
Opening A Workbook
The Function Wizard
Searching For A Function
Categories Of Functions
Getting Help On A Function
Copying An Example To A Worksheet
The AVERAGE Function
Specifying Function Arguments
Redefining A Named Range
Absolute Cell References
The Median Function
Using A Named Range As An Argument
Manually Entering A Function
Argument Tooltips
Viewing Formula & Results
The Formula Auditing Toolbar
Additional Help On Functions
Formatting A Range Of Cells
Creating A Pie Chart
Specifying A Data Range
Entering Titles
Positioning The Legend
Selecting Data Labels
Specifying A Location For A Chart
Formatting Data Labels
Repositioning Chart Components
Formatting The Chart Area
Saving Your Work
Lesson 3: Outlines, Comments & Hyperlinks
Introduction
Opening A Workbook
About Outlines
The Auto Outline Feature
Showing & Hiding Details
Previewing An Outline
Outline & Style Settings
Clearing An Outline
Opening Multiple Workbooks Simultaneously
Tiling Workbooks
Adding A Comment
Hiding A Comment
Using AutoSum
Inserting Multiple Sheets
Rearranging Sheet Tabs
Copying Data To Multiple Worksheets
Entering Data On Multiple Sheets
Hyperlinking To Files
Specifying An Exact Location
Verifying A Link
Hyperlinking To A Web Address
Adding A ScreenTip
Lesson 4: More Functions
Introduction
Lesson Objectives
Opening A Workbook
Utilizing A Formula To Reference A Cell
Absolute Cell References
Mixed References
Utilizing Formulas For Data Entry
More About AutoSum
Tracing An Error
Entering A Formula Manually
Creating An IF Statement
Using Goal Seek
Using VLOOKUP
Applying The Trend Function
Calculating A Percentage
Quick Calculations
Saving Your Work
Lesson 5: Protection & Customization
Introduction
Lesson Objectives
Opening A Workbook
About Protection
Locking And Unlocking Cells
Hiding Formulas
Protecting A Worksheet
Verifying Protection
Unprotecting A Sheet
Working With Multiple Workbooks
Arranging Windows
Linking Cells
Removing An Absolute Reference
Verifying Links
The Options Dialog Box
Changing The AutoRecover Interval
The Customize Dialog Box
Adding Commands To Toolbars
Viewing Add-Ins
The AutoFormat Feature
AutoFormat Options
Checking For Spelling Errors
Changing The Orientation Of Text
Introduction
Lesson Objectives
Opening Excel
Opening An Existing Workbook
Splitting A Worksheet Vertically
Splitting A Worksheet Horizontally
Removing Splits
Freezing Panes
Unfreezing Panes
The Watch Window
Adding A Watch
Deleting A Watch
Hiding A Column
Displaying A Hidden Column
Hiding Rows
Manually Hiding Rows And Columns
Inserting A Column
The Insert Options Button
Deleting A Column
Inserting Multiple Columns
Inserting A Row
The Auto Fill Feature
Auto Fill Options
About Cell & Range References
The Average Function
The Range Finder
Formatting Numbers
The Go To Dialog Box
Naming A Range Of Cells
Inserting A Range of Cells
Defining A Name
Selecting A Named Range
Deleting A Range
Saving Your Work
Lesson 2: Functions, Formulas, & Charts
Introduction
Lesson Objectives
Opening A Workbook
The Function Wizard
Searching For A Function
Categories Of Functions
Getting Help On A Function
Copying An Example To A Worksheet
The AVERAGE Function
Specifying Function Arguments
Redefining A Named Range
Absolute Cell References
The Median Function
Using A Named Range As An Argument
Manually Entering A Function
Argument Tooltips
Viewing Formula & Results
The Formula Auditing Toolbar
Additional Help On Functions
Formatting A Range Of Cells
Creating A Pie Chart
Specifying A Data Range
Entering Titles
Positioning The Legend
Selecting Data Labels
Specifying A Location For A Chart
Formatting Data Labels
Repositioning Chart Components
Formatting The Chart Area
Saving Your Work
Lesson 3: Outlines, Comments & Hyperlinks
Introduction
Opening A Workbook
About Outlines
The Auto Outline Feature
Showing & Hiding Details
Previewing An Outline
Outline & Style Settings
Clearing An Outline
Opening Multiple Workbooks Simultaneously
Tiling Workbooks
Adding A Comment
Hiding A Comment
Using AutoSum
Inserting Multiple Sheets
Rearranging Sheet Tabs
Copying Data To Multiple Worksheets
Entering Data On Multiple Sheets
Hyperlinking To Files
Specifying An Exact Location
Verifying A Link
Hyperlinking To A Web Address
Adding A ScreenTip
Lesson 4: More Functions
Introduction
Lesson Objectives
Opening A Workbook
Utilizing A Formula To Reference A Cell
Absolute Cell References
Mixed References
Utilizing Formulas For Data Entry
More About AutoSum
Tracing An Error
Entering A Formula Manually
Creating An IF Statement
Using Goal Seek
Using VLOOKUP
Applying The Trend Function
Calculating A Percentage
Quick Calculations
Saving Your Work
Lesson 5: Protection & Customization
Introduction
Lesson Objectives
Opening A Workbook
About Protection
Locking And Unlocking Cells
Hiding Formulas
Protecting A Worksheet
Verifying Protection
Unprotecting A Sheet
Working With Multiple Workbooks
Arranging Windows
Linking Cells
Removing An Absolute Reference
Verifying Links
The Options Dialog Box
Changing The AutoRecover Interval
The Customize Dialog Box
Adding Commands To Toolbars
Viewing Add-Ins
The AutoFormat Feature
AutoFormat Options
Checking For Spelling Errors
Changing The Orientation Of Text
|
|
||||||||
Excel 2002 Intermediate
--
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
- Dreamweaver MX
-...
