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.
DurationThis 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)
Established in 2008, we have gone on to train over 20,000 people in over 500 companies. We received the Promising SME 500 Award 2013, and in 2015, we won the Gold Award for the “Best IT Training Provider” HR Vendors of The Year Award.
This workshop teaches learners basic digital presentation creation on Microsoft PowerPoint. Learners will be equipped with the necessary technical presentation-making skills required at the workplace.
This certification covers basic concepts such as creating slides, using templates, integrating multimedia, implementing transitions, and managing multiple presentations. Industries use PowerPoint for internal communication, training, business presentations, and sales pitches.
Outlook 2013 training is offered by Global Training Partners. University professors and national experts create our course curriculum.
This Microsoft Access Training Course is designed for beginners, assuming little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
This is a one-day hands-on course. The trainer will walk through the topic step-by-step. You will be provided with exercise files on every topic to effectively apply the tips and techniques taught. A short Q & A session will be available after each topic.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UAE, UK, USA, India and South Africa, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan