Keep Going with Excel 2002 for Windows
Product Description
Course Specifications
ISBN#: 978-1-930147-45-4
1-930147-45-7
Item Number: KEX22W
Hours of Instruction based on user's skill-set: 6-8 hours
System Requirements
This course covers features that are in Microsoft Excel 2002. Verify that Microsoft Excel 2002 software is installed on your computer. Please refer to your software installation instructions for specific hardware requirements.
Course Description
Prerequisites
Get Going with Excel 2002 for Windows, or equivalent, is a required prerequisite for this course. A basic understanding of the computer operating system you are using are recommended.
Delivery Method
Instructor-led, self-paced, classroom-delivery learning model with structured hands-on activities.
Benefits
Users who are knowledgeable in the basic concepts of Microsoft Excel 2002 will intermediate and advanced features of the software in this course.
What's New in this Guide
* Task Panes
* Tool Tips for simplifying calculations
* A Function Wizard for finding functions
* Smart Tags to help with automatic formatting
* Using Find and Replace to change formatting
* Enhanced hyperlink navigation
Course Objectives
Customizing Toolbars and Menus
Displaying and hiding toolbars
Customizing toolbars
Customizing menus
Restoring toolbar settings
Working with Files and Templates
Creating a new folder
Opening a workbook from a new folder
Changing the default working folder
Saving a workbook in a different location or with a different file format
Using built-in templates to create workbooks
Using Automated Formatting Features
Using automated formatting features
Using find and replace to copy cell formats
Hiding rows and columns
Splitting rows and columns
Freezing rows and columns
Creating a Custom Template
Creating a custom template
Editing a custom template
Using a custom template to create a workbook
Working with Graphics
Inserting pictures and Clip Art
Formatting pictures and Clip Art
Creating a text box
Drawing basic shapes
Inserting AutoShapes and WordArt
Formatting drawing objects
Using Advanced Functions and Formulas
Using 3-D references
Using the NOW and DATE functions
Using the IF Function
Using the PMT Function
Sharing Excel Data
Adding and editing cell comments
Adding discussion comments to a workbook
Creating and editing a hyperlink
Saving a worksheet as a Web page
Previewing a Web page
ISBN#: 978-1-930147-45-4
1-930147-45-7
Item Number: KEX22W
Hours of Instruction based on user's skill-set: 6-8 hours
System Requirements
This course covers features that are in Microsoft Excel 2002. Verify that Microsoft Excel 2002 software is installed on your computer. Please refer to your software installation instructions for specific hardware requirements.
Course Description
Prerequisites
Get Going with Excel 2002 for Windows, or equivalent, is a required prerequisite for this course. A basic understanding of the computer operating system you are using are recommended.
Delivery Method
Instructor-led, self-paced, classroom-delivery learning model with structured hands-on activities.
Benefits
Users who are knowledgeable in the basic concepts of Microsoft Excel 2002 will intermediate and advanced features of the software in this course.
What's New in this Guide
* Task Panes
* Tool Tips for simplifying calculations
* A Function Wizard for finding functions
* Smart Tags to help with automatic formatting
* Using Find and Replace to change formatting
* Enhanced hyperlink navigation
Course Objectives
Customizing Toolbars and Menus
Displaying and hiding toolbars
Customizing toolbars
Customizing menus
Restoring toolbar settings
Working with Files and Templates
Creating a new folder
Opening a workbook from a new folder
Changing the default working folder
Saving a workbook in a different location or with a different file format
Using built-in templates to create workbooks
Using Automated Formatting Features
Using automated formatting features
Using find and replace to copy cell formats
Hiding rows and columns
Splitting rows and columns
Freezing rows and columns
Creating a Custom Template
Creating a custom template
Editing a custom template
Using a custom template to create a workbook
Working with Graphics
Inserting pictures and Clip Art
Formatting pictures and Clip Art
Creating a text box
Drawing basic shapes
Inserting AutoShapes and WordArt
Formatting drawing objects
Using Advanced Functions and Formulas
Using 3-D references
Using the NOW and DATE functions
Using the IF Function
Using the PMT Function
Sharing Excel Data
Adding and editing cell comments
Adding discussion comments to a workbook
Creating and editing a hyperlink
Saving a worksheet as a Web page
Previewing a Web page
Product Tags
Add Your Tags:
Use spaces to separate tags. Use single quotes (') for phrases.