Excel Dashboard Sample: Weekly & Monthly Top-Ten Activity Reports

by Charley Kyd on October 24, 2009

When Chris Helfrecht sent these two sample Excel dashboards, he wrote that he tried to follow my methods. He also wrote that people in his company have been very enthusiastic about his new dashboards.

I recognized a lot of my ideas in his samples. I also found some new ideas. Some of these I like a lot, and some not so much. In future blogs, I’ll explain the details of his dashboard workbook, and suggest ways that I would change it.

For now, take a look at the two examples, and I’ll get into the details in the next post.

Top Weekly Transactions for a Medical Device Company. (Click to see a larger image.)

Top Weekly Transactions for a Medical Device Company. (Click to see a larger image.)

In case you missed the caption, you can click on either image to see a larger version. Then click your browser’s Back button to return to this page.

Top Weekly Transactions for a Medical Device Company. (Click to see a larger image.)

Top Monthly Transactions for a Medical Device Company. (Click to see a larger image.)

About the Excel Dashboard Author

Chris Helfrecht has worked in Finance for ten years and as an Oracle Developer for seven years.  He currently works as a Quality Systems Analyst for a large medical device company. He writes that Excel is a very useful tool for his purposes because  users aren’t afraid of it, and it offers excellent reporting features.

You can email him by correcting this address format: chrishelfrecht at hotmail dot com.

Comments on this entry are closed.

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

Next post: Excel Dashboard Sample: How to Structure Your Report Workbook