Excel 2007 can open a document from a previous version of outlook in Compatibility Mode, but if you want to take advantage of some of the new features you’ll need to convert the document.(You can use 1.1 million rows in Excel 2007 instead of only 65k in previous versions)
After the tenth time saving an Excel spreadsheet and then emailing it to a co-worker still using Office 2003, I’m willing to save in 2003 format by default. It’s not like the rest of the office is going to switch for a very long time anyway, and this way I can stop sending them the wrong documents by mistake!
When you import data into an Excel Spreadsheet it is not always aligned in good proportion to the rest of the document. Here is the quick and easy way to line it up.
When you are all finished with a Word document that has been passed around your company for reviews, you can mark the document as final so that your colleagues know that it’s the final version and does not require additional editing. It also prevents people from accidentally making changes to the document before forwarding it on to a client, for instance.
The Instant Search box in Outlook 2007 is a huge improvement over previous versions of Outlook, but remembering all the search operators can be a little difficult, so here’s a quick one that I use all the time.
If you are worried about sensitive data in your Microsoft Word document you can both encrypt and password protect the document to keep it secure. This feature is very useful if you have to store your documents in a shared location, such as a network folder or home computer.
All geeks love line numbers… you can even add line numbers in your Word 2007 documents with just a few steps.
If you are the creative type that likes to use custom fonts in your documents or PowerPoint presentations, here is a cool tip to ensure that the readers of your document see the document with the fonts intact, just the way you want it to.
The comment tool in Word 2007 is a great way to proof-read a report or thesis paper and make notes to yourself instead of writing them onto a sheet of paper.
Google Calendar is a phenomenal web application for managing your calendars, but so many of us are still forced to use Outlook at work. The good thing is you can have the best of both worlds by subscribing to your Google Calendar from Outlook.
Nothing equals Excel for crunching of numbers, but what if your data isn’t already in an Excel spreadsheet? It’s as simple as using the Text Import Wizard.
The Research Pane in Word 2007 can help you easily translate text into other languages, using bilingual dictionaries powered by WordLingo.com.
Although it’s unlikely that you’ll ever hit the maximum Access database size of 2GB, it’s still good to know that you can set your database to automatically compact or shrink the file size. This is especially true for databases where you are adding and removing a lot of data each time.
One of the biggest new changes in Office 2007 is the new mini toolbar that pops up when you highlight text and either right-click or move your mouse up.
If you have a lot of Word documents and are not sure which one contains the information you need, Microsoft Word 2007 allows you to preview a document within Word without having to open each document.
AutoRecover is a Microsoft Office feature that will keep you from losing work in the event of a system crash or power outage by automatically saving your document at certain time intervals.
The Ribbon feature in Microsoft Office 2007 is full of features that make it easier to navigate through options, but it takes up a lot of space. If you think the Ribbon is too big, you can put it into a pseudo “auto-hide” mode and still retain all the functionality, but with a much smaller footprint.
Adding your contact information as a Signature to your emails is very useful in a corporate environment, but also for personal emails as well. You can add a signature the same way as you would in 2003, but you can also use The Ribbon as a new way to add your signature.
How many times have you had a Microsoft Office application crash or lock up your system? The worst culprits seem to be Outlook and Access for me.
In the corporate environment, Excel is king. So when you have an Access database report that you would really prefer to analyze in Excel spreadsheet form, there’s an easy way to convert it.
Microsoft Access is used within many businesses to store and access information. You can also create a simple report easily using the Report Wizard.
Everybody loves Gmail, but some people use a desktop client, especially in corporate environments where Outlook is king. Adding your Gmail account to Outlook 2007 couldn’t be easier.
You can use Mail Merge in Word 2003 to create mailing labels for a database full of customers.
The Microsoft Office 2007 color scheme certainly fits in Windows Vista, but fortunately for those of us unhappy with so much light blue, the color scheme can be changed.
When you know you are going to be out of the office for a few days, you can set up the Out of Office Assistant to reply automatically, letting people know that you are enjoying your vacation while they are stuck at work. You can also add rules to forward messages based on different criteria.