Microsoft Excel Dashboard Crash Course
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com
Instructor Profile
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlantabased 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-atLarge for Accounting WEB and Going Concern. David offers Excel training and consulting services nationwide.
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com
This webinar will provide an inside out training on the concept of dashboards in Microsoft excel and its advantages. Dashboards empower Excel users to condense large amount of information into easy to read summaries while preserving the ability to dive deep into the details when needed. The speaker David H. Ringstrom will discuss about using Microsoft Query to set up automated connections to databases, text files, or even other Excel spreadsheets. He will also introduce you on the different techniques for presenting information in dashboard-form.
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com
Why should Attend Attend this webinar to learn how to use features in Excel that minimizes both data integrity risks and spreadsheet maintenance. It will also help you discover the nuance in Excel where the wrong choice of workbook format can disable key features. .
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com
Objectives
Create set-and-forget links to text files exported from other programs, such as accounting package. Connect your spreadsheets to text files, Microsoft Access or SQL databases by way of Microsoft Query How Pivot Tables are a key addition to an Excel dashboard, and how the drill-down feature allows users to view additional detail on demand. Explore the Spark lines feature available in Excel 2010 and later, as well as a free add-in that enables this functionality in Excel 2007 and earlier. How the Slicers feature in Excel 2010 and later can enhance dashboard functionality by enabling users to update multiple pivot tables at once.
Who can Benefit Accounting and Finance Personnel CFOs Controllers
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com
How this Webinar works Username and Password will be sent to you 24 hours prior to the webinar Presentation handouts in pdf format will be mailed to you Login to the session using the username and password provided to you Get answer to your queries through interactive Q&A sessions via chat
Track this link : MS Excel Online Training
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com
Connect with Us Online Compliance Panel
www.onlinecompliancepanel.com | 510-857-5896 | customersupport@onlinecompliancepanel.com