ComplianceOnline

Excel Dashboard 101 Time Saving Tactics

Instructor: David H Ringstrom
Product ID: 704751
  • Duration: 90 Min

recorded version

$129.00
1x Person - Unlimited viewing for 6 Months
(For multiple locations contact Customer Care)
Recorded Link and Ref. material will be available in My CO Section

Training CD

$249.00
One CD is for usage in one location only.
(For multiple locations contact Customer Care)
CD and Ref. material will be shipped within 15 business days

Customer Care

Fax: +1-650-963-2556

Email: customercare@complianceonline.com

Read Frequently Asked Questions

This Excel dashboards training session will help discover how to quickly assimilate large amounts of data using charts and summary tables. They will also learn a variety of ways to present information in dashboard form.

Why Should You Attend:

This webinar will focus on Excel dashboards. Attendees will discover how to quickly assimilate large amounts of data using charts and summary tables and learn a variety of ways to present information in dashboard form. They will also receive detailed handouts that serve as reference tools to fall back on after participating in the webcast and an Excel workbook that includes a majority of the examples the instructor uses during the session.

Learning Objectives:

  • Apply a variety of Excel features and worksheet functions--all focused on helping you use Excel far more effectively.
  • Define how to create “set-and-forget” tools that others can use to monitor financial results.
  • Identify methods you can use to bring data into Excel from other sources.
  • Recall how to create a dashboard that looks less like an Excel spreadsheet.
  • Define the time-saving benefits of Excel dashboards.
  • Identify how to use the PivotTable feature to condense large amounts of data.

Areas Covered in the Webinar:

  • Summarizing large amounts of data within Excel spreadsheets.
  • Creating interactive graphs with Excel’s PivotChart feature.
  • Learning how to use the Slicer feature in Excel 2010 and later.
  • Using Excel’s Custom Views feature to make a set of data to serve multiple purposes.
  • Discovering how to create self-updating links.
  • Using a simple macro technique to hide or unhide the Ribbon interface.

Who Will Benefit:

  • Banking
  • Finance
  • Insurance
  • Education
  • Telecom
  • IT
  • CPAs
  • CFOs
  • Controllers
  • Marketing
  • Sales
  • Investments
  • Pharmaceutical
  • Medical Devices
  • FDA
  • Aviation
  • Energy
  • Retail
  • Human Resource
  • Logistics and Supply Chain
  • Accountants
  • Audit

Instructor Profile:

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. Mr. Ringstrom’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees and users should about Microsoft Excel. His goal is to empower you to use Excel more effectively.

Follow us :
ComplianceOnline Banking Summit 2016 | Risk Management and Data Security - 80390SEM
ComplianceOnline Medical Device Summit 2017

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product! Write review

Best Sellers
You Recently Viewed
    Loading