Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Creating Dashboard Components in Microsoft Excel 4173378W
Register View Registrations Tell a Friend About This EventTell a Friend
 

Many organizations are looking for ways to communicate important information to people that are both inside and outside of the company. One way to do so is to create Dashboard objects in Excel that present data in an understandable and concise manner. Excel features such as charts, conditional formatting, tables and table slicers, and form controls can all be used by those creating dashboards.

 Export to Your Calendar 2/13/2018
When: 7:30 AM to 11:00 AM
Where: Webinar/Webcast
United States
Presenter: Karl Egnatoff, CPA
Contact: April Deneault
801-466-10947


Online registration is available until: 2/13/2018
« Go to Upcoming Event List  

Curriculums:   Computers and Technology

NASBA Credit Category:  Computer Software and Applications

CPE Hours:  4

Description

Many organizations are looking for ways to communicate important information to people that are both inside and outside of the company. One way to do so is to create Dashboard objects in Excel that present data in an understandable and concise manner. Excel features such as charts, conditional formatting, tables and table slicers, and form controls can all be used by those creating dashboards. This session shows how and why to use these tools as well as how they can work together to make Excel an interactive data display medium that is both powerful and easy to use!



Major Subjects

  •    The power of Excel tables
  •   Sorting and filtering tools
  •   Bringing in external data
  •   Charting in Excel
  •   Adding form controls to enhance dashboard objects

Objectives

 Once participants have completed this session they should be able to:

  •  Understand what Excel tools can be used to build dashboard components
  •  Add constructs such as tables, table slicers, cell formatting, conditional cell formatting, charts, and form controls
  •  Create a variety of dashboard objects that allow for end user interaction and effectively present information

Level:  Intermediate

Designed For

 Accounting and other business professionals that would benefit by understanding the many important steps needed to implement new control measures

Advanced Prep:

 None

Prerequisite

 An understanding of Excel conventions

Membership Management Software Powered by YourMembership  ::  Legal