|
|
Administrative Professionals! SharePoint! Microsoft Office 2007! What more
can we say?
If you'd like to download the the workshop materials, here they are.
We only ask three (3) things:
- Don't edit the materials directly or remove our copyright.
- If you use the materials to train your colleagues,
drop us an e-mail and let us know how it went.
- If you are a professional trainer, please talk with
us before adopting our materials as your own.
|
Workshop materials,
related books and resources, and
additional information
|
|
If there is
something we told you we would post here and you can't find it, please
let us know. |
| |
|
|
|
|
Day
|
Workshop |
| |
Sat |
Word 2007 for Power Users
For Word 2007, Microsoft totally rebuilt their
best-selling word processor from the ground up. If you settle for simply
learning the 2007 locations of the old commands you used in Word 2003,
you値l miss the new features designed especially for administrative
professionals that will make you and your colleagues more effective and
efficient.
Be a Word 2007 power user! Take advantage of the
amazing new features built into this version of Word. In this session,
you値l learn how to quickly and easily format and reformat documents.
Whether you assemble reports or create templates for others to use, Word
2007 can lighten your load.
Click
here to download the handout from this session.
|
| |
Sat |
Access 2007 Reports and Queries
In this session, you値l learn how to create new reports and queries in
your Access database. Using Access 2007, you値l learn how the parts and
pieces of a database work in concert with each other: tables, forms,
reports, and queries. We値l explore the relationships between tables,
and how you can capture those relationships in queries. Finally, we値l
create and format reports to present and summarize your data.
Click here to download the handout from the
Access session.
|
| |
Tues |
Moving to Office 2007
Click here to
download the handout from this session.
We didn't write a book on Office
2007. (We won't let that happen again!) Here are several Office books that we recommend, as well as our
Beginning SharePoint with
Excel book. Microsoft Office Inside Out
and the Office Bible are two "complete references" for Office
2007. Step by Step books are exercises you can use to get started
with new software.
Downloads mentioned in this session:
The
Compatibility Pack
that Office 2003 users can install to open Office 2007 documents.
You knew where everything was in Office 2003, now
you've moved to Office 007 and.....arrrrrrrrgh! Scream less! Smile more!
Download the ribbon maps from the Microsoft site:
Access
Excel
Outlook
PowerPoint
Word
|
| |
Tues |
Data on the Move: Mobile Options for Data and
File Management
Making data and files
available to a mobile workforce is a growing need for small and large
businesses alike. A number of new web-based products provide options for
gathering, reporting and maintaining data on the web. These products
include options for both password-protected and public access and make
it possible to collect data from your customers through easy-to-create
web-forms. If you have a need to share data with a mobile workforce,
this workshop will show you how.
Click here to
download the handout for this session.
|
| |
Wed |
Excel 2007 - Pivot Tables and Pivot Charts
If you have lists of
data in Excel and need to better understand or present the data, an
Excel PivotTable may be the tool you need. With pivot tables, you can
easily summarize vast amounts of data by date or other groupings,
combine and compare data in a table, and rotate (pivot) the table痴 rows
and columns to see different summaries in a flash.
Click here to
download the handout for this session.
Looking for an Excel book? We still think our Excel
2002 book is the best for 2002-2003 (and it's cheap because it's only
available second hand). Here's that great book, and other books that we
recommend for Excel 2007:
|
| |
Wed
|
Outlook 2007 - Email, Calendar, and Tasks
In this session you値l learn how to manage your
calendar, email, and tasks (basically, your work life) using Outlook
2007. We値l help you integrate useful new features of Outlook 2007 into
your work routine, and review the best practices for handling mail,
scheduling appointments, and managing your ad hoc work using tasks and
the To Do bar. We値l provide time at the end of this session for your
Outlook 2007 questions.
Click here to download the
handout for this session.
|
| |
Thurs |
A Picture Is Worth 1000 Words
Whether you are
creating a PowerPoint presentation, a cover for a printed report, a
t-shirt for your company picnic or the next edition of your chapter
newsletter, digital images can make your work stand out. In this
session, we値l explore how to:
- take quality
digital pictures,
- organize them
so you can find what you are looking for,
- get photos
taken by others,
- use free and
inexpensive tools to enhance images,
- position
images and diagrams where you want them in your documents and
presentations
Spend the morning
with us and you値l learn how to:
- find images
online to meet your needs
- transfer
images from cameras to computers
- retouch
pictures
- flip, crop,
recolor, highlight, and frame images
- create photo
collages
- share photos
online
- create custom
products like business cards, t-shirts, and stamps using your images
Click here to download the
handout for this session.
Want to create animated GIF images for
your web site or PowerPoint?
Click here to visit the web site for Easy GIF Animator 4 (Shareware,
$39.95, free 20-use evaluation available for download so you can try it
out).
Some of you asked about the external drive that Gini
just bought. It's the good lookin' Toshiba shown below.
If you need input devices
for fine selection and editing, or headsets for recording narration in PowerPoint presentations (Slide Show > Record
Narration on menu)here are links to products:
|
|
Looking for training for your organization?
Contact
us.
Order books
by IAAP Presenters Gini Courter and Annette
Marquis online
|
|
