|
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.
|
|
Tips
& Tricks in Excel 2003. A necessity for introductory to intermediate
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. Some
experience with Windows XP is recommended. |
|
Create
Charts in Excel 2003. This seminar teaches individuals 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. Tips & Tricks in Excel 2003 is the recommended
prerequisite. |
|
Intermediate
Tips & Tricks in Excel 2003. This seminar teaches individuals to use
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. Tips & Tricks in Excel 2003 is the recommended
prerequisite. |
|
Advanced
Tips & Tricks in Excel 2003. This seminar teaches individuals to use
advanced function formulas such as IF, ROUND, ROUNDUP, LOOKUP, VLOOKUP,
HLOOKUp and the LOOKUP wizard. 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 incorporating custom number formats. Tips & Tricks in Excel 2003
and Intermediate Tips & Tricks in Excel 2003 are the recommended
prerequisites.
|
|
Tips
& Tricks in Word 2003. This is the 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 save time.
|
|
Intermediate
Tips & Tricks in Word 2003. This seminar teaches individuals to use
intermediate formatting features in Word. 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. Tips & Tricks in Word 2003 is the
recommended prerequisite.
|
|
Create
& Modify Tables in Word 2003. 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! Tips & Tricks in Word 2003 is the
recommended prerequisite.
|
|
Styles & Cross Reference Codes in Word 2003.
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. |
|
Create
Forms & Templates in Word 2003. 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. Tips & Tricks in Word
2003 and Create & Modify Tables in Word 2003 are the
recommended prerequisites. |
|
Mail
Merge in Word 2003. 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. Tips & Tricks in Word
2003 is the
recommended prerequisite. |
|
Tips
& Tricks in PowerPoint 2003.
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 Outlook 2003.
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. Some
experience with Windows XP is recommended.
|
|
Advanced Tips
& Tricks in Outlook 2003.
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. Tips & Tricks in Outlook 2003 is the recommended
prerequisite. |
|
Microsoft 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. Some experience with Word, Excel, and PowerPoint is
recommended.
[Back
to Form] |
