Archives

Support this Site!

You may have noticed that there's very little third-party advertising on this site. I'd like to keep it that way. Here's how you can help:

  • Buy my books. They're available at great prices on Amazon.com.
  • Check out my training videos on Lynda.com. It's a great source for "all you can eat" training.
  • Donate a few dollars. It'll help cover my hosting costs and give you a chance to tell me what you want to see covered here.
  • Comment on blog posts. You can help get a discussion going that can benefit others, making the site more valuable for everyone.
November 24th, 2009

“Office 2008 for Mac: Small Business Projects” is Now Available on Lynda.com

New Lynda.com course helps small business owners use Office to build their businesses.

November 11th, 2009

What Tasks Do You Need to Complete for Your Small Business?

Participate in an informal survey and win a book or one-month Lynda.com membership!

November 10th, 2009

Office 2008 12.2.3 Update Now Available

Information from Microsoft AutoUpdate.

October 7th, 2009

Office 2008 Installer Needs Rosetta? Duh-oh!

Just something idiotic I wanted to share.

May 4th, 2009

90 Days on a Wednesday

An Excel solution.

October 14th, 2008

Office 2008 12.1.3 Update Now Available

Information from Microsoft AutoUpdate.

August 12th, 2008

Microsoft Office 2008 for Mac 12.1.2 Update Now Avialable

Information from Microsoft’s Web site.

June 27th, 2008

Microsoft Office 2008 12.1.1 Update Now Available

Information from Microsoft’s updater.

March 2nd, 2008

Microsoft AutoUpdate 2.1.1 Now Available

Information from Microsoft AutoUpdate.

February 1st, 2008

Buy Excel 2007 Books for 50% Off

Buy my Excel 2007 books at 50% off retail price.

November 16th, 2007

Site Topics Available as RSS Feeds and E-Mail Subscriptions

Get content delivered to your RSS reader or e-mail box.

November 15th, 2007

Two Blogs? Again?

After over a year of soul-searching, I decide to spin off my book support topics to their own site.

October 15th, 2007

Excel 2007 QuickProject Excerpts

Two Excerpts from Creating Spreadsheets and Charts in Microsoft Office Excel 2007: Visual QuickProject Guide.

Want to see some sample pages from my Excel Visual QuickProject? Here are a few links.

Front Matter (including complete Table of Contents)
Excerpt from Chapter 3

August 21st, 2007

Peachpit Launches New Web Site

And offers 40% discounts on books purchased online.

Just a quick note to pass along some info I got in e-mail from Peachpit Press, one of my publishers.

Over the last several months, you’ve been talking and now it’s our chance to show you that we’ve been listening. You told us you wanted better and faster searches

Continue reading Peachpit Launches New Web Site

August 14th, 2007

Microsoft Office 2004 for Mac 11.3.7 Update

Information from the Microsoft Web Site.

This update fixes a vulnerability that an attacker can use to overwrite the contents of your computer’s memory with malicious code. For more information about this update, see the Microsoft Knowledge Base article (KB940763).

System requirements

Before you install this update, make sure that the Microsoft Office 2004 for Mac 11.3.6 Update

Continue reading Microsoft Office 2004 for Mac 11.3.7 Update

July 11th, 2007

Excel Splitting Digits Example

Another quick spreadsheet to show off the capabilities of Excel.

Site visitor Jamie left the following comment on my recent post, “Random Number Generator for Excel“:

maria dont spose u know how to split a four digit number like 2365 into 4 different numbers 2 3 6 5 in all different cells in excel without having to

Continue reading Excel Splitting Digits Example

July 10th, 2007

Microsoft Office 2004 for Mac 11.3.6 Update Now Available

Information from Microsoft’s Web site.

This update fixes a vulnerability that an attacker can use to overwrite the contents of your computer’s memory with malicious code. This update also addresses an issue with using public folders in Entourage, and it contains the latest postal code information for Japanese addresses.

System requirements

Before you install this update, make sure

Continue reading Microsoft Office 2004 for Mac 11.3.6 Update Now Available

June 28th, 2007

Random Number Generator for Excel

A quick little project.

I just happened to visit a Web site that used another Web site to generate random numbers for contest giveaways. To me, an Excel user, that seemed like a silly place to go to get a random number when you could easily generate one on the fly within Excel.

So I whipped

Continue reading Random Number Generator for Excel

May 11th, 2007

Informit Publishes Excel 2007 Book Excerpt

“Working with Excel Files” goes online.

Just a quick note to let Excel 2007 users out there know that Informit has published an excerpt from my Excel 2007 Visual QuickStart Guide on its Web site. The piece is titled “Working with Excel Files.” Access to the site is free.

I’m pretty sure the book is out,

Continue reading Informit Publishes Excel 2007 Book Excerpt

May 10th, 2007

Microsoft Office 2004 for Mac 11.3.5 Update Now Available

Information from the Microsoft Web site.

This update contains several improvements to enhance security and stability, including fixes for vulnerabilities that an attacker can use to overwrite the contents of your computer’s memory with malicious code. In addition, this update includes all the improvements released in all previous Office 2004 updates.

System requirements

To install this update,

Continue reading Microsoft Office 2004 for Mac 11.3.5 Update Now Available

April 3rd, 2007

Excel Book Done

That’s book number 68.

I put the finishing touches on Microsoft Office Excel 2007: Visual QuickStart Guide. It’s my 68th book (I just counted) and right now, I feel as if I wrote them all yesterday.

Okay, so not that tired.

I had some trouble with this book. First, there was the beta software situation. Not only

Continue reading Excel Book Done

March 28th, 2007

Printing an Excel Function Reference Sheet

A how-to for Excel users.

My Visual QuickStart Guide books for Excel — from the edition for Excel 95 for Windows through the edition for Excel X for Macintosh — have always included an Excel function reference. In an effort to make pages available for other content, however, we’ve cut that appendix from the Excel

Continue reading Printing an Excel Function Reference Sheet

March 16th, 2007

Excel 2007 Visual QuickProject Sample Chapter Now Online

Informit releases a chapter of my Peachpit Press book on its Web site.

Every once in a while, Informit.com, the online publishing arm of Pearson Education (parent company of Peachpit Press) releases a sample chapter of a book on its Web site. It apparently has done that with a chapter of my Excel 2007 Visual

Continue reading Excel 2007 Visual QuickProject Sample Chapter Now Online

February 23rd, 2007

Excel Alignment Tips

For perfectionists.

One of the things that always bothered me about Excel was the way it handled right alignment in cells with certain types of number formatting applied.

The Problem

For example, in the following illustration you’ll see that some cells containing values have currency formatting and other cells containing values have comma formatting applied. The line up

Continue reading Excel Alignment Tips

February 13th, 2007

Microsoft Office 2004 for Mac 11.3.4 Update Now Available

Information from the Microsoft Web site.

This update contains several improvements to enhance security and stability, including fixes for vulnerabilities that an attacker can use to overwrite the contents of your computer’s memory with malicious code.

System requirements

Before you install this update, make sure that the Microsoft Office 2004 for Mac 11.3.3 Update is installed on

Continue reading Microsoft Office 2004 for Mac 11.3.4 Update Now Available