Archives by Month

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.
July 28th, 2010

Creating a Time-Lapse Calculator with Excel

A quick way to perform movie-making calculations.

Continue reading Creating a Time-Lapse Calculator with Excel

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

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.

Continue reading Random Number Generator for Excel

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

Continue reading Microsoft Office 2004 for Mac 11.3.5 Update Now Available

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

Continue reading Printing an Excel Function Reference Sheet

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

Continue reading Excel Alignment Tips

January 12th, 2007

Microsoft Office 2004 for Mac 11.3.3 Update Now Available

Information from the Microsoft Office 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 of the improvements released in all previous Office 2004 updates.

System

Continue reading Microsoft Office 2004 for Mac 11.3.3 Update Now Available

December 13th, 2006

Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickStart Guide is Off to the Printer

(I just write ‘em — I don’t name ‘em.)

The revision to my Excel 2007 Visual QuickStart Guide was shipped to the printer this week. My editor expects the book to be in stores by year-end.

The book is a raw beginners guide to Excel. This version covers Excel 2007, which will be widely

Continue reading Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickStart Guide is Off to the Printer

September 20th, 2006

New Excel Book in Progress

After two months off from writing, I begin work on an Excel book revision.

I dove into a revision of my Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide book today. I actually got the first chapter — all 16 pages of it — done.

If you’re not familiar with the VQJ (as

Continue reading New Excel Book in Progress

October 6th, 2004

Excel 2003/2004 QuickProject Sample Files

Sample Files from the Book.

Continue reading Excel 2003/2004 QuickProject Sample Files