10 Reasons a Real Estate Agent Should Upgrade to Office 2007
By Chad A. Johnson · June 27, 2007
It is almost unfortunate that Microsoft released Office 2007 on the same day of the release of Windows Vista. In the technology shadow of the massive juggernaut, Office received little attention. While I am impressed by Vista, it is the advancements that Microsoft has made in the latest version of Office that really blows me away. These changes are significant enough for me to whole-heartedly recommend Office 2007 to real estate agents, no matter what version of Microsoft Office they are currently using.
The most obvious change (and the one most talked about) is the addition of the new user interface called the “Ribbon”. While I think that the idea of changing the menu options based on your current activity is brilliant, I would like to look beyond the obvious to the smaller features and tweaks. Those little things that you wished Office always had and now does.
While I couldn’t possibly cover all of these new features, I have put together a list of 10 features that has made my life easier and more productive.
- Save as PDF – The PDF file format is gaining more and more importance in the real estate industry and now you can save your Office files directly as a PDF, no additional software required.
- Email Merge in Publisher – Email marketing is becoming a standard marketing channel in the real estate industry. Publisher 2007 has now made it easier to send full cover email campaigns to your past client base by adding email merge capability. You can now personalize each email and send it without relying on the BCC field.
- Indexed Searches in Outlook – Outlook has always had a Find feature, but it has been painfully slow. Searches in Outlook 2007 are virtually instantaneous. Your search keywords are even highlighted in the search results. I would have upgraded just for this feature!
- Easier Pivot Tables – I am a statistics junky. I love to analyze market activity to find trends. I use pivot tables in Excel to create dynamic tables and charts. The new Excel finally makes creating pivot tables an intuitive process. The pivot charts that it creates look so good that you will want to include them in all of your listing presentations and marketing materials.
- Context Checking – There? Their? They’re? I often forget which one to use. The new context checking ability in Word will put a blue underline on any word that it feels is misused. I love technology that makes me look smarter.
- Post to Your Blog From Word – You know that blogging is here to stay when Microsoft incorporates it into Word. You can now publish a post directly from Word to your blog. Why would you want to do this? Think, active spelling, grammar and context checking.
- Smart Art in Powerpoint – This is so cool that you have to try it. Take a list of bullet points in Powerpoint and turn them into a chart with a click. Use this and your listing presentation will jump to the next level of professionalism.
- Text Formatting Menu – Right-click on any text and find a formatting menu pop up. No longer do you need to venture off to the top menu to change the font or size of text. This menu as to be using my wrist fatigue.
- Conditional Formatting in Excel – In college, a professor showed us how to use convoluted formulas to change the background colors of cells in Excel based on the cell’s value. With Excel 2007, you just need to highlight the cell(s), click Conditional Formatting and make a selection. Try this to color code a spreadsheet of listings. Color code listings that sold below asking price in one color and those above as another color. Once you do this, you will see market trends without even putting your glasses on.
- Graphs that Impress – All I can say is “WOW”! Recreate a graph that you made in a previous version of Office in Office 2007 and get blown away. You will look like a professional graphic artist to your clients.
I’m sure that I missed many indispensable new Office features. If you can think of one, leave a comment telling us about it. We’d love to hear why you think Office 2007 has made your real estate business more efficient.
Tips on Using Microsoft Office 2007 for your real estate business.
View microsoft Office 2007 Video Promotion
If you have enjoyed MyTechOpinion - Technology for Real Estate, please subscribe to our RSS feed!














You had me at “publish your blog from Word”.
/softly falling tears
What’s number 10?
Do Excel 2007 pivot tables have medians as a function? Previous versions have had average, but not medians.
Number 10:
RSS feeds in outlook!!
Blogging from word: bad
formatting can get screwed up sometimes
My bad…I screwed up Chad’s post…all fixed now. -Reggie
Loren your #10 rocks too!
This is a very nice review. I have the 2003 version, I think I will look into upgrading. Good information. Thanks
Kevin - A median function is on the top of my Excel wishlist. Unfortunately, it is absent from 2007.
Loren - Thank you for bringing up RSS in Outlook. I use that feature everyday.
If you would calculate Median with Pivot Tables check out http://www.digdb.com. They have an add-in that will do the magic for you…Reggie
In case anybody is interested, I’ve posted my thoughts of Word 2007 (the ultimate blogging machine) on Rain City Guide and a 3 part review on (Part 1, Part 2, and Part 3) on my blog.
Great post guys. I had been considering 07 for quite some time but never had any real reason to pull the trigger. This article was a huge help!
Hey I really like your blog, I am out today trying to expand the
Real estate community that is growing on Criteo. Would you like
to try Criteo AutoRoll? I think it will be beneficial to showing you
other real estate blogs where you can develop relationships.
http://criteo.com