|
|
|
|
Web site designed by
Patti Luchsinger
of
Professional Educators
|
Professional
Educators is offering Microsoft Office 2007 training classes during
the months of April and May. The classes will be held in the University Circle Room at
the Greater Cleveland Partnership/COSE
office which is located in the Higbee
building at 100 Public Square, Suite 210, Cleveland, OH
44113. In the event you need to
cancel your reservation, Professional Educators will refund
the total cost of the class. If you have a laptop, please bring
it with you to class. If not, contact us and we will do our best to
provide you with one. If you have any
questions, please contact
Patti Luchsinger of
Professional Educators at
440-967-9368 or at
educators@adelphia.net.
Thank you for your interest in our training classes.
|
 |
|
Word 2007 Introduction. This
is our most popular class and is loaded with tips and shortcuts that
will significantly increase your level of productivity in Word. You will learn to
use several quick keystrokes and text selection techniques to format and
edit text, use the Ruler to set Indents and change Margin Settings, set
Line Spacing, and use the enhanced Undo, Redo, and
Repeat commands. You will learn shortcuts to move and copy text, switch between
Normal, Print Layout
and Reading Layout views, and use Thumbnails to navigate between pages. You
will learn to use the new Mini Toolbar; insert Headers and Footers; and
format lists with Automatic Bullets and Numbering. You will learn to
create and insert AutoCorrect entries and the new Quick Parts building
blocks.
[Back to Form] |
|
Office 2007 New Features.
This class introduces the new Office 2007 user interface is the
recommended prerequisite for all of the Office 2007 training classes.
You will learn to use the contextual ribbons and tabs to access commands
that were previously organized into pull down menus and dialogue boxes
in earlier versions of Office. You will learn to use the new mini
toolbars to format text, and customize the Quick Access toolbar to add
your favorite tools. You will learn about the new XML file formats,
compatibility with previous versions of Office, and how to save files as
PDF’s. This class also provides an overview of new features that are
common to Word, Excel, and PowerPoint 2007 such as Quick Styles,
SmartArt, and Themes. You will also learn new features that are specific
to each application such as Building Blocks, Formula AutoComplete, and
Tables.
[Back
to Form] |
|
Excel 2007 Introduction.
You will learn to create worksheets with basic Formulas in addition to Function formulas
such as SUM, MIN, MAX, and AVERAGE. You will learn to copy text and
formulas to other worksheets and quickly copy text and formulas to
adjacent cells using AutoFill.
You will learn to use the new Page Layout view to paginate worksheets, add
headers and footers, and incorporate Print Titles. You will learn to
Sort and Filter data, use Freeze Panes and Split Screen, create
multi-sheet
workbooks, and Group worksheets for consistent
formatting. Additional topics include navigation techniques, several
time-saving quick keystrokes, and tips to print
worksheets and workbooks.
[Back
to Form] |
|
Office 2007 Application Integration. This
seminar teaches you how to integrate data from several Office
applications into one document. You will learn to integrate and Link
Excel worksheets and Charts into Word documents and PowerPoint
presentations. Experience with Word, Excel, and PowerPoint is
recommended.
[Back
to Form] |
|
Outlook 2007 Introduction.
Learn to send messages with Importance options, request Delivery and
Read Receipts, Delay the Delivery of a Message, Draft a Message, use
Desktop Alerts, and Restrict Forwarding, Printing and Copying messages. You will also learn to create
Folders and move and copy
messages between them, add and remove Favorite folders, Sort and Search
for
specific messages, use the Rules Wizard to organize mail, enable the Out
of Office Assistant, and Flag messages for follow-up. You will learn to
work with attachments, create customized Stationary, create Distribution
Lists, and add your Signature
to outgoing mail. Learn to create Contacts from messages, and customize the new To Do Bar.
[Back
to Form] |
|
Excel 2007
Charts. This course teaches you to use
the charting capabilities of Excel. You will learn to create Bar, Line,
and Pie Charts to illustrate worksheet data graphically. You will modify
chart objects including the Data Series, Chart Axis, Fonts, and Chart
Titles. You will learn to embed charts onto existing worksheets and
position charts on separate worksheets. You will also learn to integrate
and link Excel Charts into Word documents and PowerPoint presentations.
Printing tips are also included. Excel 2007 Introduction is the recommended
prerequisite.
[Back
to Form] |
|
Excel 2007 Intermediate.
You will learn to
create Range Names and reference them in Function formulas such
as SUM, MAX, MIN, AVERAGE, IF, and COUNT. You will learn to use
Absolute and Mixed references to prevent cell addresses in formulas
from adjusting when you copy them. You will learn to use the new Formula AutoComplete feature, the new Calculated
Columns feature, and the new Table feature. You will learn to use
Advanced Sorting and Filtering techniques and query a database
using Database Function formulas such as DSUM, DMAX, DMIN,
DAVERAGE. You will learn to use Date
and Time functions to perform calculations with dates and times. You will
learn to create multi-sheet workbooks that include three-dimensional formulas,
duplicate worksheets in a workbook, and copy and move worksheets
between workbooks.
Additional topics include Auditing worksheets and Integrating data from
other applications. Excel 2007 Introduction is the recommended
prerequisite.
[Back
to Form] |
|
Excel 2007 Advanced. Learn to use
advanced Function formulas such as IF, ROUND, RANK, COUNT, LOOKUP, VLOOKUP,
and HLOOKUp. You will learn to create Pivot Tables and format Pivot
Table Reports and Charts. You will learn to Record and Run Macros to
automate repetitive tasks. Additional topics include creating Styles and
Templates, Protecting worksheets and
workbooks, Hiding rows and columns and creating custom Number Formats. Excel 2007
Intermediate is the recommended
prerequisite.
[Back
to Form] |
Word 2007 Intermediate.
You will learn to create and modify Styles which are an absolute
MUST for every Word user because they work in conjunction with
many other features such as the Document Map, Themes, Select
Browse Object, and Outline View. You will learn to apply
built-in styles, create new styles, and modify styles to format
multiple paragraphs simultaneously. You will learn to set Tabs and
Indents to align text, create Tables to format information into columns
and rows, and use Automatic Numbering and Bullet lists. You will learn
to insert
Section Breaks to incorporate multiple document formats in a single document. Word 2007 Introduction is the
recommended prerequisite.
[Back
to Form] |
|
Word 2007 Advanced. You will learn to customize number and bullet
lists, use multi-level numbering styles for outlines, link Excel and
PowerPoint data, create macros to automate repetitive tasks, and create and
modify templates. You will also learn to use the master document feature to maintain long
documents into more manageable subdocuments. Word
2007 Introduction and Word 2007 Intermediate are the recommend prerequisites. [Back
to Form] |
|
Word 2007
Tables. Tables are a simple alternative
to setting tabs when you want to align text in columns. Tables are also
the feature to use when you want to type on top of a line. You will
learn to apply
Borders and Shading to enhance a table, apply Table Styles to quickly
format a table, and hide Borders so that lines do not appear on the printed page.
You will learn to Draw a table to replicate a printed form, Convert text
to a table, and Sort table data. You will learn to create Building
Blocks to quickly insert tables and enter Formulas in a table to make calculations. You
will also learn to insert an Excel worksheet in a Word document to use
the more advanced formula capabilities of Excel! Word 2007 Introduction is the
recommended prerequisite.
[Back
to Form] |
|
Word 2007 Mail Merge. This seminar teaches individuals to use
the mail merge capabilities of Word. You will learn to set up and merge
form letters, envelopes and labels and quick tips to create and sort
your data file. You will learn to perform conditional merges to print
only the letters, labels or envelopes you need. Word
2007 Introduction and Word Tables are the
recommended prerequisites.
[Back
to Form] |
|
Word 2007 Forms and Templates.
Learn to create Forms that include Content Controls such as Check Boxes,
Text Fields, Drop Down
Lists, Date Pickers, etc. You will learn to use Design Mode to change
Placeholder Text and Protect parts of the form to prevent others from
editing. You will learn how others will access and complete the Form and
how you will modify the Form Template when necessary. In addition, you
will learn to insert Legacy Form Fields, save and print the form, and
how to print only the data collected by the Legacy Form Fields. Word
2007 Introduction and Word 2007 Tables are the
recommended prerequisites.
[Back
to Form] |
Word 2007 Styles & Cross
Reference Codes. Styles are an absolute MUST for every Word user
because they work in conjunction with many other features in Word such
as table of contents, indexes, table of authorities, cross referencing,
and outline view. You will learn to apply built-in styles, create new
styles, and modify styles to format multiple paragraphs simultaneously.
You will learn to use styles to build a table of contents, index, and
table of authorities. Word 2007 Introduction is the recommended
prerequisite.
[Back
to Form] |
|
Outlook Advanced. Learn to create
Search Folders to quickly find messages and other items based on search
criteria, create Rules to automate the organization of messages, apply
Conditional Formatting, and Archive old messages and other Outlook
items. You will learn to modify Outlook's default settings and customize
Outlook views. In addition, you will learn to create and forward
Distribution Lists, use the Meeting Manager to schedule meetings, and
include a vcard in your signature. Outlook 2007 Introduction is the
recommended prerequisite.
[Back
to Form] |
PowerPoint 2007 Introduction.
You will
learn to create a presentation, insert new slides, change slide size and
orientation, and apply design themes.
You will learn to create slides with Bar, Column, and Pie Charts,
and create slides with Tables and Organization Charts. You will learn to
insert Clip Art and other pictures and draw, resize, group, duplicate,
and move objects. You will learn to use the Slide Master to modify
several slides simultaneously, and suppress Slide Master Elements on
specific slides. You will learn to add transition and animation effects
when you run a slide show, and add your own Speaker's Notes to the
presentation. Presentation guidelines are included along with printing
tips and tricks.
[Back
to Form] |
|
PowerPoint 2007 Advanced.
You will learn to add Placeholders to a Slide Master, add a Customized
Layout, and switch from color to black & white. You will learn to create
and edit a Template, use a Theme from another presentation, insert
Tables, and insert and format WordArt. You will learn to use the new
Selection and Visibility Pane to arrange the order of objects, group and
ungroup ClipArt, and recolor pictures. You will learn to insert and edit
an Excel object on a slide, Hide slides during a presentation, use
Rehearse Timings and create a Button to link to another Slide or
presentation during a slide show. You will also learn to Package
presentations on a CD. PowerPoint 2007 Introduction is the
recommended prerequisite.
[Back
to Form] |
|
|