Applied Office
Onsite Software Training
applied tips : may 2009
Welcome to another issue of Applied Tips! As more people convert to the new Microsoft Office 2007, I have been including more information about features unique to the new version. But don't worry -- that I won't be ignoring the thousands of readers that are still on prior versions of Office. Users of Office 2003 and 2007 will find useful articles in Applied Tips and will continue to do so until the demand for Office 2003 dwindles.
Here's what I've written for you this month:
- Outlook: Learn how to categorize your incoming email, and automatically color it based on its contents. This is a new Outlook 2007 feature. Read!
- Word: Trouble positioning photos alongside your text? This in-depth article on picture positioning is all you'll need -- regardless of which version of Word you're using. Read!
- Excel: Create a pull-down menu right in a cell for easier data entry and accuracy in any version of Excel. Read!
- PowerPoint: Learn how easy it is to add a simple chart in PowerPoint 2007. Read!
- Access: Find out how easy it is in Access 2007 to resize a form's contents automatically to adjust for your user's different screen sizes. Read!
- Internet Explorer 8: Have you upgraded? Find out all the new features that make this a must-have upgrade. Read!
Are you curious about what's coming down the road for Office? It's Office 2010 and it's going to be here sooner than you think. In July, developers like me will have our first chance to see what's new -- and the blogs are all abuzz about features and minor changes that people will undoubtedly love. Stay tuned for the news!
become a fan!
Are
you on Facebook? Of course you are, everyone is. And
now, so is Applied Office.
Become a Fan of Applied Office on Facebook, and you'll soon have access to how-to videos, frequent tips, a quick way to ask for assistance, stay informed about upcoming classes, and more.
tweet!
Are you tweeting? Get more from Applied Office for free, and start following AppliedTweets on your Twitter account. A new Microsoft Office 2007 tip is sent each Monday, and here's what you've been missing:
-
May 12: While viewing your Outlook Calendar, jump back to Today by pressing Alt+O. Use Ctrl+G to jump to any specific date.
-
May 4: Go pro with PowerPoint by using Presenter Mode on a laptop: see your notes and upcoming slides on your screen, audience sees only slides.
-
April 28: While viewing an opened email in Outlook, press Ctrl+Period to view next, Ctrl+Comma to go back. Also works with Appointments and Contacts.
-
April 20: Read your Outlook email faster using the Reading Pane. Space to read and advance, Delete to delete, Ctrl+R to reply, Ctrl+Shift+V to Move.
Not on Twitter yet? Join for free.
upcoming classes in Stockton
Back by popular demand, more classes will be held in Stockton, CA at the beautiful University of the Pacific in a hands-on computer lab.
Here's what's being offered this June and July:
| Date | Class Topic | Time | Difficulty | Cost |
|---|---|---|---|---|
| Jun 22 (Mon) | Word for Beginners | 8:30am - 12:00 |
  |
$95 |
| Word - Forms and Tables | 1:15pm - 3:15 |
|
$65 | |
| Word - Mail Merge | 3:30pm - 5:00 |
|
$50 | |
| Jun 23 (Tue) | Excel for Beginners | 8:30am - 12:30 |
|
$95 |
| Excel - Creating Charts | 1:45pm - 3:15 |
|
$45 | |
| Excel - Tips and Tricks | 3:30pm - 5:00 |
|
$70 | |
| Jun 24 (Wed) | Excel - Formulas and Functions 1 | 8:30am - 12:00 |
|
$95 |
| Excel - Formulas and Functions 2 | 1:15pm - 5:00 |
|
$115 | |
| Jun 25 (Thu) | Microsoft Outlook | 8:30am - 12:00 |
|
$95 |
| Microsoft Publisher | 1:15pm - 5:00 |
|
$115 | |
| Jun 26 (Fri) | Microsoft Access - Beginning | 8:30am - 4:30 |
|
$210 |
| Jul 20 (Mon) | Word for Beginners | 8:30am - 12:00 |
|
$95 |
| Word - Intermediate Formatting | 1:15pm - 3:15 |
|
$65 | |
| Word - Styles | 3:30pm - 5:00 |
|
$50 | |
| Jul 21 (Tue) | Excel for Beginners | 8:30am - 12:30 |
|
$95 |
| Excel - Pivot Tables | 1:45pm - 3:15 |
|
$45 | |
| Excel - Locking a Workbook | 3:30pm - 5:00 |
|
$70 | |
| Jul 22 (Wed) | Excel - Formulas and Functions 1 | 8:30am - 12:00 |
|
$95 |
| Excel - Formulas and Functions 2 | 1:15pm - 5:00 |
|
$115 | |
| Jul 23 (Thu) | PowerPoint for Beginners | 8:30am - 2:00 |
|
$160 |
| Office 2007 - Overview | 2:30pm - 5:00 |
|
$50 | |
| Jul 24 (Fri) | Microsoft Access - Intermediate | 8:30am - 3:00 |
|
$185 |
There are group discounts and full-day discounts. More information, including a description of each class and online registration is available on my website. And as always, secular non-profit organizations and employees of University of the Pacific enjoy free admission when available.
Thanks for reading Applied Tips! Be sure to forward the newsletter to anyone you think might enjoy reading it, and please keep your feedback and questions coming.
-David Diskin