Establishing Excel Dashboards | March 17, 2016 10:00 AM - March 17, 2016 1:00 PM | Automation.com

Establishing Excel Dashboards

Event Summary

DATE:
March 17, 2016
START DATE/TIME:
March 17, 2016 10:00 AM
END DATE/TIME:
March 17, 2016 1:00 PM
EVENT TYPE:
Training
HOST:
Online Compliance Panel
PHONE:
15108575896
EMAIL:
[email protected]
WEBSITE:
Click here to Visit

Description

Description
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.

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

Note: Use Promo code SMMSE and get 10% off on registration (Valid till March 31st)

MORE EVENTS

  • CCC Turbomachinery Optimization

    Four day Regional Training designed for Operations and Process personnel, Instrumentation Technicians, and Maintenance Engineers. Different aspects...

  • American Manufacturing Strategies Summit

    Join the industry leaders in exploring the latest technologies and strategies to improve turnaround times and create a more cohesive manufacturing...

  • Live Seminar: Light & Color Measurement - Seattle, WA

    Join Radiant Vision Systems in Seattle, Washington, on October 23 to discuss how to capture and utilize measurements of light and color that...

  • OMRON MACHINE SAFETY SEMINAR

    This seminar takes the Omron Machine Safeguarding Skill Builder (a $5,000 value), and turns it into a free, day-long event that will go over the...

  • LEAP HR: Manufacturing

    Break Away from Reactive HR to Rethink How You Find, Engage and Retain Front-Line Manufacturing Talent and Move from Marginal Gains to Radical Change

VIEW ALL

RELATED