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

Excel 2002 Intermediate

About The Training Provider: 123-CBT Computer Based Training

More Microsoft Excel 2002 XP Training from 123-CBT Computer Based Training

• Excel 2002 Advanced
• Excel 2002 Basic
• Excel 2002 Set of 3