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.
January 25th, 2007

Excel 2007 Visual QuickStart Guide Sample Files

Sample Files from the Book.

January 15th, 2007

Minimize the Ribbon

Getting back some screen real estate.

One of the things that you might find bothersome about Excel 2007’s Ribbon is the amount of space it takes up at the top of the workbook window. Fortunately, you can get it out of the way and recover that space. Here’s how.

Right click on any button on

Continue reading Minimize the Ribbon

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 requirements

To install this

Continue reading Microsoft Office 2004 for Mac 11.3.3 Update Now Available

January 12th, 2007

Excel 2003 VQS Correction of the Day

Another very minor correction to my Excel 2003 VQS for Windows book.

As I continue to revise the book for Excel 2007 on Windows Vista, I continue to find tiny errors in the existing book.

Today’s error is on page 118, in the caption for Figure 38. The caption states that gridlines have been turned off for

Continue reading Excel 2003 VQS Correction of the Day

January 2nd, 2007

Excel 2003 VQS Figure Correction

Well, it only took me 3 years to notice this.

Sheesh. It always happens. I find errors in books I’m revising, after thousands of people have bought the book and consulted it, sometimes for years.

Well, that’s part of what my Book Support sites are about: to provide corrections and clarifications to the books. So here’s a

Continue reading Excel 2003 VQS Figure Correction

December 30th, 2006

Excel 2007 QuickProject Sample Files

Sample Files from the Book.

December 19th, 2006

Excel 2007 Book Excerpts Now Online

I add two excerpts from my upcoming Excel 2007 Visual QuickProject Guide to the book’s companion Web site.

I just added the following two excerpts for my Excel 2007 Visual QuickProject Guide to the list of book excerpts available for download. These files are in PDF format and are roughly 1 MB each:

Front Matter, including Table

Continue reading Excel 2007 Book Excerpts Now Online

December 19th, 2006

Microsoft Office 2004 for Mac 11.3.2 Update Now Available

Information from Microsoft AutoUpdate.

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 available at January

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

December 4th, 2006

Office 2007 for Windows Now Available

Office 2007 has gone Gold Master, meaning it’s being prepared for distribution. It’s available for corporate users now and will be available for everyone else on January 30, 2007.

Why wait? You can download a trial version of Office from the Microsoft Web site at www.trymicrosoftoffice.com. It’ll give you 100% functionality for 60 days.

You can

Continue reading Office 2007 for Windows Now Available

October 16th, 2006

Microsoft Office 2004 for Mac 11.3.0 Update Now Available

Information from Microsoft.com.

This update contains several updates 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.

Learn more at http://www.microsoft.com/mac/autoupdate/description/AUOffice20041130EN.htm

Technorati Tags: Microsoft, update

September 29th, 2006

Solutions for Failing Eyesight

Don’t make the font size larger — zoom it!

Yesterday, I reread a blog entry I wrote earlier this year about my failing eyesight (“The Eyes Had It“). My far vision has always been bad, but now I’m beginning to lose my close vision, too. Miraz, my co-author on the WordPress book, commented that she’s going

Continue reading Solutions for Failing Eyesight

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 Peachpit calls it)

Continue reading New Excel Book in Progress

September 18th, 2006

FAQ System Replaced with Comment-Based Q & A System

I retire the old, underutilized system and replace it with a simpler, spam-protected solution.

One of the biggest challenges I have as an author is providing clarifications and corrections of my work to readers on request.

In the beginning, I used to just answer questions submitted via e-mail. But when I started getting dozens of questions a

Continue reading FAQ System Replaced with Comment-Based Q & A System

August 9th, 2006

Microsoft Office 2004 for Mac 11.2.6 Update Now Available

Information from Microsoft Office Updater.

This update fixes vulnerabilities in Office 2004 that an attacker can use to overwrite the contents of your computer’s memory with malicious code.

Learn more at Microsoft’s Web Site.

Technorati Tags: Microsoft, Office, update

July 12th, 2006

Microsoft Office 2004 for Mac 11.2.5 Update Now Available

Information from Microsoft AutoUpdate

This update fixes vulnerabilities in Microsoft Office 2004 for Mac that an attacker can use to overwrite the contents of your computer’s memory with malicious code. This update also fixes issues in Microsoft Entourage 2004 for Mac and includes all of the improvements released in all previous Office 2004 updates.

Click here for

Continue reading Microsoft Office 2004 for Mac 11.2.5 Update Now Available

June 13th, 2006

Microsoft Office 2004 for Mac 11.2.4 Update

Information from Microsoft’s Web site.

This update fixes vulnerabilities in Office 2004 for Mac that an attacker can use to overwrite the contents of your computer’s memory with malicious code. This update also fixes issues in Microsoft PowerPoint 2004 and Entourage 2004, and it includes all of the improvements released in all previous Office 2004 updates.

System

Continue reading Microsoft Office 2004 for Mac 11.2.4 Update

April 15th, 2006

RSS Feed Links Added to Book Support Sites

I make it possible to subscribe to the RSS feed for a specific book support site.

I use a WordPress plugin (of course) called UsersOnline to monitor site visitors. The plugin identifies what page the user is visiting. When I see a visitor on the “Oops! Page Not Found” page, I can point to a link

Continue reading RSS Feed Links Added to Book Support Sites

March 20th, 2006

Microsoft Office 2004 for Mac 11.2.3 Update Now Available

Information from Microsoft’s Web site.

Microsoft has released Microsoft Office 2004 for Mac 11.2.3 Update, which includes many improvements for all Microsoft Office applications. You can learn more on Microsoft’s Web site.

January 1st, 2006

Excel Books Q & A

Have a question about something in one of my Excel books? Here’s how to get the answer:

Browse through the comments at the end of this article to see if someone else has already asked your question. You might get the answer without even asking!
If your question is not asked (or answered), use the Leave a

Continue reading Excel Books Q & A

October 15th, 2005

Excel QuickProject Excerpts

Two Excerpts from Creating Spreadsheets and Charts in Excel: 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

September 6th, 2005

Excel 2003/2004 QuickStart Sample Files

Sample Files from the Book.

January 7th, 2005

Absolutely the Last Article You Need To Read About Absolute References in Excel

Informit article.

Ever copy a formula you think is perfect and have surprising (and incorrect) results in the destination cells? You might be missing out on a feature of Excel that can make your spreadsheet work easier.

Read more at: Absolutely the Last Article You Need To Read About Absolute References in Excel

October 6th, 2004

Excel 2003/2004 QuickProject Sample Files

Sample Files from the Book.