July 10th, 2007
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
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 10th, 2007
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
March 28th, 2007
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
February 23rd, 2007
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
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
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
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
October 6th, 2004
Sample Files from the Book.
Recent Comments