Course |
Description |
Creating Access Reports in a Flash |
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 |
| |
|
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
Go to top of list |
| |
|
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 from 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 |
| |
|
New Features in Access 2007 |
Designed to show what the new features in the 2007 version of Access are and what differences exist between 2003 and 2007
|
| |
|
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 |
| |
|
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 |
| |
|
New Features in Excel 2007 |
Designed to show what the new features in the 2007 version of Excel are and what differences exist between 2003 and 2007
|
| |
|
Understanding Excel Formulas |
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:
• Working with ranges
• Crating simple formulas
• Creating and sorting lists
• Formatting numbers and text
• Creating a simple chart
Go to top of list |
| |
|
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 |
| |
|
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……
|
| |
|
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 |
| |
|
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 |
| |
|
New Features in Outlook 2007 |
Designed to show what the new features in the 2007 version of Outlook are and what differences exist between 2003 and 2007
|
| |
|
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 |
| |
|
New Features in PowerPoint |
Designed to show what the new features in the 2007 version of PowerPoint are and what differences exist between 2003 and 2007 |
| |
|
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 |
| |
|
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 |
| |
|
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 |
| |
|
New Features in Microsoft Word |
Designed to show what the new features in the 2007 version of Word are and what differences exist between 2003 and 2007
|
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 |
| |
|
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 |
| |
|
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 |
