Excel 2002 Advanced

Training Provided by 123-CBT Computer Based Training Lesson 1: Sorting & Filtering Data Introduction Lesson Objectives Opening Excel Importing Data From A Web Page The New Web Query Dialog Box Selecting A Table Navigating Pages Web Query Options Saving A Web Query Placing Data The External Data Toolbar Editing A Query Data Range Properties Refreshing Data Running A Saved Query Full Screen View Sorting Data Then By Sorting Using AutoFilter Using Custom AutoFilter The Data Form Dialog Box Changing A Record Deleting A Record Disabling AutoFilter Removing Filters Advanced Filters Saving Your Work Lesson 2: Scenarios & Security Introduction Lesson Objectives Saving A Workbook As A Template Accessing Saved Templates Saving A Template As A Workbook Locking & Unlocking Cells Hiding Proprietary Formulas Protecting A Worksheet Selecting Permissions Verifying Protection Unprotecting A Sheet Hiding Cell Contents Displaying The Contents Of Hidden Cells Password Protecting A Sheet Removing Password Protection Protecting A Workbook Controlling Access To A Workbook The Scenario Manager Creating Scenarios Viewing Scenarios Creating A Scenario Summary Report Merging Scenarios Opening A Text File The Text Import Wizard Dialog Box Using AutoFit Opening Access Databases In Excel Lesson 3: Functions & Data Analysis Introduction Lesson Objectives About Cell References Tracing Precedents Tracing Dependents Finding Errors Getting Help With Errors Viewing Calculation Steps Error Checking Options Correcting An Error Removing Trace Arrows Conditional Formatting Adding A Second Condition Using Data Validation Specifying Settings Creating An Input Message Error Alerts Verifying Validation Checking & Reviewing Data Creating A PivotTable Report The PivotTable Toolbar PivotTable Options Applying An AutoFormat Modifying A PivotTable Report Making A PivotTable Report Available On The Web Lesson 4: Workgroup Related Functions Introduction Lesson Objectives Sharing A Workbook Mailing A Workbook As An Attachment Mailing A Worksheet As The Body Of A Message Routing A Workbook Tracking Changes Highlighting Changes As You Work Creating A History Worksheet Viewing Changes Made By Other Users Viewing History By Range Resolving Conflicts Preparing Multiple Copies Of A Workbook To Merge Merging All Copies Of The Same Workbook Removing A Workbook From Shared Use Protecting & Sharing A Workbook Protecting & Sharing A Workbook Personal View & Print Settings Of Shared Workbooks Removing Protection From A Shared Workbook Removing Password Protection Lesson 5: Variable Data & Problem Solving Introduction Lesson Objectives Data Tables One Variable Data Tables Specifying Input Cells Identifying A Reference Cell Two Variable Data Tables Adding Formulas To A Two Variable Data Table Identifying Reference Cells Scenarios Creating A Summary Report Creating A PivotTable Report Displaying The PivotTable Toolbar Creating A PivotTable Chart Working With A PivotTable Chart Goal Seek Entering Formula References In The Set Cell Box Entering A Target Result Identifying A Changing Cell Practicing Goal Seek Installing Solver Setting The Solver Target Cell Box Limiting The Target Cell To A Specific Value Using The Guess Function For Changing Cells Adding Constraints Entering A Constraint Value Adding Multiple Constraints Creating A Report Using Solve

Excel 2002 Advanced

About The Training Provider: 123-CBT Computer Based Training

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

• Excel 2002 Basic
• Excel 2002 Intermediate
• Excel 2002 Set of 3