What is Spreadsheet Dashboard Tools?
Spreadsheet Dashboard Tools is an add-in software for Microsoft® Excel® which helps you to understand complex relationships in your Excel models. With Spreadsheet Dashboard Tools you can use Sparklines, Heatmaps, Minicharts, Bump charts and Special charts, getting dramatically improved data visualization for fast and effective parallel comparisons.
Intuitive Interface – New Ribbon
Spreadsheet Dashboard Tools has been created based on Excel native graphics, they can be personalized using all the styles and formats that Excel offers to enrich its presentation.
As it´s been constructed over Excel´s own graphics, it is not necessary to install fonts or any additional requirements to be able to visualize the graphics and distribute them so you won´t have the disadvantage of waiting for the graphics to recalculate whenever the data is modified.
You have six options for graphics. First; you have the possibility of adding resized Sparklines to the size of a cell in order to make a fast analysis of your data. Second; use Traffic Lights to get an visual and fast alarm about the status in a cell, Third; you can insert Heatmaps and icons in order to analyze your data up to 5 dimensions, Fourth; also you have Minicharts that are optimized size graphics which allow a suitable representation of greater amounts of data for dashboards, Fifth; see changes in your data immediately withBump charts, Sixth; also you will have other Special charts available to enhance the visualization of your reports.
Sparklines
|
|
Minicharts
|
|
Traffic Lights
|
|
Heatmaps
|
|
|
Bump charts
|
|
|
Special Charts
|
|
Audit Tools
|
|
Spreadsheet Dashboard Tools is TOTALLY COMPATIBLE WITH EXCEL 2010 and MICROSOFT WINDOWS 7 (32 and 64 bits) !!!
Benefits
- Quick visualization and analysis of complex reports thanks to the charts: Sparklines, Bump charts, icons, and Minicharts.
- When using native Excel functions, it does not require installation of additional fonts or tools to share your reports.
- How you can insert Heatmaps and Traffic Lights.
A Heatmap is a graphical representation of data where the values taken by a variable, in a two-dimensional (or more) map, are represented as colors, size, background, etc.Traffic Lights is a sort of Heatmap but more specific to get a visual and fast alarm about the status in a cell.
- 12 special chart types available, which are not included in Excel, to expand the range of possibilities for data visualization.
- Analyze your models with the Audit Panel quickly and easily.
- With only a few clicks manage names and links of your models using these tools: Link Manager y Names Manager.
- Import SQL data to your Excel spreadsheet without the need to have knowledge about programming.
- Take advantage of the power about Spreadsheet Dashboard Tools’ integration with access to Excel data, creating fully updateable reports from the website (watch video).
- You could also generate a report with external data sheet. This sheet can be in the same workbook, in another book, in a database or in a web page.
- Thanks to its internal structure and encoding Spreadsheet Dashboard Tools allows you to categorize databases in Excel or large pieces of data using dynamic tables.
- Full integration with our next service XYNCHRO (Full synchronization among Microsoft Office applications and web connectivity)
- Continuous Update.
- Right to 1 year of updates.
- Fully compatible with Office 2007, 2010
- Fully compatible with Windows 32 and 64 bits.
COMPARISON WITH MICROCHARTS
Who needs this Software?
Any type of user that uses Microsoft Excel for his/her projects. It can be used by:
- Financial analysts
- Engineers
- Biologists
- Mathematicians
- Economists
- Teachers
- Students in general
- Scientists
- Any person who uses Excel in the decision making process and wishes to explore his model’s possibilities.