Description

Dashboard reporting is rapidly becoming the norm for organizations seeking to improve financial and operational reporting processes. Dashboards allow recipients easy access to mission-critical data, usually in an on-demand environment, thereby allowing users to get the information they need when they need it. With greatly enhanced charting and graphing capabilities, along with the ability to handle much larger volumes of data, Excel is an ideal tool for creating high-impact dashboards in businesses of all sizes. In this course, learn how to build Excel-based dashboards that extract information from your accounting application along with other databases and to present this data as actionable information in a dashboard setting.

Key topics covered in this course include extracting and summarizing data stored in various databases; charting and graphing data, including specialized charts and graphs such as tachometer gauges and thermometer charts; identifying and highlighting trends in data; distributing dashboard reports throughout the organization; and using Excel add-ins such as Xcelsius and BizExcelerator to enhance the dashboard reporting process.

Don't miss this chance to learn how to create and implement Excel-based dashboard reports as a means of improving the financial and operational reporting processes in your organization.

Highlights

Creating and implementing Excel-based dashboard reports to improve the financial and operational reporting processes in your organization

Objectives