A Blogger’s Test Drive of Word 2007 (Part 2)

Fat Tires & Big Brakes

One of the things I dislike about WordPress is that it doesn't have a table editor like SubText does. Unfortunately, even the mighty SubText can compare to Word 2007 when it comes to table editing. Let's say I'm Ardell and I want to tell the bubble people they are wrong about some random nugget of real estate information. After all, I have the multiple's database at my fingertips, so I know the facts. Let's say I'm trying to point out that Kirkland is the most affordable lakefront community along the I-405 corridor (I'm showing off Word, not trying to prove this assertion. So don't flame me and tell me Renton is a better value.)

So, I create an empty table with a click and drag of my mouse like so….

And then I fill up my table with the facts I want to present. What's cool is that after you're done filling your table with data, you can then select Table Design tab from the ribbon and have word reformat your drab table into something more professional looking. Think of it as staging your blog content by painting the walls and rearranging the furniture. So with a few mouse movements you can convert this old thing…

City

Average

Median

Medina

$ 4,183,723

$ 3,250,000

Mercer Island

$ 3,459,062

$ 1,800,000

Clyde Hill

$ 2,993,133

$ 2,398,000

Kirkland

$ 1,063,496

$ 824,450

   

Into this

City

Average

Median

Medina

$ 4,183,723

$ 3,250,000

Mercer Island

$ 3,459,062

$ 1,800,000

Clyde Hill

$ 2,993,133

$ 2,398,000

Kirkland

$ 1,063,496

$ 824,450

   

An Excel-lent Power train

Even cooler is Word 2007's ability to use Excel 2007's charting engine (which like Word, has undergone very significant improvement from last version) from a blog post. So with a few more mouse clicks you can convert one of the above tables into a professional looking chart like so…

Now with your data presented in an attractive, easy to understand chart, you'll be the envy of all your readers. Everybody will think you're the consummate professional that spends hours writing your blog posts (even though you haven't spent more than 5 minutes creating your chart). Word 2007 also has a cool feature that Microsoft calls SmartArt. It's basically an easy way of creating professional looking diagrams, flowcharts, or org-charts. For example, the following illustration shows what makes a good blog post.

(to be continued…)

Print | posted on Saturday, April 28, 2007 12:50 PM

Feedback

# re: A Blogger’s Test Drive of Word 2007 (Part 2)

Gravatar left by ARDELL at 5/3/2007 12:11 AM
Show off. What do I have to feed you to teach me fancy graphs? I think I need to take a Word 2007 Class.

# re: A Blogger’s Test Drive of Word 2007 (Part 2)

Gravatar left by Robbie at 5/3/2007 4:38 AM
I'll teach ya (although, you should probably also take an Excel 2007 class while you're in school).

The hard part for me getting the numbers out of the data. I don't have NWMLS locator access (which probably doesn't help, I wouldn't know), so I end doing a fair number of SQL queries and pasting the results into Excel. After that, creating the chart is like picking wall paper or a paint color.

The hard part is making up your mind on what you want it to look, because you have 20 gad-zillion variations to choose from.

# re: A Blogger’s Test Drive of Word 2007 (Part 2)

Gravatar left by Jonathan Martin at 1/5/2008 2:56 PM
My Question is will Excel 2007 allow you to export the pretty graphs and chart to a jpg or gif? I am using 2003 and the web cross functionality is quite lame. I haven't upgraded to 2007, but if it is possible to export the graphs, I may just have to think about it.

# re: A Blogger’s Test Drive of Word 2007 (Part 2)

Gravatar left by Robbie at 1/6/2008 9:40 AM
There are many ways to skin this cat. I think even Excel 2003 might even let you do this (I don't have it in front of me, so I'm not 100% certain)... Here's the 2 approaches I'd take...

1. Select/Copy the chart in excel, paste it into paintbrush, photoshop, etc. and save as gif, png, etc.
2. Save the file as a Web Page (HTML, HTM), open the folder that contains external files and find your chart graphic file.

Unfortunately, there isn't a single step, save chart as menu option that I know about, so I think best alternative is option #1.

FYI - In case you didn't notice, the charting engine in Excel 2007 is much improved (better looking charts) and easier to use than the charting engine Excel 2003 was. So I'd still upgrade because of that.
Title  
Name
Email
(never displayed)
Url
Comments   
Please add 7 and 5 and type the answer here: