Secret Hacks of Excel Data Analytics for PMET

Secret Hacks of Excel Data Analytics for PMET

You can benefit from the course in 2 ways, upgrade your Excel skills and acquire data analytics skills. With these 2 skills, you are going to be an employee sought after by many organizations.

Who Should Attend

This course is designed for those who are currently working in

  • Sales, Marketing, 
  • Supply Chain, 
  • Finance,
  • HR and/or
  • running your own business.

An intermediate level of Excel skills is recommended. Some experience in Pivot Table is highly recommended.

Learning Objectives

Upon completion of the course, participants will be able to:

  1. Use Excel for data analytics
  2. Identify trends and patterns through data analytics
  3. Interpret results using data analytics methods.
  4. Share your analysis through data storytelling

Course Outline

  • Discover what you could already know about Data Analytics
  • Analyze your data in a systematic way
  • Differentiate the 4 ways you can apply data analytics to your job
  • Discover how you can identify patterns and trends in Pivot Table
  • Learn the easier way to combine two worksheets without using VLOOKUP
  • How to automatically convert your data into useful reports with a one-time setup
  • Collating information from multiple files with this secret function in Excel
  • How to confidently analyze big data and appear like an expert
  • How to wow your audience with data storytelling

Program Dates

  • 04 – 05 Mar 2024 (Mon – Tue)
  • 09 – 10 May 2024 (Thu – Fri)
  • 01 – 02 Aug 2024 (Thu – Fri)
  • 28 – 29 Oct 2024 (Mon – Tue)

Mode of Delivery

  • Face-to-Face

Course Duration

  • 2 days (8 hours each day) – 9 am to 6pm


Course Fee before Training Grant: S$1000

Course Fee after Training Grant (SMEs): From S$300 per pax (Amount is before SFEC and absentee payroll)

Course Fees after Training Grant (Individual >= 40 yo): From $300 per pax (Amount is before SFC)

Course Fees after Training Grant (Individual <40yo): From $500 per pax (Amount is before SFC)

Funding available for this course:

SFEC/Absentee payroll/Course fee grant/ETSS/MCES/SFC/WSS Absentee payroll

Registration and Enquiry

SHEDA Enquiry