Utilizing Excel® Dashboards for Effective Reporting (OnDemand Webinar)

$99.00

SKU: 410709EAU

Description

Learn how to create a stunning, interactive, professionallooking dashboard using Excel.A dashboard is a powerful tool that enables users to present data in an interactive and visual way. Dashboards can help to transform raw data into meaningful insights, allowing users to make informed decisions based on key performance indicators. This presentation focuses on what you need to know to create an interactive professionallooking dashboard using Excel. You’ll learn how to create a stunning, interactive professionallooking dashboard using Excel. This topic will provide you with a solid foundation that you can use to build your own dashboards and reports.

Date: 2023-06-21 Start Time: End Time:

Learning Objectives

Best Practice for Setting Up Data Sources

Using Pivot Tables to Summarize Data

Visual Communication Using Charts

Using Formulas to Create KPI Summaries

Creating Interactive Filters With Slicers

Mike Thomas-theexceltrainer.co.uk

Utilizing Excel® Dashboards for Effective Reporting (OnDemand Webinar)

$99.00

SKU: 408402EAU

Description

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 userfriendly dashboards.

Date: 2021-01-15 Start Time: End Time:

Learning Objectives

Making Your Spreadsheets More Interactive • Classic Dashboards
• Sorts
• Filters
• Formatted Tables
• Slicers
• Total Row
• Charts
• Subtotal
• Groups
• Icon Sets

Interacting With PivotTable 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

CPE ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Tom Fragale-The PC Guy, Inc.

Utilizing Excel® Dashboards for Effective Reporting (OnDemand Webinar)

$99.00

SKU: 407303EAU

Description

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 userfriendly dashboards.

Date: 2020-04-02 Start Time: End Time:

Learning Objectives

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

Tom Fragale-The PC Guy, Inc.