Posts tagged as:

management reporting

Excel Dashboard Sample: Advice about Using Excel’s Camera Tool

by Charley Kyd on November 1, 2009

Of all the Excel features that users don’t use very often, the Camera tool probably is the most powerful. This tool, also known as a Picture Link, returns a real-time image of any range in Excel.

This tool is so useful that I devoted a full chapter to it in my ebook, “Dashboard Reporting With Excel.” [click to continue...]

{ Comments on this entry are closed }

Don’t Let Bad Spreadsheet Design Hurt Your Career, Part 3

by Charley Kyd on October 24, 2009

I just received a dashboard report that I also need to discuss. So for the next few weeks I’ll turn into a spreadsheet critic.

Splattered Data

Imagine dropping a can of paint onto a parking lot from a 50-story building. Every car in the lot would be splattered. Randy’s workbook does the same thing with its data. So do many other workbooks I’ve seen. [click to continue...]

{ Comments on this entry are closed }