EVENT IS OVER

Create and Use Excel Dashboards to Gain Valuable Business Insights

Thursday, May 11, 2017 at 11:30AM - 2:30PM
Fremont, CA

Event Details

Description
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.

This session with expert speaker Mike Thomas will help you create Excel dashboards, using Excel 2016 for Windows and leverage the power of data analysis to make critical business decisions. Note that much of the functionality available in Excel 2016 is also featured in Excel 2013 and 2010.

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
Who will Benefit
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.

For Registration
http://onlinecompliancepanel.com/webinar/USE-EXCEL-DASHBOARDS-507439/MAY-2017-ES-EZEVENT

Note: Use Promo code WE3PL and get 10% off on registration (Valid till MAY 31st 2017)

Organization Details

Online Compliance Panel (OCP) creates and delivers comprehensive industry relevant training sessions. These sessions are simple, interactive and cost effective. We are a predominantly web based information exchange forum. Live interactions on compliance training make the process holistic and effective. OCP largely emphasizes in offering regulatory compliance training to compliance professionals on varied topics. These primarily include risk management, quality management, corporate compliance and other regulatory compliances. Some of our primary areas of focus include advancement and updates in regulatory compliance, best practices and market trends.

We strive to incorporate high standards in developing a culture facilitating exchange of ideas resulting in functional excellence. OCP believes in nurturing ideas and thought processes through innovative e-learning methodologies. Our products and services are designed to offer customized solutions to industry and market. We bridge the gap between experience and knowledge thus delivering original and creative content.

Our objectives of employing interactive mediums ensure effective communication and mutual exchange of ideas. OCP closely follows best practices and regulatory trends in the global compliance scenario. We also observe and communicate trends witnessed in FDA, ISO regulations, process and design validation. All updates and additions to important laws can be accessed by our customers in real time.

Our mission is to empower compliance professionals through effective online training sessions. Our world class training methodologies stem from comprehensive understanding of client requirements. The content conforming to FDA and ISO standards is developed by well qualified and experienced industry leaders. Our offerings will exceed expectations and add value to your investment.

The content in various categories such as medical devices, pharmaceuticals and biotechnology will raise the bar in terms of quality already on offer .We hope to contribute to the creation of responsible organizations creating benchmarks in quality, integrity and transparency.

Online Event
38780 Tyson Lane, Apt 210
Fremont, CA 94536

Starts May 11, 2017 at 11:30AM - 2:30PM

Add to my calendar  

Contact Information

Organization: Online Compliance Panel LLC

Event Contact: OCP Panel

Phone: 15108575896