You have no items in your shopping cart.
Course Details
Topic 1 Data Visualization and Display using Excel Pivot Tables and Charts
- Data analysis using Excel pivot tables and charts
- Organize and visualize data to show trends and correlation
Topic 2: Create Basic Excel Dashboard and Scorecards
- Sketch your dashboard layout
- Link to Excel pivot tables
- Incorporate appropriate dashboard elements such as gauge chart, KPI
Topic 3 Create Interactive Excel Dashboard
- Form control, value-based formatting and dynamic series selection
- Animating changes over time
- Limitations of data and Interpretation of findings
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 18-65 years old
Minimum Software/Hardware Requirement
Software:
TBD
Hardware: Window or Mac Laptops
Job Roles
- Data Analyst
- Business Analyst
- Financial Analyst
- Operations Manager
- Marketing Analyst
- HR Metrics Specialist
- Sales Operations Specialist
- Report Developer
- Project Manager
- Management Accountant
- Product Manager
- Supply Chain Analyst
- Performance Metrics Specialist
- Market Researcher
- Business Intelligence Coordinator
Trainers
Jim Gan Chiu Liang: Jim Gan Chiu Liang is a ACTA certified trainer. Jim Gan Chiu Liang obtained his Master of Technology (M.Tech Knowledge Engineering) from National University of Singapore (NUS) Institute of System Science
He is currently working as adjunct trainer at PACE (Professional Adult Continuing Education) Academy, Singapore Polytechnic. His past experience included being a chief instructor for Kumon Education.
Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.
Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.
Dwight Nuwan Fonseka: Dwight Nuwan Fonseka is a ACLP certified trainer. He have a degree in Biotechnology from NUS, Advanced diploma in Pharmaceutical management from MDIS and Masters in Education from NTU. He have 8 years experience of teaching biology at O and A levels/ IB level in international schools in Singapore and overseas.
Dr. Alvin Ang: Dr. Alvin Ang is a ACTA certified trainer. Dr. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally.
Grace Saw: Grace Saw is an ACTA certified trainer and a Fellow member of ACCA with more than ten years of accounting experience including auditing, financial and management accounting, reporting, consolidation, budgeting, forecasting, taxation as well as financial planning and analysis in diverse industries such as manufacturing, technology, retail, services and hospitality. I am familiar with the FRS framework for Singapore and Malaysia. Besides, I hold a Master of Science in Professional Accountancy from the University of London, and can fluently read and write English, Chinese and Malay. I am an excellent team player and have good project management, problem-solving, multitasking, and interpersonal skills.
Customer Reviews (15)
- Ms saw show passion in sharing more tips Review by Course Participant/Trainee
-
more time is better (Posted on 8/21/2022)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
Hope to have an advanced course that goes through how to create dashboards using local data for local context like Singapore Map (Posted on 8/30/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
More exercises in the class I have attended a similar course earlier. Please don't repeat the course with different names (Posted on 8/30/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - I enjoyed my one to one class today :D Review by Course Participant/Trainee
-
I am quite blessed in the way that I am the only student in the class and I have one to one customised training rather than going through the areas I already know. Today’s class I go in depth to incorporated vba into dashboard and helps me a lot. (Posted on 5/11/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - might recommend Review by Course Participant/Trainee
-
Spend more time on topic 4 (Posted on 4/13/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 4/13/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Useful Review by Course Participant/Trainee
-
More practices (Posted on 4/13/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
The quiz at the end of the course and recap of the tenets is helpful to reinforce what has been learnt throughout the day. Good course. (Posted on 1/11/2021)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
Data used for hands on can be more corporate oriented. More time for hands - on on what was taught. (Posted on 4/26/2020)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Trainer v good Review by Course Participant/Trainee
-
Trainer v good n willing stretch to complete course material1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
No basic necessity like water. An old jug with no water. No blinds n the evening sun pierce in classroom making eyes pain looking at screen (Posted on 4/5/2020) - Will Recommend Review by Course Participant/Trainee
-
. (Posted on 6/11/2019)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Too ambitious for 1-day training Review by Course Participant/Trainee
-
Training is useful for its intended purpose. However, it is far too ambitious to fit all contents within 1 day with hands on practice.1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
In addition, the training center can be better prepared with the necessary software/hardware for the participants since this is an Excel training.
Finally, the refreshment and training environment is lackluster. (Posted on 11/16/2018) - Will Recommend Review by Course Participant/Trainee
-
Nil (Posted on 3/26/2018)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Might Recommend Review by Course Participant/Trainee
-
More hands on of Dashboard and the designing (Posted on 9/12/2017)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Might Recommend Review by Course Participant/Trainee
-
Please print correct slides next time :D (Posted on 9/12/2017)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
You May Be Interested In These Courses
WSQ - Statistical Data Analysis with Excel for Beginners
$350.00 (GST-exclusive)
$381.50
(GST-inclusive)
WSQ - Data Analytics and Visualization with Power BI
$800.00 (GST-exclusive)
$872.00
(GST-inclusive)
WSQ – Software Automation with Excel VBA Programming
$750.00 (GST-exclusive)
$817.50
(GST-inclusive)
