Lorraine Stephens & Associates, Inc.
Download Marketing Package
Home
Meet Lorraine Stephens
About the Company
Books and Products
Event Calendar
Classes,Seminars and Web Training
Titles, Themes and Topics
Contact Lorraine
Suggested Resources

National Speakers Association Member

"Learn Without Fear" Speaker, Author, Consultant, Trainer

Classes and Seminars


     
 

Below is a sample listing of classes and seminars delivered

•  An Introduction to Microsoft Access

•  Creating Access Reports in a Flash

•  Exploring Access and Designing a Database

•  The Alpha & Omega of Forms in Access

•  An Introduction to Excel

•  Creating Templates in Excel

•  Tips and Techniques in Excel

•  Advanced Excel Techniques

•  Integrating Office Applications - Using Word, PowerPoint, Excel, and Access together

•  Outlook - Process, Prioritize, & Produce

•  Powerful Presentations In PowerPoint

•  Enhancing Your PowerPoint Presentation with Graphs and Charts

•  Introduction to Microsoft Publisher

•  Introduction to Microsoft Word

•  Creating Forms in Microsoft Word

•  Creating Reports and Manuals in Word

•  Increasing Your Productivity in Word

  Introduction to XP Speech Recognition – Level I

•  Using XP Speech Recognition – Level II

Others available upon request

 

 

 

 

 

 

 

Course

Description

Length

An Introduction to Microsoft Access

For individuals who will need to design and use an Access database this course introduces the skills necessary for setting up and using database tables in Access. It includes tasks to use databases and database object:

•  Creating and working with tables

•  Setting field properties

•  Using filters

•  Creating relationships

•  Using simple queries

•  Analyzing tables

•  Creating basic forms and reports

Go to top of list

2 days

Creating Reports in Access

For those individuals who have a basic understanding of Access and are now ready to create reports, this course will be of great benefit. Among the topics to be covered are:

•  Creating basic reports

•  Advanced report design

•  Using Editing tools

Go to top of list

½ day

Exploring Access and Designing a Database

This one-day introductory course is a subset of An Introduction to Access . It covers the basics of understanding the Access application. Among the topics to be covered are:

•  1. Getting started

•  2.Creating and working with tables

•  3.Setting field properties

•  4.Sorting record

•  5.Using filters

•  6.Creating relationships

 This is an ideal course for someone who will be responsible for using an Access database, but not heavily involved in creating one.

Go to top of list

1 day

The Alpha & Omega of Forms in Access

This intermediate level Access course focuses on creating and using Access forms and sub forms.

•  To obtain the maximum benefit form this course you should be familiar with tables and queries. Our focus will be:

•  Creating forms in design view

•  Using Sub forms

Go to top of list

½ day

An Introduction to Excel

This course focuses on developing basic worksheet skills. The student will learn how to use mouse and keyboard commands to master the Excel functions. We will cover several productivity tools necessary for the development, editing, formatting and managing of worksheets. Among them are:

•  Using basic workbook skills

•  Creating simple formulas and using labels in formulas

•  Copying and moving data

•  Setting up and printing pages

•  Formatting cells for numbers and text

•  Using AutoFormat

•  Using large worksheets

•  Creating and editing charts

Go to top of list

2 days

Creating Templates in Excel

Templates enable us to quickly create formatted to be used as a template. Among the topics to be covered are:

•  Creating a template

•  Entering text and numbers

•  Editing a template

•  Creating an AutoText entry

•  Using a template for a new file

Go to top of list

½ day

Overview of Microsoft Excel

A mini course designed to provide an overview of Excel features. The students will learn how to create a simple spreadsheet and perform calculations. Among the topics to be covered are:

•  Creating and saving workbooks

•  Working with ranges

•  Crating simple formulas

•  Creating and sorting lists

•  Setting up you print page

•  Formatting numbers and text

•  Creating a simple chart

Go to top of list

1 day

Tips and Techniques in Excel

Did you know that you could highlight an entire row by holding the shift key while pressing the spacebar? Does it take your more than six seconds to create a chart? Are you typing the same list over and over when it is needed? Then you are a prime candidate for Tips and Techniques in Excel.

This seminar cover topics that range from basic formulas to complex formulas; pivot tables; the database features of Excel; and concludes with answering the many questions often asked about printing worksheets. One of the most informative seminars you will ever attend.

Go to top of list

½ day seminar

Advanced Excel Techniques

An in-depth course in the intermediate to advanced levels of Excel topics. In this course we cover:

•  Working with Excel as a database

•  Using Filters

•  Looking up data stored in tables

•  Logical functions (i.e. If … Then …)

•  Creating and using templates

•  Consolidating worksheets

And more……
2 days

Integrating Office Applications

Are you aware that Microsoft Office is a suite? This usually means that they are designed to work together. If you are planning to send out form letters then chances are you will need to use Access or Excel along with Word. If you are reporting information in the form letter that is represented in a chart, then how about making certain that the chart in Word automatically updates itself every time you change the data in Excel.

As we look at integrating these applications you will understand your ability to create the data only once and use it wherever it is needed.

If you are using Office applications now, you will pick up tips to increase your productivity. If you are not using Office, this is an excellent opportunity to have an overview of the applications and see how they function as a suite.

Go to top of list

1 day

Outlook - Process, Prioritize, & Produce

Do you have the feeling that email is eating your time alive? Are your daily objectives losing ground to a lack of productivity? Is recording and tracking your to-do list a task within itself? Don't feel alone if your responses are “yes”. Outlook offers many solutions to handling this digital world of information. As we cover the features of Outlook:

•  Calendar

•  Contacts

•  Journal

•  Mail

•  Tasks

we will discuss recommendations of how to use them.

Upon completion of the class, you will have a far better understanding of how Outlook can help you:

•  Set objectives

•  Collect information and tasks

•  Create an effective filing systems

•  Format emails properly

•  Handle emails with greater ease

•  Prioritize or commit

•  Use time zones

•  Track client activity

•  Categorize information

Go to top of list

½ day seminar

(This can be delivered as a 1 day hands on class if requested)

Enhancing Your PowerPoint Presentation with Graphs and Charts

Using charts and graphs has always been a way of bringing life to numeric data. This class focuses on:

•  Adding charts to your presentation

•  Understanding the various chart types

•  Using special effects to display the charts.

Go to top of list

½ day

Powerful Presentations In PowerPoint

This course introduces the skills necessary for developing presentations. It includes tasks to create, enhance, and print presentation slides; work in outline view; maximize combining presentations; and check spelling. The student will also learn how to create basic charts.

W will cover presentation techniques. Students will learn how to format and edit text; arrange, move, copy, and view slides; edit multiple presentations; and use clip art.

 We will also look at some of the editing tools that address tasks such as customizing presentations, and adding special effects.

Go to top of list

2 days

Introduction to Microsoft Publisher

Microsoft Publisher is an easy to use desktop publishing application. It makes it possible for a novice to create professional looking flyers, brochures, and newsletters.

In this class students will learn:

•  The basic difference between word processing and desktop publishing applications

•  The wizards that are available to help create documents

•  How to use the templates that are provided

•  Importing, formatting, and editing graphics

•  Creating document that contain columns, as in a newsletter

•  The use of WordArt to enhance the appearance of their documents

•  Using tables to present data, or as a method of presenting the table of contents

For anyone that might be asked to develop anything from a quick flyer to a detailed newsletter, this course is a must.

Go to top of list

1 ½ day

Creating Forms in Microsoft Word

This course covers the basics of creating an online form using Microsoft Word. We will cover using check boxes, drop-down fields, list items, adding help text and saving the form as a template.

In addition the students will learn how to use the form and print it.

Go to top of list

½ day

Creating Reports and Manuals in Word

An ideal course for anyone who has to prepare documents containing a table of contents, an index, and a cross reference. We will also cover the use of notes and bookmarks in Microsoft Word.

If you are creating documents that may be reviewed, revised, or edited by others, you will be pleased to see just how the topics on revision tracking can improve your productivity.

Go to top of list

1 day

Enhancing Your Knowledge of Word

An in-depth course that builds on the skills acquired in Introduction to Microsoft Word . Course content includes customizing toolbars, creating forms, tables, mail merge, using excel spreadsheets in the word document, creating mailing labels and envelopes, and inserting graphics.

Upon completion of this course, the attendee should have a good understanding of how to use Word to accomplish their daily tasks and to increase their productivity.

Go to top of list

1 day

Increasing Your Productivity in Word

This is designed for the user that is relatively new to Word and would like some tips on how to increase their productivity.

Among the topics to be covered are:

•  Working with multiple Word files

•  Tailoring the spell checker

•  Tips & Shortcuts for creating, editing and formatting documents

•  Determining the default save location for documents

•  Viewing and formatting large documents

•  Keyboard tips

•  Printing tips

Go to top of list

3 hour seminar

Introduction to Microsoft Word

This is a beginner's level course. It covers understanding the application, formatting, creating documents, saving, printing, using the spell checker, printing envelops, AutoFormat, Headers and Footers, tables, and more. Upon completion of this course a person who has not used Word before will be able to create basic documents with ease, and know many of the shortcuts that make productivity a natural.

Go to top of list

2 day class

Introduction to XP Speech Recognition – Level I

Learning speech recognition technologies will enable users to improve productivity, write using voice, create Word, Excel, PowerPoint, emails, and other office files by speaking, and reduce injuries sustained from the repetitive motions related to using a computer.

This class and will introduce:

•  The basics of speech recognition

•  The basics of voice commands

•  The basics of dictation

•  The basics of correcting and training techniques

•  Basic speech techniques for Microsoft Word , PowerPoint and Excel

Go to top of list

1 day

Using XP Speech Recognition – Level II

This six (6) hour class will focus on using intermediate level speech recognition techniques with Microsoft Word. We will cover such techniques as:

•  Dictating longer documents

•  Formatting reports and changing fonts

•  Creating tables

•  Headers and footers

•  Templates

•  Customizing voice software

•  And more …

Future computers won't be limited to input from keyboard and mouse. Why should you?

Go to top of list

1 day


 
     
 

 

 

 

 

 
     
  Print this Page Contact Us Copyright© 2004 L. Stephens & Associates, Inc.