'How to' Microsoft Office 2007 | Tips for Microsoft Office Applications

Courses

Business Support Services

Office 2007/2010 Tips

Help and How-to for Microsoft Office Word 2007

Get rid of tracked changes, once and for all
Use Document Inspector to check for any tracked changes, comments, hidden text, or other personal information in your Word documents.
Help with blogging in Word
Find out how to get set up so you can write in Word and post to your blog.
Automatically summarize a document
Learn how to add the AutoSummary Tools to the Quick Access Toolbar and run the tools to create a summary automatically.
Create a table of contents
Word 2007 comes with powerful TOC features. Learn more about how to use them in your document.
Open a Word 2007 document in an earlier version of Word
If someone sends you a Word 2007 file, and you're using an earlier version of Word, you can still open the file. Find out how.

Help and How-to for Microsoft Office Excel 2007

Use headers and footers in worksheet printouts
Learn how to add headers or footers, including page numbers, or the date and time, at the top or bottom of a printed worksheet.
Print row and column headings on every printed page
Include column headings (A, B, C, etc.) or row headings (1, 2, 3, etc.) on your printed pages.
Repeat specific rows or columns on every printed page
Help ensure that the data in your worksheet is properly labeled by including row and column headings or labels on every page.
Change the placement of titles in a chart
Are your chart titles causing spacing problems? Learn how to quickly change their placement.
Vary the colors of same-series data markers in a chart
Learn how to automatically vary the colors for data markers in a chart.

Help and How-to for Microsoft Office Access 2007

AutoTab Property
The AutoTab property is useful for specifying if an automatic tab occurs when the last character permitted by a text box control's input mask is entered. Learn more about the AutoTab property setting and find out if setting the focus to move to the next control in a form's tab order would be helful in your database.
Back up a database
Use this process to guard against data loss and protect your investment in your database design.
Help Access run faster
By following these tips, you can help speed up many of the Access database operations, such as running reports or opening forms that are based on complex queries.
Export contacts to an Outlook address book
Access and Outlook are both excellent programs for managing your personal and business contacts. As a result, you might find yourself wanting to export contact data from Access to Outlook.
Top tips for Access 2007
No matter how long you've worked with Access, there are always a few more tips to learn. Read this article to learn more.

Get Microsoft PowerPoint 2007 Productivity Content with RSS on Office Online

Using PowerPoint in the classroom
You can find some of the most creative PowerPoint experts ... at your local elementary school. In this video, a teacher and some students describe how they use PowerPoint to create eye-catching presentations.
What do kids know about PowerPoint that we don't?
Creativity is infectious. Read about what happens when you give three ten-year-olds PowerPoint and tell them to "come up with something cool."
More PowerPoint experts - How fifth graders presented the Bard
"To bullet point or not to bullet point: that is the question." Find out how two students applied their PowerPoint skills to their report about Shakespeare.
Free 3-D shapes and objects template for PowerPoint 2007
Use this professionally-designed shapes to add pizzazz to your presentation. Or, if you prefer, you can learn how to create these shapes yourself!
Create a relationship graphic
How do you illustrate the relationships between several ideas? Create a relationship graphic quickly and easily using SmartArt graphics.

Help and How-to for Microsoft Office Outlook 2007

10 Ways to Get More from Outlook
Increase your produtivity with these 10 ways to get more from Outlook.
Community video: Hide Outlook from the Windows taskbar
Community video: Hide Outlook from the Windows taskbar
Change where the Offline Folder file (.ost) is saved
You can change the folder where your Exchange Offline Folder file (.ost) is saved.
E-mail message: Movie awards party invitation
And the award for best e-mail invitation to an award party goes to … YOU! Try this template to make your party stand out.
Customize Outlook Today
Did you know Outlook provides a summary of your appointments, a list of your tasks, and how many new e-mail messages you have all one on screen?

Productivity content for Project 2007

Quick reference guide for Project 2007
Learn the basics of project management with Project 2007. Print this Word document and tape it to your monitor!
Web 2.0 and Project 2007
Tap the collective wisdom of other Project users on Facebook, Twitter, blogs, discussion groups, and more.
Create a new project
Create a new project from scratch, or take advantage of previous work by using a template or an existing project.
Video: Insert a new task
This video shows you how to insert a new task between two existing tasks in your project.
Set working times, vacations, and holidays for your project
You can use the project calendar to reflect the general working days and hours of your project, as well as regular nonworking times (such as weekends and evenings) and special days off (such as holidays). You can also control how much a work resource is available to work throughout the life of the project.

Outlook Blog : Annik Stahl