Register Online - Add to Cart
Product ID: 407303EAU
 
Credit & Course Provided by:

Utilizing Excel® Dashboards for Effective Reporting

OnDemand Webinar (88 minutes)

Get a crash course on creating Excel® dashboards that help present your data.

In today's world, there is tons of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information. Many companies have reduced their IT staff, so more and more, it is up to each person to deal with all of this data. This material will show you how to take large amounts of data from many sources and process into great reports and user-friendly dashboards.

Authors

Tom Fragale, The PC Guy, Inc.

Agenda

Making Your Spreadsheets More Interactive - Classic Dashboards

• Sorts

• Filters

• Formatted Tables

• Slicers

• Total Row

• Charts

• Subtotal

• Groups

• Icon Sets

Interacting With Pivot Table Dashboards

• Drilldown

• Filters

• Slicers

• Timelines

• Pivot Charts

• Measures

• KPIs

Adding Controls to a Workbook for Extra Dashboard Effects

• Spin Button

• Combo Boxes

• Scroll Bar

• Check Boxes

• Command Buttons

• Option Buttons