Customized Office Skills Training (C

Customized Office Skills Training (C.O.S.T)

Curriculum

MS Word – Introduction

Word Basics

Introduction to word processing
Identifying parts of the opening screen
Understanding document views
Text entry and word wrap
Navigating through a document
Saving a document
Locating and opening an existing document
Zoom view
Full screen view
Previewing a document
Selecting a page orientation
Printing a document

Basic Editing

Selecting text
Viewing hidden characters
Using the backspace and delete keys
Using overtype
Using undo and redo
Moving and copying text
Using find and replace
Using the word count command

Helpful Word Features

Automatic features
AutoCorrect
AutoFormat as you type
AutoText
AutoComplete
Automatic spell checking
Automatic grammar checking
Using the spelling and grammar checker
Inserting the date and time
Using the thesaurus
Inserting symbols

Formatting Text

Changing the font, style, size, and color
Changing underline style and color
Changing font effects
Highlighting
Copying format and style
Applying styles
Character spacing

Formatting Paragraphs and Documents

Set the margins of a document
Align text
Adjust indents and line spacing
Change vertical alignment
Set and modify tabs
Apply bullet and numbering formats
Create and outline numbered list
Organize a document in outline view

Working with Graphics

Format text into columns
Add borders and shading
Insert and scale clip art
Wrap text around graphics
Draw Object
Select, resize, cut, copy, and paste objects
Change the appearance of objects
Add text to drawings
Create and modify diagrams

Working with Documents

Insert page breaks
Insert headers and footers
Show and hide white space
Split windows
Create a section with formatting that differs from other sections
Use the research tool
Use AutoSummarize
Insert and format tables
Convert text into tables
Sort text

Increasing Efficiency Using Word

Create and use templates
Use wizards
Use mail merge
Create and print envelopes and labels
Send documents by e-mail
Insert, view, and edit comments
Track changes
Compare and merge documents
Save a document as a Web page and apply a theme
Insert hyperlinks in documents and Web pages

MS Word – Advanced

Review of MS Word Introduction

Review of basic Word features

Integrating Word with Other Programs

Exploring integration methods
Embedding an Excel worksheet
Linking an Excel chart
Embedding a PowerPoint slide
Inserting a Word file
Importing a table from Access
Managing document links
Merging with an Access data source

Exploring Advanced Graphics

Inserting drop caps
Editing clip art
Working with the drawing canvas
Using layering options
Aligning, distribution, and rotating graphics
Using advanced positioning options
Adjusting shadow and 3-D settings
Inserting a watermark and page border

Building Forms

Constructing a form template
Adding and modifying text form fields
Adding drop-down and check box form fields
Using calculations in a form
Adding help to a form
Inserting form controls
Formatting and protecting forms
Filling in a form as a user

Working with Charts and Diagrams

Defining charts and diagrams
Creating a column chart
Editing a chart
Creating a pie chart
Importing spreadsheet data into a chart
Creating a diagram
Creating an organizational chart
Modifying an organizational chart

Collaborating with Workgroups

Exploring collaboration options
Including comments in a document
Tracking changes
Accepting and rejecting changes
Creating document versions
Comparing documents and merging changes
Using find and replace options
Protecting documents

Customizing Word

Planning a macro
Creating a macro
Running a macro
Editing a macro in Visual Basic
Renaming, deleting, and copying macros
Creating a custom toolbar
Customizing menus
Modifying options
Summarizing content with automated tools

MS Excel – Introduction

Excel Basics

What is Excel
Starting Excel
Opening and existing orkbook
Moving the highlight in a worksheet
Selecting a group of cells
Entering data in a cell
Changing data in a cell
Searching for data
Using zoom view
Saving a workbook
Printing a worksheet

Changing the Appearance of a Worksheet

Changing the size of a cell
Positioning text within a cell
Changing cell appearance
Cell formats

Organizing the Worksheet

Copying data
Moving data
Inserting and deleting rows and columns
Freezing titles
Splitting workbook screens
Printing options
Checking spelling on a worksheet

Worksheet Formulas

What are formulas
Structure of a formula
Editing formulas
Relative, absolute, and mixed cell references
Creating formulas quickly
Previewing a calculation
Formula helpers

Function Formulas

Parts of function formulas
Types of functions

Making the Worksheet Useful

Sorting data
AutoFilter
Hiding columns and rows
Using the drawing tools
Adding a picture to a worksheet
Using templates
Inserting hyperlinks
Saving workbooks in a different format
Viewing and editing comments
Using the research tool

Working with Multiple Worksheets

Worksheets in a workbook
Identifying worksheets
Positioning worksheets in a workbook
Consolidating workbook data
Printing a workbook
Working with multiple workbooks

Worksheet Charts

What is a worksheet chart
Types of worksheet charts
Creating a chart from worksheet data
Creating an embedded chart
Creating other types of charts

MS Excel – Advanced

Review of MS Excel Introduction

Review of basic Excel features

Using What-if Analysis

Defining a what-if analysis
Tracking a What-if analysis with Scenario Manager
Generating a scenario summary
Projecting figures using a data table
Creating a two-input data table
Using goal seek
Setting up a complex what-if analysis with solver
Running solver and generating an answer report

Analyzing Data with Pivot Tables

Planning and designing a pivot table report
Creating a pivot table report
Changing the summary function of a pivot table report
Analyzing three-dimensional data
Updating a pivot table report
Changing the structure and format of a pivot table report
Creating a pivot chart report

Exchanging Data with Other Programs

Planning a data exchange
Importing a text file
Importing a database table
Inserting a graphic file in a worksheet
Embedding a worksheet
Linking a worksheet to another program
Embedding an Excel chart into a PowerPoint slide
Importing a list into an Access table

Customizing Excel and Advanced Worksheet Management

Finding files
Auditing a worksheet
Outlining a worksheet
Controlling worksheet calculations
Creating custom autofill lists
Customizing Excel
Adding a comment to a cell
Creating a template

MS PowerPoint

Getting Started with PowerPoint

Defining presentation software
Starting PowerPoint
Viewing the PowerPoint window
Using the AutoContent wizard
Viewing a presentation
Saving a presentation
Getting help and researching information
Printing and closing the file and exiting PowerPoint

Creating a Presentation

Planning an effective presentation
Entering slide text
Creating a new slide
Entering text in the outline tab
Adding slide headers and footers
Choosing a look for a presentation
Checking spelling in a presentation
Evaluating a presentation

Modifying a Presentation

Opening an existing presentation
Drawing and modifying an object
Editing drawn objects
Aligning and grouping objects
Adding and arranging text
Formatting text
Importing text from MS Word
Customizing the color scheme and background

Enhancing a Presentation

Inserting clip art
Inserting, cropping, and scaling a picture
Embedding a chart
Entering and editing data in the datasheet
Formatting a chart
Creating tables in PowerPoint
Using slide show commands
Setting slide show timings and transitions
Setting slide animation effects

Customizing a Presentation

Understanding PowerPoint masters
Formatting master text
Changing master text indents
Adjusting text objects
Using advanced drawing tools
Using advanced formatting tools
Insert and format WordArt
Creating a template

Enhancing Charts

Inserting data from a file into a datasheet
Formatting a datasheet
Changing the chart type
Changing chart options
Working with chart elements
Animating charts and adding sounds
Embedding an organization chart
Modifying an organization chart

Working with Embedded and Linked Objects and Hyperlinks

Embedding a picture
Embedding an Excel chart
Linking an Excel worksheet
Updating a linked Excel worksheet
Inserting an animated GIF file
Inserting a sound
Inserting a hyperlink
Creating a photo album

Using Advanced Features

Sending a presentation for review
Combining reviewed presentations
Setting up a slide show
Creating a custom show
Rehearsing slide timings
Publishing a presentation for the web
Packaging a presentation
Broadcasting a presentation

MS Access

Introduction to Access

Introduction to database concepts
Opening an existing database
Opening an Access table
Printing a table
Exiting Access
Creating and printing a query
Creating and printing a form
Getting help
Creating, previewing and printing a report
Compacting a database

Maintaining a Database

Guidelines for designing databases
Guidelines for designing Access tables
Creating a tableAdding records to a table
Saving a database
Modifying the structure of an Access table
Copying records from another Access database
Updating a database

Querying a Database

Introduction to queries
Query window
Creating and running a query
Defining table relationships
Sorting data in a query
Filtering data
Defining record selection criteria for queries
Defining multiple selection criteria for queries
Performing calculations

Creating Forms and Reports

Creating a form using the form wizard
Changing a form’s auto format
Navigating a form
Finding data using a form
Previewing and printing selected form records
Maintaining table data using a form
Creating a form with a main form and a sub form
Creating a report using the report wizard
Inserting a picture in a report
Converting an Access 2000 database to a previous version

Creating More Advanced Queries and Custom Forms

Creating a lookup wizard field
Displaying related records in a subdatasheet
Using the input mask wizard
Using a pattern match in a query
Using a list-of-values match in a query
Creating a custom form
Selecting and moving controls
Changing a label’s caption
Resizing controls
Using form headers and form footers
Changing the background color of a form object
Creating a multi-page form using tab controls
Using a filter with a form

Customizing Reports and Integrating Access with Other Programs

Creating a custom report
Report window in design view
Adding fields to a report
Working with controls
Adding the date to a report
Adding page numbers to a report
Adding a title to a report
Adding lines to a report
Defining conditional formatting rules
Sorting and grouping data in a report
Calculating group totals and overall totals
Hiding duplicate values in a report
Integrating Access with other programs
Embedding a chart in a report
Linking a word document in a report
Exporting an access query as an Excel worksheet

Working with HTML Documents, Data Access Pages, and Hyperlink Fields

Using the Web
Creating a data access page for an Access table
Sorting and filtering data access page records
Creating a custom data access page
Importing an HTML document as a Access table
Creating hyperlinks to documents in other Office programs
Creating hyperlinks to World Wide Web pages

Using Query Wizards

Creating a crostab query
Creating a find unmatched query
Action queries
Relationships between database tables
Using indexes for table fields
Joining tables

MS Publisher

Creating and Editing a Publication

What is MS Publisher
Starting and customizing Publisher
Creating a publication
The publisher window
Speech recognition
Entering text
Saving a new publication
Using graphics
Moving and resizing objects
Saving an existing publication with the same file name
Printing a publication
Quitting Publisher
Opening a publication
Modifying a publication
Creating a Web Page from a publication
Publisher help system

Designing a Newsletter

Designing a newsletter
Editing the newsletter template
Editing the masthead
Importing files
Saving an intermediate copy of the newsletter
Working with personal information sets
Editing sories in MS Word
Editing the design set
WordArt
Using graphics in a newsletter
Adding page numbers to the master page
Checking a newsletter for errors
Checking the newsletter for design errors

Publishing a Tri-Fold Brochure

Creating a tri-fold brochure
Custom color schemes
Replacing text
Font scheme styles
Formatting fonts and paragraphs
Using photographs and images in a brochure
Creating a logo from scratch
Outside printing
Packaging the publication for the printing service

Personalizing and Customizing Publications with Information Sets

Creating letterhead from scratch
Using layout and ruler guides
Personal information sets
Searching for and editing photographs
Using the measurement toolbar
Creating the lower portion of the letterhead
Using an automatic date
Business cards
Envelopes
Using the mail merge feature
Web sites

Creating Business Forms and Tables

Creating invoices
Creating styles
Using a drop cap
Working with tabs and markers
Coupons
BorderArt
Custom-size publications
Using tables
Calendar Web pages

Creating a Web Site

Creating a Web page from scratch
Form controls
HTML code fragments