Success Seminar Series®

MTI Home Page

Computer Software Basics

Windows XP

Microsoft Word

Microsoft Outlook

PowerPoint

Microsoft Excel

Microsoft Access

Microsoft Publisher

Microsoft Project

FrontPage

Internet Skills Basics

Computer Software Advanced               

Customer Service

Corporate            Communications

Management Series

Computer Software Series

Basics

   

Microsoft Windows XP / Office Basics

4-hour course (240 minutes)

Topics covered include:

 Windows Basics

  •  Mouse Usage

  •  Navigation / Folder Operations

  •  Taskbar

  •  Removing/adding/deleting/icons from the taskbar

  •  Grouping Similar Items

  •  Dialog Boxes

  •  Working with windows

  •  Moving, Resizing, Minimizing, Restoring, Maximizing, Scrollbars

 Control Panels

 Document-Related Skills

  •  Toolbars

  •  Menus – Thinking Categorically

  •  Shortcut Keys and Menu Positions

  •  Changing the Default Save-to Folder

 Help & Troubleshooting

  •  Ctrl + Alt + Delete

  •  Task Manager

  •  Restarting to clear memory

 

Back to the Top


Microsoft Word - Basic

4-hours (240 minutes)

Topics Covered Include:

File / Organization Basics

  •  Creating & Renaming Folders

  •  Changing the Default “Save To…” Folder

  •  Saving As…

  •  Search/Find files

  •  Headers and Footers

  •  Page Numbering

  •  Practice skills above on practice file system and practice documents.

MS Office General Shortcut Keys

Using Menus – Thinking Like Microsoft (Categorically)

  •  File – Choices for dealing with the document (file) itself

  •  Edit – Choices for changing things you’ve already typed

  •  View – Choices concerning how the document looks on the screen

  •  Insert – Choices dealing with objects you can insert into the document

  •  Format – Choices for changing the way the typed page looks

  •  Tools > Options – Choices for spell check, grammar check, and backup saving options

Formatting

Text

  •  Changing Font Face, Size

  •  Using Styles

  •  Format Painter

  •  Bullets and Numbering

  •  Finding and Replacing Text

  •  Update practice documents.

Paragraphs

  •  Indenting Text in Paragraphs

  •  Using, Setting, and Changing Tabs

  •  Update practice documents.

Documents

  •  Previewing Documents

  •  Columns & Gutters

  •  Page Orientation & Mirroring Margins

  •  Spelling and Grammar Checking

  •  Update practice documents.

Images

  •  Inserting ClipArt

  •  Inserting Images

  •  Text Wrapping Around Images

  •  Update practice documents.

 Back to the Top


Microsoft Outlook

4 hours (240 minutes)

Topics Covered Include:

Email

  •  Menus and Toolbars

  •  Creating and Sending Mail

  •  Opening, Printing, Replying, Forwarding

  •  Deleting

  •  Attachments

  •  Signatures

  •  Organizing Messages

Contacts

  •  Adding and Editing Contacts

  •  Sorting

  •  Filtering

  •  Grouping into Categories

  •  Changing Contacts View

Calendar

  • Scheduling Appointments and Events

  • Moving Events

  • Changing Calendar Views (daily, weekly, monthly)

Tasks & Notes

  •  Creating and Updating Tasks

  •  Assigning Tasks to Others

  •  Tracking Assigned Tasks

  •  Creating and Editing Notes

  •  Placing Notes on the Desktop (like Stickies)

Back to the Top


Microsoft Power Point

4-hour course (240 minutes) 

Topics Covered Include:

Basics

  •  Planning the Presentation

  •  Similarities to Word

  •  Elements of the Main Window

  •  Using templates

  •  Views

  •  Text Boxes

  •  Formatting Text

  •  ClipArt

  •  Outline View

  •  Promoting / Demoting Text

  •  Summary Slides

  •  Copying and Deleting Slides

Masters

  •  Title, Slide

Themes and Designs

  •  All Slides, Selected Slides

  •  Changing the Color Scheme

  •  Animating Text

Inserting Images

  •  ClipArt

  •  WordArt

  •  Saved Images

Back to the Top


Microsoft Excel

8-hour course (480 minutes)

Topics Covered Include:

Basics

  •  Creating, Saving, Opening Workbooks

  •  Adding and Naming Worksheets

  •  Changing the Default “Save To…” Folder

  •  Editing Data in Cells

  •  Selecting Cells

Formatting a Worksheet

  •  Merging Cells

  •  Cell Alignment

  •  Changing Row Height and Column Width

  •  Formatting Data Type

  •  Previewing

  •  Page Break Preview / Adding / Moving Page Breaks

Formulas

  •  Math Terminology - difference, sum, quotient, product, average

  •  Order of Operations

  •  AutoSum

  •  Addition, Subtraction, Multiplication, Division

  •  Relative / Absolute References

  •  Filling Formulas

Functions

  •  Average

  •  Min and Max

  •  Sum

  •  Count

Copying / Pasting Data, Formulas

Intermediate Basics

  •  Selecting nonadjacent cells

  •  AutoCorrect as a Shortcut

Formatting a Worksheet (cont.)

  •  Inserting/Deleting Cells, Rows, Columns

  •  Borders and Shading

  •  AutoFormat/Format Painter

  •  Hide/Unhide columns, rows

Paste Special… Options

  •  Hyperlinks

  •  Paste Link

Back to the Top


Microsoft Access - User-level

12 hours (720 minutes)

 Topics Covered Include:

Creating a Database

  •  Organizing Data

  •  Entering Data

  •  Printing a Table

  •  Maintaining a Table

  •  Modifying a Table

Relationships Among Tables

  •  Creating Related Tables

  •  Displaying Related Records in a Subdatasheet

  •  Queries

  •  Filtering Data

  •  Linking Data to a New Table

Forms

Reports

Importing and Exporting Data

Creating a Data Access Page

Back to the Top


Microsoft® Publisher®

2-hour course

 Topics Covered Include:

Creating Publications

  •  From Scratch

  •  From Templates

Page Setup Options

  •  Working with:

    Textboxes

    Images

    Word Art

    Clipart

    AutoShapes

Formatting

  •  Text

  •  Paragraph Properties

  •  Spellchecking

  •  Master Pages

Multi-page Documents (i.e. Newsletters)

  •  Imposition

  •  Setting Margins and Gutter

  •  Linking textboxes (Like window shades in Adobe PageMaker)

Back to the Top


Microsoft Project

6-hour course

Topics Covered Include:

          Glossary

Calendars

Documents

Go To Task in Calendar View

Reports

Resources

  •  Tasks

  •  Tables – How to enter information and what the information means

Timing Relationships Among Tasks

  •  Updating and Tracking Progress

  •  Views

Back to the Top


Discovering FrontPage®

4-hour course 

Topics Covered Include:

  •  Basics of HTML editing

  •  Using hyperlinks

  •  Designing custom link bars

  •  Page formatting

  •  Drawing tools

  •  Picture editing

Back to the Top


Internet Skills – Basics

4-hours (240 minutes)

Topics Covered Include:

  •  Navigation buttons

  •  Hyperlinks

  •  Setting the Home Page

  •  Search Engine Conventions (quotes, “and,” “not”…)

  •  Adding to Favorites

  •  Organizing Favorites

  •  History

  •  Downloading images

  •  Saving sites

  •  Opening new browser windows

  •  Spyware

  •  Viruses and .exe files

  •  Cookies                                       

Back to the Top