全部版块 我的主页
论坛 数据科学与人工智能 数据分析与数据科学 Excel
7022 16
2010-08-25
看到大家有问过这本书,贡献出来。
看了才知道自己不懂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.


附件列表

Dashboard+reporting+with+Excel.pdf

大小:2.81 MB

只需: 1 个论坛币  马上下载

二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

全部回复
2010-11-10 22:36:46
老闆交待, 人海戰術, 自求多福, 感謝分享~
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2010-11-12 15:23:13
东西很好,下载来了看了
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2011-6-1 13:02:01
so great of this book , and thanks for sharing
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2011-6-9 20:54:43
thank you very very very much!
Great LZ!
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

2011-6-28 09:52:19
太好了,谢谢
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

点击查看更多内容…
相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群