Building Dynamic Dashboards For Business Intelligence With EXCEL

by Impress Training Claim Listing

This is a case study-based course. The course will train participants how to create dynamic dashboards using Excel lists or data downloaded from external database, how to create relationship between two tables.

S$820

Contact the Institutes

Fill this form

Advertisement

Impress Training Logo

img Duration

2 Days

Course Details

This is a case study-based course. The course will train participants how to create dynamic dashboards using Excel lists or data downloaded from external database, how to create relationship between two tables.

How to use advanced Excel built-in functions and reporting features to enhance user interactivity with the dashboard, how to build and manage an efficient data model that feeds the dashboard with updatable business data, and also how to use Macro to manipulate charts and tables, compute and update formula results automatically.

At the end of the course, a case study related to the topics learned will be given. Participants will have chance to discuss the case study scenario and come out with the solution.

This case study helps participants to have better understanding of the topics learned and know how to apply the skills in their work. Model answers of the case study and samples of Excel worksheets will be given to participants for reference and revision after the course.

 

Prerequisite:
You should be a confident Excel user who has experience in using and maintaining Excel reports and be able to create Excel table-driven reports and charts. A pre-requisite questionnaire will be provided to you to ensure the suitability and level is right for you.

 

Notice:
The course will actively be using Excel 365 subscription version. It will be running and taught based on the PC Windows software and not Mac versions. (All Laptops and materials will be provided)

  • Central Branch

    8 Burn Road, Central

Check out more MS Excel courses in Singapore

Coursemology Logo

Advanced Microsoft Powerpoint 2016

Advanced Microsoft PowerPoint Course is a certification programme for learners who wish to create effective, high-impact presentations using advanced features and who need to be able to prove their skills in this area.

by Coursemology [Claim Listing ]
Intuition International Logo

Microsoft MS PowerPoint and MS Word (2013, 2016, 2019 and 365) for Office and Business Presentation

Our instructors are exclusive to us and we only engage excellent instructors to ensure all learners meet their individual needs and receive quality teaching. Our curriculum is unique and they include exercises to help participants retain knowledge for long-term use.

by Intuition International [Claim Listing ]
NobleProg (Singapore) Logo

Fundamentals Of Microsoft Office

This instructor-led, live training in Singapore (online or onsite) is aimed at anyone who wishes to learn and use the software and services available in the MS Office suite to enhance their work productivity.

by NobleProg (Singapore) [Claim Listing ]
St.Hua Private School Logo

Microsoft Excel Essentials

Microsoft Excel is a powerful yet user-friendly spreadsheet software. In this course, you will learn how to input and organize data, use functions to perform calculations, format the appearance of your data and cells, and build stunning charts and PivotTables.

by St.Hua Private School [Claim Listing ]
COMAT Logo

ICDL - Documents (Microsoft Word 2016)

The Word Processing module allows candidates to demonstrate the ability to use a word processing application to accomplish everyday tasks associated with creating, formatting, and finishing word processing documents, such as letters and other everyday documents.

by COMAT [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy