|
Evaluation Form: |
Web Based Seminars
|
|
|
|
Experience live instruction right from your own PC. All you need
is Internet access and a telephone. The instructor temporarily
connects to your PC to demonstrate specific features in the
application as well as time-saving tips and shortcuts.
|
|
|
Word 2007 Introduction. You
will learn to use the new contextual Ribbons and Tabs to access features
and commands that were organized into pull down menus in previous
versions of Word. You will also learn to use the Microsoft Office button
and customize the new Quick Access toolbar. You will learn to adjust
page settings, edit text, set line spacing, use the Undo, Redo, and
Repeat commands, move and copy text; switch between Draft, Print Layout
and Reading views, use Thumbnails and the Document Map, format and align
text, use the new Mini toolbar; insert headers and footers; use the
automatic Spell and Grammar check features, insert and create
AutoCorrect entries; insert and create Quick Parts, paginate documents,
print envelopes and labels, send documents as email attachments, and
save and email documents as PDF files. You will also learn several quick
keystrokes, selection techniques, and formatting shortcuts that will
save you time.
[Back to Form] |
|
Excel 2007 Introduction.
You will use the new contextual Ribbons and Tabs to access commands and
create worksheets with basic formulas and Function formulas. You will
learn to use the new Formula AutoComplete feature, the new Calculated
Columns feature, the new Table feature, Absolute Referencing, and AutoFill.
You will also use the new Page Layout view to paginate worksheets, add
headers and footers, incorporate print titles, and quick tips to print
worksheets and workbooks. Use
workbooks to set up large worksheets and group worksheets for consistent
formatting. Additional topics include navigation techniques and several
quick keystrokes.
[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 of
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'll learn to
work with attachments, create customized stationary, create distribution
lists, and add your signature
to outgoing mail. Learn to create Contacts from messages, handle Junk
Mail, and customize the new To Do Bar.
[Back
to Form] |
|
Outlook 2007 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] |
|
Tips & Tricks in Windows. This
course is a must
for users who want to become more familiar with the Windows environment. Learn to utilize the
applications included with Windows such as My Computer, the Recycle Bin,
and various accessories. Learn quick navigation techniques to start
applications and multitask between them. Learn to create objects
(shortcuts) on the desktop for quick access to applications and files,
and understand how data files are saved and organized into folders using
the Windows Explorer. Learn
to create folders to organize data files and copy and move files between
them. Search for files based upon name, extension and the text inside.
[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 use
the intermediate features and formulas in Excel. You will learn to
incorporate range names and absolute referencing with function formulas
and advanced sorting and filtering techniques. You will learn to use database
function formulas to utilize the database functionality of Excel, and date
and time functions to perform calculations with dates and times. You will also learn to create
multi-sheet workbooks in Excel that include three-dimensional formulas.
Additional topics include auditing worksheets and workbooks, and integrating data from
other applications. Excel 2007 Introduction is the recommended
prerequisite.
[Back
to Form] |
|
Excel 2007 Advanced. This
course teaches individuals to use
advanced function formulas such as IF, ROUND, LOOKUP, VLOOKUP,
and HLOOKUp. You will also learn to create, modify,
and format pivot table reports and charts, and record and run macros to
automate repetitive tasks. Additional topics include auditing worksheets
and workbooks, creating styles and templates, protecting worksheets and
workbooks, and creating custom number formats. Excel 2007
Intermediate is the recommended
prerequisite.
[Back
to Form] |
Word 2007 Intermediate. 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 also
learn to apply and modify styles to simplify text formatting, and insert
section breaks to incorporate multiple document formats and headers and
footers 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 need text to appear in a column format. Apply
borders and shading to enhance a table or hide the lines and it looks
like tabs on the printed page. You will learn to create AutoText entries
to quickly insert tables and enter formulas to make calculations. You
will also learn to insert an Excel worksheet in a Word document to use
more advanced formula capabilities! Word 2007 Introduction is the
recommended prerequisite.
[Back
to Form] |
|
Word 2007 Forms and Templates. Create templates and insert
form fields for consistent document completion. Templates and form
fields enable you to incorporate check boxes, text fields, and drop down
list boxes in a form. In addition, you will learn to protect a form to
prevent modifications by other users. Learn to draw tables to replicate
a printed form in a Word template or document. 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 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. Tips & Tricks in
Word 2003 and Intermediate Tips & Tricks in Word 2003 are the recommended
prerequisites.
[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] |
|
PowerPoint Introduction.
This seminar
teaches tips and tricks in PowerPoint . You will
learn quick time saving tips in slide, slide
sorter, outline, and notes page view and quick navigation techniques to
move throughout your presentation. Tips in working with templates and
slide masters, and copying and moving slides between presentations.
Learn to use custom animation and transition effects with text and graphics throughout your
presentation. Presentation guidelines are included along with printing
tips and tricks.
[Back
to Form] |
|
Office 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] |
|