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 15th, 2007
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
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
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
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
Sample Files from the Book.
December 19th, 2006
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
Information from Microsoft AutoUpdate.
December 13th, 2006
(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 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
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
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
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
August 9th, 2006
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
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
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
March 20th, 2006
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.
October 15th, 2005
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
January 7th, 2005
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
Sample Files from the Book.
|
|
Excel 2007 Visual QuickStart Guide Sample Files
Sample Files from the Book.