Find Seminars by Online Compliance Panel and others

(800) 349-1935

 

 

Create and Use Excel Dashboards to Gain Valuable Business Insights Webinar  

By:

Online Compliance Panel

Create and Use Excel Dashboards to Gain Valuable Business Insights Webinar seminar agenda print utility

dates/locations

For:

This webinar is for any user of Excel who wants to learn how to create Excel dashboards. You should have an intermediate level of Excel knowledge including an understanding of how to create basic pivot tables.

Cost:   

Visit FindaSeminar.com for seminar cost, group discount etc.

Seminar Summary:

Dashboards and reports are a critical tool in your communication armoury. A well-designed and meaningful dashboard offers a CEO, shareholder or Project Manager a valuable insight into the Key Performance Indicators (KPI's) upon which a business or project is measured and enables them to determine the future direction of the business or project. (see full course description)

 

View dates/locations for this event on FindaSeminar.com then register online or call (800) 349-1935

 
 

Training Course Syllabus:


Objectives of the Presentation


  • Planning your dashboard

  • Integrating multiple data sources in your dashboards

  • Using Pivot Tables to create KPIs summaries

  • Enhancing your dashboard with user interaction

  • Visual communication using charts

Why Should you Attend

Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, its flexibility and the fact that most people have it installed on their computer or mobile device.


Excel dashboard skills are in high demand, with the growing importance of Business Intelligence (BI). The use of dashboards as a display tool is a hot topic right now and consequently being able to create them is a must have skill for the serious Excel user.


There´s no "create a dashboard" command in Excel. Creating a dashboard involves using a combination of tools that are built-in to Excel.

Areas Covered


  • Working with data sources

  • Using Pivot Tables to create summaries

  • Displaying the "Top X"

  • Visual communication using charts

  • Using formulas to create KPI summaries

  • Adding user interaction to your dashboard

  • Creating interactive filters with Slicers


Seminar Summary:

Dashboards and reports are a critical tool in your communication armoury. A well-designed and meaningful dashboard offers a CEO, shareholder or Project Manager a valuable insight into the Key Performance Indicators (KPI's) upon which a business or project is measured and enables them to determine the future direction of the business or project. (see full course description)

 

Findaseminar.com seminars and training FindaSeminar.com is a member of the Seminar News Network and Training News Network Copyright 2008-2014.

FindaSeminar is a registered Trademark of FindaSeminar.com a division of Allied Internet Solutions Inc.