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 |