CONNECT WITH US!

(02) 8616 8079

0917 113 1154

Head Office: 6F Salustiana D. Ty Tower Paseo de Roxas cor. Perea St. Legaspi Village, Makati City

Philippines

Training Center: 5F National Life Insurance Company Building, 6762 Ayala Avenue, Makati City Philippines

© 2016-2017 Phoenix One Knowledge Solutions, Inc.

Creating Dashboards with Microsoft Excel

DURATION: 16 hours (2 days)

Prerequisites

Participants who want to attend this training should have at least an intermediate knowledge in Microsoft Excel with familiarity in logical, lookup, and text functions. 

Course Description 

Course Description 

This instructor-led advance course on Creating Dashboards with Microsoft Excel is intended for Intermediate to Advance Excel participants who want to discover different techniques on Dashboarding. Many companies are turning to constructing dashboards in Excel due to the lower cost, shorter development time and because of Excel's exceptional capabilities.

 

In this course, you will learn the basic to advance concepts of designing a dashboard. Learn how to use Microsoft Excel to develop sophisticated dashboards using different development controls. Comprehensively combine charts, pictures, tables, cells and controls then provide a dynamic interaction to create a powerful and seamless high-level report. 

Course Objectives

At the end of this course, the participant should be able to: 

 

  • Know the basics of creating a Dashboard.

  • Know the Benefits and Advantages of a Dashboard.

  • Familiarize Different Types of Dashboards.

  • Design and Layout Dashboard using MS Excel.

  • Develop Interactive Dashboard.

  • Create Dynamic Charts.

  • Use interactive Developer Controls.

  • Design, Layout and Secure Sheets for Visual Interaction.

 

After the completion of this course, participants will be able to properly design their dashboard in Excel and make it a self-service visual business intelligence application for stunning high-level reports. 

Who Should Attend

Finance or accounting executives, data scientists and analysts, marketing analysts, business managers and any professional who deal with generating reports and would like to create a graphical representation of these reports using the power of Microsoft Excel.

Course Content

  • Introduction to Dashboards.

  • Developing and Designing Dashboards.

  • Data Structures.

  • Advance Excel Formulas for Dashboarding.

  • Designing Charts and Statistic Dashboards.

  • Dynamic and Interactive Dashboards.

  • Navigation and Finalizing Dashboards.

  • Practice and Workshop.