Course Objective
This courseware is a continuation of the Microsoft Office Excel 2003 Level 1 courseware, in which you were introduced to the basics of worksheets. You will begin with a review of these basic operations and then move to more advanced topics that include working with functions, customizing formatting, using drawing tools, hyperlinks, data tools, databases, cell formatting, drawing objects and customizing charts.
Courseware Outline
About This Courseware
Courseware Conventions
Courseware Objectives and Prerequisites
A Quick Review of Basics
Review Exercise
Working with Functions
Objectives of Section 1
What are Functions?
Using the Correct Syntax for Functions
Inserting Functions
Using Math and Trigonometric Functions
Using Statistical Functions
Working with Financial Functions
Using Logical Functions
Using Date and Time Functions
Using Text Functions
Using Information Functions
Summary of Section 1
Customized Formatting & Drawing Tools
Objectives of Section 2
Aligning the Cell Contents
Using the Format Painter
Hiding/Unhiding Data
Hiding/Unhiding Rows & Columns
Hiding/Unhiding Worksheets
Using Comments
Using Styles
Drawing Objects
Drawing Shapes
Drawing AutoShapes
Moving and Resizing Shapes
Using WordArt
Using Clip Art
Summary of Section 2
Using Internet & Data Tools
Objectives of Section 3
Using Hyperlinks
Inserting Hyperlinks
Modifying and Deleting Hyperlinks
Publishing Worksheets to the Internet
Previewing Web Pages
Saving Worksheets as HTML
Saving Range of Cells as HTML
Using AutoFill
Finding and Replacing Data
Finding Data
Replacing Data
Finding and Replacing Formatting
Go To Special
Using Paste Special
Sorting Data
Using the AutoFilter
Exporting Data as a Text File
Using the Research Tool
Setting Up Research Services
Using Research Services
Changing Excel Options
Summary of Section 3
Working with Lists and Databases
Objectives of Section 4
Using Lists
Creating a List
Modify List Ranges
Defining Names for List Ranges
Understanding Database Concepts and Terminology
Using Database Terminology
Creating a Database
Filtering Information
Using Advanced Filters
Using Comparison Operators
Using Advanced Functions
Creating and Editing Database Functions
Using the Subtotal Function
Using Lookup and Reference
Grouping and Outlining Data
Summarizing Data
Summary of Section 4
Formatting Cells
Objectives of Section 5
Looking at Custom Cell Formats
Using Custom Number Formats
Using Custom Currency Formats
Using Custom Date and Time Formats
Custom Scientific Formats
Using Custom Text Formats
Using Conditional Formatting
Modifying Drawing Objects
Formatting Shapes
Resizing, Reshaping, and Scaling Objects
Shadows and 3-D Effects
Cropping and Rotating Objects
Image Contrast and Brightness
Summary of Section 5
Customizing Charts
Objectives of Section 6
Customizing a Chart
Modifying Chart Options
Formatting the Legend
Formatting an Axis
Formatting Title Text
Formatting Data Series
Formatting Plot and Chart Area
Summary of Section 6
Appendices
Productivity Tools
Glossary of Terms
Index
Microsoft Office Excel 2003 Specialist Exam Objectives
