OFFICE ARTICLES / MICROSOFT OFFICE, GOOGLE DOCS, AND MORE
For those of us that have to use Outlook 2007 at work, you should know that it not only handles mail and calendars, but also makes a very nice RSS reader as well. Of course, I don’t need to tell the couple hundred of you that are already reading the How-To Geek feed this way =)
If you want to share a small part of your Excel worksheet but don’t want to send an Excel file, you can copy part of the worksheet to the clipboard as a picture instead, which can be pasted into any application that supports images, such as your favorite image editor.
If you like to use Windows Calculator to perform quick calculations while in Excel, you can save time by adding it to your Quick Access Toolbar. This should work for any version of Excel that has the Ribbon.
One of my friends contacted me a while back asking why the default setting in Outlook 2007 is to not mark items as read until you switch to a different email, which leaves the new mail notification sitting in the system tray even though you’ve clearly read the email.
One of the best new features in Outlook 2007 is the To-Do bar, where you have quick access to your calendar as well as your task list. Unfortunately, the default setting of showing all of your tasks regardless of date can be overwhelming for anybody that has a lot of tasks, and just isn’t all that helpful.
Chart, numbers, worksheets … at a business presentation it can get rather monotonous looking at the same data sheets. Here is a way to add background graphics to your Excel spreadsheets to spice up those meetings.
After a dozen times of accidentally sending a Word 2007 document to co-workers still stuck on Office 2003, I’ve decided to make Word save in the Word 2003 format by default. (you can do the same thing in Excel)
With all the hype about the Ribbon, one of the more overlooked new features in Office 2007 is the Quick Access toolbar, which can be tremendously useful if you just take the time to customize it.
One of the more frustrating tasks in Word has is trying to continue a numbered list when it gets broken. In Word 2007 you can use the smart tags to easily continue the numbered list.
If you have large and long workbooks or Excel spreadsheets, being able to see the column or row labels is extremely important. Here is a quick way to freeze the labels in place for fast and easy viewing of your data.
When your documents include pictures, charts, or other graphics it’s nice to add a caption to describe more to the reader.
You can add emphasis to your Word 2007 documents by using Drop Caps… you know, those big letters at the beginning of a document or paragraph that make your document look really professional.
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!