With Microsoft Certified Trainer
Dashboards are very popular in the business world at the moment. They contain lots of information, sometimes dynamic, on one page, so that people have access to a vast array of information without the need to juggle between documents.
Why use Excel For Dashboards?
Excel has at least five features that make it an outstanding application for dashboard reporting:
Excel can produce magazine-quality reports & charts. It provides ideas for colour schemes, fonts, and designs for charts and tables.
Excel flexibility applies to dashboards as well. Using Excel, you can replace one chart with another, add a new column of data, change a color, add a second page, or use a bigger font.
Excel reports often present complex ratios, statistical calculations, and other sophisticated results that could be displayed very effectively in a dashboard.