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

Koenig-Solutions Logo

Intermediate Microsoft Excel

The Intermediate Microsoft Excel Certification is an accreditation that underlines proficiency in utilizing Microsoft Excel at an intermediate level.

by Koenig-Solutions [Claim Listing ]
VTeach Logo

Microsoft Access (Intermediate)

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.

by VTeach [Claim Listing ]
Ccisg Logo

MS Word Tips & Techniques

Despite the many alternatives that are out there, Microsoft Word remains one of the most popular word processors available. Such a popular tool should be easy to master, right?

by Ccisg [Claim Listing ]
G-Tec Computer Education Centre Logo

MS Power Point

MS Power Point course is offered by G-Tec Computer Education Centre for all skill level. Our aim to train people in different categories ranging from school level to corporate clients. All this factors would help to achieve our ultimate goal.

by G-Tec Computer Education Centre [Claim Listing ]
Aventis Learning Group (ALG) Logo

Microsoft Word Course

MS Words continue to play a prominent Role in people’s Professional & Personal lives. Having the skills to create amazing reports, edit perfectly, format & finalize impressive documents will improve your droductivity & will allow you to produce professional & polished documents.

by Aventis Learning Group (ALG) [Claim Listing ]

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