|
Tips & Tricks in Windows XP. 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 2003 Introduction. A necessity for introductory
Excel users. Learn to set up new worksheets and edit existing
worksheets with basic formulas in addition to functions formulas such as
SUM, MIN, MAX, and AVERAGE. Use AutoFill to quickly copy formulas
and text to adjacent cells. Learn quick tips to paginate and print
worksheets, workbooks, and ranges and sort and filter data. Use
workbooks to set up large worksheets and group sheets for consistent
formatting. Additional topics include navigation techniques and several
quick keystrokes. Tips & Tricks in Windows XP is the recommended
prerequisite.
[Back
to Form] |
|
Excel 2003
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 2003 Introduction is the recommended
prerequisite.
[Back
to Form] |
|
Excel 2003 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 2003 Introduction is the recommended
prerequisite.
[Back
to Form] |
|
Excel 2003 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 2003
Intermediate is the recommended
prerequisite.
[Back
to Form] |
|
Word 2003 Introduction. This is
our most popular
course. Learn the
shortcuts to set line spacing, incorporate automatic bullets and
numbering, change margins and indents, display toolbars, and create
AutoText and AutoCorrect entries to quickly insert commonly used text
and graphics. You learn several quick keystrokes, selection techniques,
and formatting shortcuts that will save you time. Tips & Tricks in Windows XP is
the recommended prerequisite.
[Back
to Form] |
|
Word 2003 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 2003 Introduction is the
recommended prerequisite. [Back
to Form] |
|
Word 2003 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
2003 Introduction and Word 2003 Intermediate are the recommended prerequisites. [Back
to Form] |
|
Word 2003
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 2003 Introduction is the
recommended prerequisite.
[Back
to Form] |
|
Word 2003 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
2003 Introduction and Word 2003 Tables are the
recommended prerequisites.
[Back
to Form] |
|
Word 2003 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
2003 Introduction and Word 2003 Tables are the
recommended prerequisites.
[Back
to Form] |
|
Outlook 2003 Introduction.
Learn to create folders to organize
saved messages and use sorting and quick search techniques to find
specific messages. Use flag for follow-up to mark important messages for
future actions and resend and recall messages. You'll learn to print and
save attachments, create customized stationary and add your signature
automatically to outgoing mail. Learn to maintain your address book and
use quick shortcuts to address messages, add contacts to your address
book, and create distribution lists. Automate incoming mail by creating
rules to automatically delete junk mail and move specific messages into
folders. Tips & Tricks in Windows XP is
the recommended prerequisite.
[Back
to Form] |
|
Outlook 2003 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 2003 Introduction is the recommended
prerequisite.
[Back
to Form] |
|
PowerPoint 2003 Introduction.
This seminar
teaches tips and tricks in PowerPoint 2003. 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. Tips & Tricks in Windows XP is the
recommended prerequisite.
[Back
to Form] |
|
Office 2003 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. Word 2003 Introduction, Excel 2003 Introduction, and
PowerPoint 2003 Introduction are the recommended
prerequisites.
[Back
to Form] |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
