Establishing Excel Dashboards

Duration: 120 Minutes
Excel expert David H. Ringstrom, CPA, introduces participants to Excel dashboards in this illuminating live webcast. Because dashboards empower users to quickly assimilate large amounts of data by way of charts and summary tables, they are quite popular.
In the first part of his presentation, David using Microsoft Query to automate the import of data from a variety of sources, including text files, other spreadsheets, databases, and software programs. He then demonstrates a variety of techniques for presenting the information in dashboard form.
Excel Dashboards
Instructor: David H. Ringstrom
Product ID: 501227
Objectives of the Presentation
  • Identify ways to use Excel dashboards to quickly assimilate large amounts of data
  • Turn off Excel features to make dashboards that look less like an Excel spreadsheet
  • Apply the Slicer feature in Excel 2010 and later to filter data faster and see at a glance what data is being hidden from a dashboard
  • Use Pivot Tables and Pivot Charts to create interactive reports
  • Identify and manage data security prompts that can arise when connecting Excel spreadsheets to other data sources
  • See the nuances involved in formatting numbers within pivot table reports
  • Discover features that become disabled within Excel 2003(.XLS) workbooks
  • Use Sparklines to present charts within worksheet cells
Why Should you Attend
Learn a variety of techniques for presenting Excel data in dashboard form and how to quickly assimilate large amounts of data within charts and summary tables. David's courses are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants' questions, so come ready to pick his brain. His detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. In addition, he provides an Excel workbook that includes a majority of the examples he uses during each session.

David's materials cover Excel 2016, 2013, 2010, and 2007. He typically demonstrates techniques by using Excel 2013 or 2016, but is able to perform live demonstrations upon request in Excel 2010 and 2007 as well.

Areas Covered
  • Implementing the Slicer feature in Excel 2010 and later
  • Creating dynamic and interactive graphs with Excel's PivotChart feature
  • Using Microsoft Query to create self-updating links to databases, spreadsheets, text files, and other data sources
  • Learning why certain features, such as Slicers, Sparklines, and even charts, are disabled in some workbooks
  • Creating dashboards that look less like an Excel spreadsheet by hiding screen elements
  • Moving beyond worksheet column restrictions using the Paste Picture Link feature to easily present data from various sections of a spreadsheet all in one place
  • Condensing large amounts of data into manageable chunks
  • Expanding or collapsing data with Excel's Group and Ungroup feature
Who can Benefit
  • Accountants
  • CPAs
  • CFOs
  • Financial consultants
  • Controllers
$300
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $450.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $550.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents dozens of webinars annually on Excel and other topics. He has written numerous articles on spreadsheets, some of which have been published internationally. He has served as the technical editor for other 30 books on accounting software, and is the Tech Editor-at-Large for Accounting WEB and Going Concern. David offers Excel training and consulting services nationwide.
View More