Creating Dashboards with Microsoft Excel

Greenbelt Mansion, Perea, Legazpi Village, Makati, Metro Manila, Philippines

Description

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 

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 DETAILS  :

DATE  : January 21-22, 2022, March 11-12, 2022, May 17-18, 2022,
DURATION: 16 hours (2 days)

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. 

REGISTER FOR THE COURSE

Add A Review


Please enter input field

Book your course now

Enquiry

Your enquiry submitted successfully

Enquiry Submission failed

Please enter input field(s)

Claim this course

To manage this course details kindly claim this course.