|
Provided by: 123-CBT Computer Based Training 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
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
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
-...
