Excel Dashboards for CFOs & Finance: Effective Monitoring & Reporting
Excel Dashboards are a powerful and adaptable tool to quickly combine large and complex financial data into a dynamic and easy-to-read format. Dashboards enable CFOs and financial managers to clearly communicate pertinent information for effective decision making.
Learn the skills to turn complicated financial data into clear and concise reports for your CEOs, managers, consultants and board members. Join us for this interactive, 100-minute webinar to discover how to:
- Link spreadsheets to other programs like MS Access, SQL databases & text files
- Utilize Pivot Tables and Pivot Charts to summarize key data
- Review information at a high level, while keeping detailed information only a couple mouse clicks away
- Use dashboards to clearly communicate metrics to non-financial audiences
Program Highlights
Excel Dashboards: Arranging your Data into Clear Charts & Tables
- Discover the power of self-updating chart titles
- Techniques to bring data into Excel from external sources
- Creating dynamic visual presentation: Slicers, Sparklines & more
- How to create a single worksheet that performs multiple tasks
Pivot Tables & Dashboards: Techniques to Present Data At-a-Glance
- Drill down for the raw information: How to access additional detail
- Avoid common pivot table conflicts by using linked pictures
- Set-and-forget links: How to export text files from other programs
- Jump start dashboards with the Recommended Pivot Tables and Analyze Data features
Tools to Enhance the Dashboard Functionality: Key Features & Techniques
- Slicers and Timelines: More efficient ways to filter your PivotTable data
- Self-expanding data ranges: References for graphs, tables, & formulas
- Visually presenting your information in dashboard form
About the Speaker
David H. Ringstrom, is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started back in 1991.
- He is an author, Microsoft Excel spreadsheet expert, and consultant.
- David teaches over 200 live webinars on Excel each year, and has written articles on spreadsheets that have been published internationally. He is the co-author of “Idiot’s Guide: Introductory Accounting” and has served as the technical editor for dozens of books in the “QuickBooks for Dummies” series.
- Attendees often speak highly of David's well-prepared handouts that provide numbered steps that you can follow to carry out the techniques that he presents during his webinars.
Program Benefits
In this 100-minute webinar you'll discover how you can create impressive and interactive Excel dashboards to present financial information to decision makers. Effectively monitor key information in a way that anyone can understand.
SHRM Credits
Premier Learning Solutions is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CP® or SHRM-SCP®. This program is valid for 1 PDCs for the SHRM-CP® or SHRM-SCP®. For more information about certification or recertification, please visit www.shrmcertification.org.
HRCI Credits
This program has been approved for 1 (HR (General)) recertification credit hour toward aPHRTM, aPHRiTM, PHR®, PHRca®, SPHR®, GPHR®, PHRiTM and SPHRiTM recertification through the HR Certification Institute. Learn more at hrci.org
Purchase this On-Demand Workshop
Excel Dashboards for CFOs & Finance: Effective Monitoring & Reporting
$199 + applicable taxes
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
$300 + applicable taxes
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
$699 + applicable taxes
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
$899 + applicable taxes
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Full-Team Pass
Simply share the invite link with your team so you can learn and grow together!
Yours Forever
The event recording and materials are yours to rewatch and share as you choose.
