Course Objective
The main objective of this courseware is to introduce you to the advanced features of Excel. The purpose of this book is to demonstrate features that can increase productivity in using many of the built-in features to format, analyze, calculate, or protect your worksheets. You will also look at how to set up worksheet data on web pages as well as how to use data from other programs within Excel.
Courseware Outline
About This Courseware
Courseware Conventions
Courseware Objectives and Prerequisites
A Quick Review of Basics
Review Exercise
Templates & Validating Data
Objectives of Section 1
Using Built-In Templates
User-Defined Templates
Creating a Template
Using User-Defined Templates
Editing Templates
Deleting Templates
Alternate Location for Storing Templates
Validating Data
Using Pick Lists
Circling Invalid Data
Summary of Section 1
Managing Your Workbooks
Objectives of Section 2
Auditing a Worksheet
Error Checking Tool
Manual Checking and Displaying Formulas
Correcting Worksheet Errors
Tracing Formula Errors
Tracing Circular References
Using Cell Watch
Evaluate Formulas
Protecting Your Workbook
Using Passwords
Worksheet Protection
Workbook Protection
Protecting Files
Using AutoRecover
Summary of Section 2
Using Analysis Tools
Objectives of Section 3
What-If Analysis
Using the Goal Seeking Tool
Using the Solver
Using a Data Table
Single Variable Data Tables
Two-variable Data Table
Multiple Formulas in a Data Table
Using Trendlines
Creating a Trendline
Looking at Trendline Options
Using PivotTables
Creating a PivotTable
Creating a PivotChart
Modifying Field Positions
Modifying Data Field Options
Analysis ToolPak
Working with Scenarios
Creating Scenarios
Using Scenarios
Creating Scenario Summaries
Summary of Section 3
Collaborating with Others
Objectives of Section 4
Consolidating Data
Looking at Workgroup Functions
Creating a Shared Workbook
Resolving Shared Workbook Conflicts
Tracking Changes
Showing History of Changes
Removing Shared Use of Workbooks
Merging Workbooks
Linking Worksheets & Workbooks
Creating Linked Workbooks
Managing the Links
Removing the Links
Changing and Displaying Workbook Properties
Summary of Section 4
Importing and Exporting Data
Objectives of Section 5
Save as Web Page
Importing Data
Importing Text Files
Importing from Other Applications
Importing Using a Web Query
Importing from a Web Page
Using XML
Managing Elements and Attributes
Changing XML View Options
Managing XML Maps
Exporting Data Using an XML Maps
Summary of Section 5
Using Macros & Custom Forms
Objectives of Section 6
Customizing Toolbars
Adding and Deleting Toolbar Buttons
Modifying Toolbar Buttons
Creating a Custom Toolbar or Menu
Using Macros in Excel
Creating and Using a Macro
Opening a Workbook Containing a Macro
Editing a Macro
Adding Macros to Toolbars
Using Digital Certificates
Creating a Digital Certificate
Apply Digital Certificate to Macro
Applying a Digital Certificate to a Workbook
Removing a Digital Certificate
Creating Forms with Controls
Adding Controls to a Worksheet
Using Spin Buttons or Scroll Bars
Using Check Boxes or Option Buttons
Using List Boxes or Combo Boxes
Changing Excel Options
Summary of Section 6
Appendices
Productivity Tools
Glossary of Terms
Index
Microsoft Office Excel 2003 Specialist Exam Objectives
