Manage Excel Spreadsheets with a Dashboard

Managers who work with more than a few Excel spreadsheets at a time won't have the time to drill down into each one. Worse, they won't know which spreadsheets to focus on, because a spreadsheet's file name gives no indication of how important that particular file is.

Excelential provides a way to place on a dashboard a summary of the key contents of multiple Excel spreadsheets. Thus, managers will be able to view all of the most important information without even fetching and opening each individual Excel file.

One Manager's Story

John is one of many mid-level managers in his “big box” retail corporation who receives 15 Excel spreadsheet reports a day. He complains that he has no time to read them all. There's simply too much else to read or do.

So, John only opens some of the Excel spreadsheets every 2 or 3 days. On the other days, he just assumes (or hopes) that there is nothing extraordinary or important in that day's report.

Unfortunately, Murphy's law always seems to hit at inopportune times. He finds himself getting "nasty" emails from VPs asking what he is doing to correct a potential problem that John was not aware of. And it turns out that he would have known about the problem ahead of the VPs, if he had read one of the spreadsheets that he didn't bother to open that day.

John wishes that there was a way to somehow see a "synopsis" or "summary" of the key contents of each of the 15 spreasheets on a single screen. Then, he would be on top of his entire operation. He wouldn't have to worry about getting another nasty email.

Managing spreadsheets from a dashboard

The required solution should let managers See all the key data and charts from their Excel spreadsheet files on one screen -- a dashboard. Then, they won't miss any important information, even if they don't open all the spreadsheets to look at the details. They can focus on the Excel spreadsheets that require analysis. They can see “the big picture” on the dashboard, and make decisions.

Another requirement is that managers can double-click on any of the charts or data on the dashboard, and work with the underlying Excel file. If the file is one that they receive regularly, the dashboard should always show the latest version. Managers shoudn't have to wonder whether they are working with the information from the most current version of an Excel report.

Excelential -- the quick, simple solution

Excelential ™ is a very low-cost program designed precisely to allow managers to manage all the Excel spreadsheets they work with, from a dashboard. It has a “copy from Excel, paste to dashboard” interface that is easily mastered by managers or their assistants. Users can combine summary data and charts from multiple spreadsheets on the dashboards.

Best of all, managers need to do that only once. From then on, Excelential ™ fetches new spreadsheets as they arrive, and updates the dashboards.

With Excelential ™, managers see the overall status of their operations immediately. And when they need to look at the detailed data behind the big picture, they just click on the appropriate dashboard object, and the full, detailed spreadsheet appears.