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.
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.
AREA 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
LEARNING OBJECTIVES
- 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
WHO WILL BENEFIT?
- Accountants
- CPAs
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.
- 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
- 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
- Accountants
- CPAs
Speaker Profile
David H. Ringstrom
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.
Upcoming Webinars
Bootcamp for New Managers and Supervisors: Avoid These 7 Mi…
By:Marcia Zidle
Nov. 30, 2023
10:00 AM PDT | 01:00 PM EDT
Strategic Interviewing & Selection: Getting the Right Talen…
By:Pete Tosh
Nov. 30, 2023
12:00 PM PDT | 03:00 PM EDT
Conflict Resolution in a Remote Workplace
By:Natasha Nurse
Nov. 30, 2023
10:00 AM PDT | 01:00 PM EDT
2-Hour Virtual Seminar on How to Conduct an Internal Harass…
By:Dr. Susan Strauss
Dec. 1, 2023
12:00 PM PDT | 03:00 PM EDT
Workplace Investigations 101: How to Conduct your Investiga…
By:Dr. Susan Strauss
Dec. 4, 2023
10:00 AM PDT | 01:00 PM EDT
Cleanroom, Microbiology and Sterility Assurance Practices f…
By:Kelly Thomas
Dec. 4, 2023
12:00 PM PDT | 03:00 PM EDT
5 Key Components of Good Manufacturing Practices to obtain …
By:Meredith Crabtree
Dec. 5, 2023
12:00 PM PDT | 03:00 PM EDT
Successfully Negotiating the Labor Agreement
By:Gerry McLaughlin
Dec. 5, 2023
12:00 PM PDT | 03:00 PM EDT
Understanding the incredible uses and fallbacks of ChatGPT
By:Justin Muscolino
Dec. 5, 2023
10:00 AM PDT | 01:00 PM EDT
Wage And Hour Laws: Ensuring Compliance With The Fair Labor…
By:Diane L. Dee
Dec. 5, 2023
10:00 AM PDT | 01:00 PM EDT
How to Manage Conflict in the Workplace
By:Susan Schoenfeld
Dec. 5, 2023
10:00 AM PDT | 01:00 PM EDT
Neutralizing Harassment - How to Promote the Proactive Pers…
By:Beverly Beuermann-King
Dec. 5, 2023
12:00 PM PDT | 03:00 PM EDT
Human Error Reduction Techniques for Floor Supervisors
By:Ginette M. Collazo
Dec. 6, 2023
10:00 AM PDT | 01:00 PM EDT
Hybrid Workplace: 10 Best Practices to Manage Your Team’s P…
By:Marcia Zidle
Dec. 6, 2023
12:00 PM PDT | 03:00 PM EDT
Using Better Managerial Decision Making - to get great resu…
By:Bill Straubinger
Dec. 6, 2023
12:00 PM PDT | 03:00 PM EDT
Changing Behavior: Why Rewards and Punishments Often Aren't…
By:Rebecca Staton-Reinstein
Dec. 6, 2023
12:00 PM PDT | 03:00 PM EDT
Excel - Pivot Tables - The Key To Modern Data Analysis and …
By:Mike Thomas
Dec. 7, 2023
10:00 AM PDT | 01:00 PM EDT
Using Stay Interviews To Improve Employee Retention & Engag…
By:Pete Tosh
Dec. 7, 2023
12:00 PM PDT | 03:00 PM EDT
Form W-9 Compliance to Avoid Penalties: TIN Verification, B…
By:Patrick Haggerty
Dec. 7, 2023
12:00 PM PDT | 03:00 PM EDT
Using High-Performance Coaching for Managers to Address Per…
By:William J. Rothwell
Dec. 7, 2023
12:00 PM PDT | 03:00 PM EDT
FDA Technology Modernization Action Plan (TMAP) and Impact …
By: Carolyn Troiano
Dec. 12, 2023
10:00 AM PDT | 01:00 PM EDT
FDA Audit Best Practices - Do's and Don'ts
By: Charles H. Paul
Dec. 12, 2023
10:00 AM PDT | 01:00 PM EDT
Stay Interviews: A Powerful and Low-Cost Employee Engagemen…
By:Marcia Zidle
Dec. 13, 2023
10:00 AM PDT | 01:00 PM EDT
Become an excellent Critical Thinker to greatly improve you…
By:Bill Straubinger
Dec. 13, 2023
10:00 AM PDT | 01:00 PM EDT
Learn the Do's and Don'ts of Opening Business Bank Accounts
By:Justin Muscolino
Dec. 14, 2023
12:00 PM PDT | 03:00 PM EDT
Project Management for HR, Administrative Professionals, an…
By:Rebecca Staton-Reinstein
Dec. 15, 2023
12:00 PM PDT | 03:00 PM EDT
Writing Effective 483 and Warning Letter Responses
By:Kelly Thomas
Dec. 19, 2023
12:00 PM PDT | 03:00 PM EDT
Dealing With Difficult People In Life & Work
By:Paul J. Cline
Dec. 19, 2023
10:00 AM PDT | 01:00 PM EDT