My Shopping Cart
 
There are no items in your shopping cart.


How to Build an Excel 2010-16 Dashboard-Based Report-for HR Pros (IME518C)

Presented by: Mike Thomas
 
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
90 minutes
  •  Wed, May 9, 2018
Event Description
1.0 CPE

Create a Visually Stunning, Automatically Updating Dashboard

A dashboard is a critical communication tool, especially in any field where you must compile, track, evaluate, and present information to various stakeholders. Sound familiar? Like many HR professionals, you likely juggle data on a daily basis—probably with the help of Microsoft Excel. But are you harnessing its power and flexibility to create interactive, professional-looking dashboards? Start here.

Join IT business training expert and Excel master Mike Thomas for an easy-to-follow audio presentation on the basics of Excel dashboard-based reporting. Learn to create the fantastic, interactive, and automated visuals you need to enhance your everyday work. You’ll learn how to create pivot tables, filter data, automate dashboard elements, protect cells’ content, and make the dashboard maintenance-free when new data becomes available.

After attending this webinar, you will be well equipped to set up data sources, use pivot tables to summarize data, and improve your use of charts. You’ll have all the essentials you need to build your own dashboard-based reporting tools regardless of the Excel version you use.

Session Highlights

This training course on Excel (2016, 2013, 2010) will deliver best practices to:

  • Create and automate a dashboard
  • Set up data sources
  • Use pivot tables to drive the dashboard and summarize data
  • Improve visual communication using charts
  • Use formulas to create key performance indicator (KPI) summaries
  • Create interactive filters with slicers
  • Automate a dashboard with a simple macro task
  • Protect cells containing critical data from accidental changes

Who Should Attend

  • Any Excel 2010-16 user who wants to learn how to create Excel dashboards
  • Best suited to those with intermediate-level Excel knowledge and preferably those who know how to create a basic pivot table
About Our Speaker(s)

Mike Thomas | Microsoft Excel Technology Training SpeakerMike Thomas
Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with... More info

 
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
  •  
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: How to Build an Excel 2010-16 Dashboard-Based Report-for HR Pros
    Presenter(s): Mike Thomas

 
 
 
Our Accreditation Partners
DMCA.com Protection Status