Wednesday, May 23, 2007

Excel 2007 Tips

I am using Excel 2007 quite a bit now, and starting to really experience the pain of switching between 2003 and 2007.
At least I am starting to get the hang of the ribbon.

Charley Kyd writes about Excel2007 on

What We'll Do About Excel 2007
I'm not one of Excel 2007's biggest fans. Although the program offers many outstanding new features, it has a completely new user interface.
Microsoft designed the interface to make it easier for new and occasional users to discover Excel's features. They didn't design the interface to make frequent users more efficient.
In business, Excel users are much like factory workers. Our job is to quickly produce reports, analyses, and other forms of business insight. Unfortunately, Excel 2007 requires more mouse clicks and more mouse travel than does earlier versions. It's inherently less efficient. Therefore, even after you've learned the new interface well, you'll probably take longer to perform standard tasks in the new Excel.
Even so, there's no going back. Eventually, you'll need to adapt to Excel 2007, or to one of its successors. At ExcelUser, we also need to adapt.
Therefore, all future articles that describe hands-on use of Excel will be offered in two versions. One version will be for old Excel, the other for new Excel. Each such article will begin with a link to the other version. And slowly, we'll offer new-Excel versions of past articles written for old Excel.
Because Excel 2007 introduces new terminology, many of the new-Excel articles will reference The Excel 2007 User Interface. This article provides one location for defining those new terms.
I will be taking similar approach here.

Labels: ,