Using Microsoft Office 2003

Course Offerings, Descriptions & Cost

 

 

 

 

 

Focused Learning - Excel Pivot Tables – 2 hours

• Understanding Pivot Tables

• Examining a pivot table

• Creating a pivot table by using the Pivot Table Wizard

  • Adding a field to a pivot table

  • Deleting a field from a pivot table

  • Using the pivot table

  • Changing the organization of data in a pivot table

• Subtotal summary functions

• Refreshing Linked data to the pivot table from the source data

• Creating a pivot chart

  • Changing the organization of data in a pivot chart

 

Focused Learning - PowerPoint – Putting Pizzazz in Presentations – 2 hours

Tips and Shortcuts

• Putting Pizzazz in your presentations

  • Design Templates

    • Custom templates

  • Color Schemes

  • Diagram Gallery

  • Interactive Slides

    • Action Buttons

  • Hyperlinks

  • Custom Animation

  • Slide Transitions

  • Using WinZip

  • Presentation “Shows”

  • Package to CD

Focused Learning - Word Mail Merge & WordArt – 2 hours

• Creating a Mail Merge Document

• Creating a data source and removing fields from the header row

  • Adding a new field and renaming an existing one

  • Completing the Data Source 

• Complete a Main Document

  • Inserting Merge field and text into the main document

• Merging the Data Source with the main document

• Sorting and Filtering Merges 

  • Sorting a Data Source 

  • Sorting a data source using query options

  • Selecting Specific Data for the Merge 

  • Filtering Data in Mail Merge 

  • Clearing Query Options 

• Using Outlook Contacts to Create Mailing Labels and letters

• Creating WordArt

• Modify WordArt using the WordArt toolbar

Focused Learning - Outlook 2003 – Tips and Shortcuts – 2 hours

• Mail merge using Outlook

• Contacts

  • v-cards

  • activities w/contacts

  • distribution lists

  • importing contact lists

  • exporting contact lists

• Calendar

  • multiple calendars

  • sharing calendars

  • color-code events/meetings, etc.

  • viewing schedules of invitees

  • rescheduling events/meetings

• Mail

  • color-code incoming mail

  • creating rules for filtering mail

  • Outlook Today (customizing Outlook desktop)

 Focused Learning - Excel Macros - 2 hours

This session is designed for an Excel user who wants to maximize Excel.  We will learn how to create and edit macros.  Visual Basic will be covered since it is the programming language that macros are stored in.  We will also write some routines in the VB editor.  We will test and edit (debug) our code.     We will also learn how to create a Macro Toolbar to make executing macros much faster.  Tips and shortcuts will be used throughout the class.

 

Focused Learning - Charts - 2 hours

This session is designed for an Excel user who wants to go beyond the basics of worksheet setup and design and learn about charting.  We will create and modify all types of charts from column to pie charts.  You will learn how to create a chart using the Chart Wizard and on the fly.  We also link charts with PowerPoint & Word. Everything you want to know about charts will be covered in this class.  Tips and shortcuts will be used throughout the class.

 

Focused Learning - Database Management - 2 hours

This session is designed for an Excel user who wants to go beyond the basics of worksheet setup and design and learn how to use Excel to manage lists of all kinds.  You will learn how to sort and filter the lists.  You will also learn how to create how to manage auto filters and advanced filters using select criteria.  If you work with any type of list this is the Excel class for you.  Tips and shortcuts will be used throughout the class.

 

Focused Learning - Formulas - 2 hours

This session is designed for an Excel user who wants to learn more about formulas.  We will learn how to write If statements and create look up tables.  Also we will learn various editing formulas which will save time and redundancy in entering data.  There are many “Formula Helpers” to be considered when creating and using formulas.  .  Tips and shortcuts will be used throughout the class.

Focused Learning - Access Tables – 2 hours

Establishing Table Relationships

• Identify Table Relationships

• Identify Primary and Foreign Keys in the Relationships Window

• Work with Subdatasheets

Focused Learning - Access Queries – 2 hours

Querying the Database

• Create a Select Query

• Add Criteria to a Query

• Add a Calculated Field to a Query

• Perform a Calculation on a Record Grouping

Focused Learning - Access Reports – 2 hours

Producing Reports

• Create an AutoReport

• Create a Report by Using the Wizard

• Examine a Report in Design View

• Add a Calculated Field to a Report

• Modify the Format Properties of a Control

• AutoFormat a Report  and Adjust the Width of a Report

 

Microsoft® Office Outlook® 2003: Level 1

Course Description

This course is the first in a series of three Microsoft® Office Outlook® courses. It will provide you with the skills you need to start sending and responding to email in Microsoft® Outlook® 2003, as well as maintaining your Calendar, scheduling meetings, and working with tasks and notes.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• identify the components of the Outlook environment and compose and respond to a simple message.

• compose messages.

• use folders to manage mail.

• schedule appointments.

• schedule meetings.

• manage contacts and contact information.

• create and edit tasks.

• create and edit notes.

Course Content

Lesson 1: Getting Started with Outlook

Topic 1A: Log On to Outlook

Topic 1B: The Outlook Environment

Topic 1C: Compose and Send a Simple Message

Topic 1D: Open a Message

Topic 1E: Reply to a Message

Topic 1F: Print a Message

Topic 1G: Delete a Message

Lesson 2: Composing Messages

Topic 2A: Address a Message

Topic 2B: Format a Message

Topic 2C: Check Spelling and Grammar

Topic 2D: Attach a File

Topic 2E: Forward a Message

Lesson 3: Managing Mail

Topic 3A: Open and Save an Attachment

Topic 3B: Flag a Message

Topic 3C: Create a Folder

Topic 3D: Move Messages to a Folder

Topic 3E: Copy Messages to Folders

Topic 3F: Delete a Folder

Lesson 4: Scheduling Appointments

Topic 4A: The Outlook Calendar

Topic 4B: Schedule an Appointment

Topic 4C: Assign a Category to an Appointment

Topic 4D: Update Calendar Entries

Lesson 5: Scheduling Meetings

Topic 5A: Schedule a Meeting

Topic 5B: Reply to a Meeting Request

Topic 5C: Propose a New Meeting Time

Topic 5D: Track Meeting Responses

Topic 5E: Update a Meeting Request

Topic 5F: Cancel a Meeting Request

Topic 5G: Print the Calendar

Lesson 6: Managing Contacts

Topic 6A: Add a Contact

Topic 6B: Sort Contacts

Topic 6C: Find a Contact

Topic 6D: Generate a Map

Topic 6E: Edit a Contact

Topic 6F: Delete a Contact

Topic 6G: Print Contacts

Lesson 7: Managing Tasks

Topic 7A: Create a Task

Topic 7B: Edit a Task

Topic 7C: Update a Task

Lesson 8: Using Notes

Topic 8A: Create a Note

Topic 8B: Edit a Note

Topic 8C: Copy a Note

Appendix A: Microsoft Office Specialist Program

Microsoft® Office Outlook® 2003: Level 2

Course Description

If you have been using Microsoft® Office Outlook® 2003 as a communications tool, then you know how to send a mail message; schedule appointments and meetings; and create contacts, tasks, and notes. This course is the second in a series of three Microsoft Outlook courses. It provides you with the necessary skills to customize your Outlook environment, your calendar, and your mail messages so that they meet your specific needs. You will also learn how to track, share, assign, and quickly locate various Outlook items.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• track work activities using the Outlook Journal.

• customize the calendar by setting various calendar options.

• modify message options.

• make folder information available to other Outlook users.

• assign and track tasks.

• customize the Outlook environment.

• sort, find and color-code items in your mailbox and calendar.

Course Content

Lesson 1: Tracking Work Activities Using the Journal

Topic 1A: Record a Journal Entry Automatically

Topic 1B: Manually Record a Journal Entry

Topic 1C: Modify a Journal Entry

Lesson 2: Setting Calendar Options

Topic 2A: Set Work Days and Times

Topic 2B: Display Other Time Zones

Topic 2C: Set Free/Busy Options

Lesson 3: Setting Message Options

Topic 3A: Modify Message Settings

Topic 3B: Modify Delivery Options

Topic 3C: Modify Message Formats

Topic 3D: Notify Others that You will be Out of the Office

Topic 3E: Create and Modify a Distribution List

Topic 3F: Insert a Hyperlink

Lesson 4: Sharing Folder Information

Topic 4A: Specify Folder Permissions

Topic 4B: Access Another User's Folder

Topic 4C: Delegate Access To Folders

Lesson 5: Managing Tasks

Topic 5A: Assign a Task

Topic 5B: Reply to a Task Request

Topic 5C: Send a Task Update

Topic 5D: Track Assigned Tasks

Lesson 6: Customizing Outlook

Topic 6A: Customize the Toolbar

Topic 6B: Create a New Toolbar

Topic 6C: Customize the Menu

Topic 6D: Create a Folder Home Page

Lesson 7: Locating Outlook Items

Topic 7A: Sort Messages Using Multiple Criteria

Topic 7B: Find Messages

Topic 7C: Find Messages Using Multiple Criteria

Topic 7D: Filter Messages

Topic 7E: Organize Messages

Topic 7F: Manage Junk Email

Appendix A: Using Public Folders

Excel 2003: Level 1 – 6 hours in full or 2 half-days

Course Description

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

Course Objective: You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• create a basic worksheet.

• modify a worksheet.

• perform calculations.

• format a worksheet.

• develop a workbook.

• print the contents of a workbook.

• customize the layout of the Excel window.

Course Content

Lesson 1: Getting Started with Excel

·         Topic 1A: An Overview of Excel

·         Topic 1B: Navigate in Excel

·         Topic 1C: Select Data

·         Topic 1D: Enter Data

·         Topic 1E: Save a Workbook

·         Topic 1F: Obtain Help

Lesson 2: Modifying a Worksheet

·         Topic 2A: Move and Copy Data Between Cells

·         Topic 2B: Fill Cells with Series of Data

·         Topic 2C: Edit Cell Data

·         Topic 2D: Insert and Delete Cells, Columns, and Rows

·         Topic 2E: Find, Replace, and Go To Cell Data

·         Topic 2F: Spell Check a Worksheet

Lesson 3: Performing Calculations

·         Topic 3A: Create Basic Formulas

·         Topic 3B: Calculate with Functions

·         Topic 3C: Copy Formulas and Functions

·         Topic 3D: Create an Absolute Reference

Lesson 4: Formatting a Worksheet

·         Topic 4A: Change Font Size and Type

·         Topic 4B: Add Borders and Color to Cells

·         Topic 4C: Change Column Width and Row Height

·         Topic 4D: Merge Cells

·         Topic 4E: Apply Number Formats

·         Topic 4F: Create a Custom Number Format

·         Topic 4G: Align Cell Contents

·         Topic 4H: Find and Replace Formats

·         Topic 4I: Apply an AutoFormat

·         Topic 4J: Apply Styles

Lesson 5: Developing a Workbook

·         Topic 5A: Format Worksheet Tabs

·         Topic 5B: Reposition Worksheets in a Workbook

·         Topic 5C: Insert and Delete Worksheets

·         Topic 5D: Copy and Paste Worksheets

·         Topic 5E: Copy a Workbook

Lesson 6: Printing Workbook Contents

·         Topic 6A: Set a Print Title

·         Topic 6B: Create a Header and a Footer

·         Topic 6C: Set Page Margins

·         Topic 6D: Change Page Orientation

·         Topic 6E: Insert and Remove Page Breaks

·         Topic 6F: Print a Range

Lesson 7: Customizing Layout

·         Topic 7A: Split a Worksheet

·         Topic 7B: Arrange Worksheets

·         Topic 7C: Freeze and Unfreeze Rows and Columns

·         Topic 7D: Hide and Unhide Worksheets

 

 Excel 2003: Level 2 - 6 hours in full or 2 half-days

Course Description

In Microsoft® Office Excel 2003: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003. Students can obtain this level of skill by taking the following Element K course:

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• create and apply templates.

• create and modify charts.

• work with graphic objects.

• calculate with advanced formulas.

• sort and filter data.

• use Excel with the Web.

Course Content

Lesson 1: Creating and Applying Templates

·         Topic 1A: Create a Workbook from a Template

·         Topic 1B: Create a Custom Template

·         Topic 1C: Working with Comments

·         Topic 1D: Create a Hyperlink

·         Topic 1E: Use Web-based Research Tools

Lesson 2: Creating and Modifying Charts

·         Topic 2A: Create a Chart

·         Topic 2B: Format Chart Items

·         Topic 2C: Change the Chart Type

·         Topic 2D: Create a Diagram

·         Lesson 3: Working with Graphic Objects

·         Topic 3A: Insert Graphics

·         Topic 3B: Create AutoShapes

·         Topic 3C: Format Graphic Objects

·         Topic 3D: Change the Order of Graphic Objects

·         Topic 3E: Group Graphic Objects

·         Topic 3F: Move, Copy, and Resize Graphic Objects

Lesson 4: Calculating with Advanced Formulas

·         Topic 4A: Create and Apply a Name for a Range of Cells

·         Topic 4B: Calculate Across Worksheets

·         Topic 4C: Calculate with Date and Time Functions

·         Topic 4D: Calculate with Financial Functions

·         Topic 4E: Calculate with Statistical Functions

·         Topic 4F: Calculate with Lookup and Reference Functions

·         Topic 4G: Calculate with Logical Functions

Lesson 5: Sorting and Filtering Data

·         Topic 5A: Sort Data Lists

·         Topic 5B: Filter Data Lists

·         Topic 5C: Create and Apply Advanced Filters

·         Topic 5D: Calculate with Database Functions

·         Topic 5E: Add Subtotals to a Worksheet

Lesson 6: Using Excel with the Web

·         Topic 6A: Export Excel Data

·         Topic 6B: Publish a Worksheet to the Web

·         Topic 6C: Import Data from the Web

 

 

Excel 2003: Level 3 – 6 hours in full or 2 half-days

Course Description

You have used Microsoft® Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things.

Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Prerequisites: To ensure your success, we recommend you first take the following Element K courses or have equivalent knowledge:

• Microsoft® Office Excel 2003: Level 1

• Microsoft® Office Excel 2003: Level 2

Performance-based Objectives

Upon successful completion of this course, students will be able to:

• Customize workbooks.

• Collaborate with others using workbooks.

• Audit worksheets.

• Analyze data.

• Work with multiple workbooks.

• Import and export data.

• Structure workbooks with XML.

Course Content

Lesson 1: Streamlining Workflow

·         Topic 1A: Create a Macro

·         Topic 1B: Edit a Macro

·         Topic 1C: Customize Access to Excel Commands

·         Topic 1D: Apply Conditional Formatting

·         Topic 1E: Add Data Validation Criteria

·         Topic 1F: Update a Workbook's Properties

·         Topic 1G: Modify Excel's Default Settings

Lesson 2: Collaborating with Others

·         Topic 2A: Protect Files

·         Topic 2B: Share a Workbook

·         Topic 2C: Set Revision Tracking

·         Topic 2D: Review Tracked Revisions

·         Topic 2E: Merge Workbooks

·