发帖
雷达卡
看了才知道自己不懂Excel。
介绍见链接：
http://www.exceluser.com/catalog/landdash1.htm
An Overview of the E-Book
I used to hate spreadsheet reporting.
As a manager, I hated to receive those long Excel reports. I hated to slog through those stacks of paper, each page with long columns of tiny numbers.
Somewhere...somewhere in all those numbers were key trends and exceptions that I needed to recognize as serious problems and opportunities. I hated the thought that I was missing so much treasure hidden in so much clutter.As a spreadsheet user, I hated to prepare those reports. I hated to spend long hours, month after month, turning the crank, producing reports that people often ignored.
(One time, I accidentally printed three copies of the same page in the same report. No one noticed.)
Then I found a solution an old copy of the Harvard Business Review.
The article was written in 1979 by George Blake, the VP Finance of one of the largest companies in Mexico. It explained how his company was using many small graphs on one page to report management performance.
(His small charts were much like the mini-charts I show below.)
In seconds, his managers could recognize critical trends. They could compare one measure of performance to another. They could ignore the expected and concentrate on the surprises. They were freed from those many pages of long columns of tiny numbers.
I fell in love with dashboards!
Back then, I was working on my first book,Financial Modeling Using Lotus 1-2-3. Because we couldn't create small charts in 1-2-3, I added a chapter that showed how to create "mini-graphs" using text characters in spreadsheets. This solution was primitive, but popular.
Then Microsoft introduced Excel, and I fell in love all over again. With Excel, I could deliver professional-quality management reports.
Finally, in 2004 -- after nearly fifteen years of development -- I decided to show Excel users the amazing results we could get from dashboard reporting with Excel. I had to tell Excel users about the reporting power they already have at their fingertips!
The version for Classic Excel (2003 and before) is 150 pages long; the version for New Excel (2007 and after) is 200 pages.
These books explain two key topics:
- They explain how to create Excel dashboard reports that provide readers with more information, more quickly, than with any other form of reporting I know of.
- They explain how to make your dashboards and other reports quick and easy to update by linking them to a spreadsheet database.
Both topics are mandatory. You never, NEVER want to create an Excel dashboard report that you can't update quickly.
At last count, enthusiastic Excel users in at least 165 countries have purchased my Excel dashboard books and templates.
京公网安备 11010802022788号
