Contents
applied tips : march 2007
in this issue...
Here's another batch of useful tips and information for Microsoft Office and other programs that you're using on a daily basis. Please let me know what you think and what you would like to see in a future issue.
- Outlook: Appointments got you confused? Rescheduling an item on your calendar is a piece of cake. Read!
- Word: Want to spice up your documents with images, clip art, diagrams, and more? Find out how to use the Drawing Toolbar and insert all types of objects into your work. Read!
- Excel: Formulas can be a teeth-pulling nightmare, especially when you get a not-so-helpful error message. This article explains the Auditing Toolbar and error-finding capabilities of Excel. Read!
- PowerPoint: Is your toolbar showing icons you never need, and hiding the ones you want? Discover how you can customize the toolbars (or make your own) in PowerPoint or any Office application. Read!
- Access: Make your queries even more powerful by adding user-entered parameters (prompts) to your criteria. Read!
- Internet Explorer 7: Have you upgraded to IE7? If so, here's a list of the best features you might not be using yet. And if not, then here's a list of reasons to upgrade! Read!
And don't miss the mini-articles below, too!
introducing the vista corner
A new feature is coming to Applied Tips... the Vista corner! Many of my readers have said that they're taken the plunge and upgraded to Windows Vista and/or Office 2007, so this corner is for you!
Next month I'll start off with a list of reasons why businesses should consider upgrading to Vista. Send me your questions and I'll try my best to answer them in upcoming months!
daylight saving time notice
On March 11th, Daylight Saving Time (DST) will begin, three weeks sooner than in prior years. Naturally, this throws off computer systems around the country and upgrades are required.
Without applying the necessary upgrades, your PC mobile device will be out-of-sync for three weeks, showing your Outlook appointments at the wrong time!
To get help updating your computers, Microsoft has created the DST Help and Support Center with a simple wizard designed to walk you through the upgrade process.
rss feed available
Applied Office's website has gone RSS! Available now are weekly articles and upcoming class announcements. Add the
Applied Tips and Announcements RSS to your RSS reader today.
No idea what RSS is? With IE7 installed, headlines from your favorite websites can be delivered to you in a simple format that lets you scan the news and click on links that interest you.
Most major websites are now offering an RSS feed for their readers, as indicated by the RSS icon shown above. Subscribe to the feed by clicking the RSS icon when using IE7. Give it a try!
excel: understanding formulas workshop
Learn exactly how formulas work from the basics (simple arithmetic) to the complex (IF, financial formulas, etc). Time and date calculations, text manipulation, and handy formula tricks will also be covered. Watch how a time card is created that automatically calculates overtime, wage, and
vacation accrual.
This class is at the Lodi Chamber of Commerce on March 7, at 12 noon. Lunch is provided with your $37 ticket. Details here
Thanks for reading Applied Tips! Be sure to forward the newsletter to anyone you think might enjoy reading, and please keep your feedback and questions coming.
-David Diskin