Microsoft Excel Dashboard Crash Course Webinar
Time: 10:00 AM PDT | 01:00 PM EDT
Duration: 120 Minutes
Instructor: David H. Ringstrom
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.
In this session David teaches from Excel 2010. The techniques shown work in the same fashion in Excel 2007 and 2013, and his handouts include alternate instructions for Excel 2003 where applicable. Certain features discussed in this presentation, namely Microsoft Query, are not available in Excel for Mac.
Why Should you 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. This webinar will also help you to learn alternatives to manually copying and pasting data that you can manually compile into reports, summaries, and charts.
Objectives of the Presentation:
The key objectives of the presentation are as follows:
- 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 Sparklines 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.