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