Getting Better Information, Now!
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 2007 is an ideal tool for creating hi-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 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.
Course Information:
CPE Credit: Recommended 4 Hours Specialized Knowledge and Applications
Instructional delivery method: Group-live demo and discussion using color computer projection - NOT a hands-on course
Prerequisites: None
Program level: Advanced
Advanced preparation: None
Designed for: Accountants who want to learn how to use Excel to create dashboards
Who should attend: Accountants in all facets of the profession seeking to improve financial reporting processes
Course Highlights:
- Dashboard fundamentals
- Advanced Excel charting and graphing techniques
- Learning how to use third-party products such as Xcelsius to create dashboards
- Extracting dashboard data through ODBC queries
- Distributing dashboard reports throughout an organization
Dates & Locations:
