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 story telling

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

  • 06-07 Mar 2023 (Thu and Fri)
  • 15-16 May 2023 (Mon and Tue)
  • 13-14 Jul 2023 (Thu and Fri)
  • 07-08 Sep 2023 (Thu and Fri)

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


If you need further clarifications, please send us a message using the form here and we will reply you ASAP.

AI Chatbot Avatar
⚠️ Welcome to our chatbot! Please note that this chatbot is designed to provide general information about our Excel and Power BI courses, and should not be relied upon as legal or financial advice. Any personal information collected by the chatbot will be handled in accordance with our privacy policy. By interacting with the chatbot, you agree to our terms and conditions.