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