Experiment in Excel with Sample Census Data

Excel

Creating sample data files to experiment with in Excel is about as much fun as weeding the lawn. So to give you a little more time in your day here’s a link to an inflation adjusted census file used in dashboard examples in the book. If you want to change the data so it looks […]

Read More

Creating Cascading Drop-Down Menus in Excel

Excel

What do you do when you want to give users the ability to select from 20 or more choices in an Excel drop-down or combo box? Even giving them more than 12 in a drop-down menu can get messy and it increases the chance of a data entry error. When you have long lists or […]

Read More

Beware of Excel and Complex PDFs

Excel

Warnings on Using Adobe Acrobat I’ve only written 26 technical/business books and done performance consulting for 30+ years so you’d think I’d know better by now to do more extensive testing before writing about something. But in “Balanced Scorecards and Operational Dashboards with Microsoft Excel” I wrote about using Adobe Acrobat to use PDF files […]

Read More

Balanced Scorecards – 28% ROI Increase

Frameworks and Processes

This long term study by two independent professors matches companies that use Balanced Scorecards against those that don’t. Across 42 matched pairs of companies those using a Balanced Scorecard increase their financial performance by approximately 28%, but it doesn’t happen right away. It comes up once in a while. You might be swapping business stories […]

Read More
1 19 20 21