New user? Register as member

Secret Hacks of Excel Data Analytics for PMET

This course is an upgrade from Hidden Secrets of Data Analysis in Excel. The course will train you on the new Data Analytics functions added recently to Microsoft Excel and show you how to make use of them effectively for Data Analytics.

At the end of the course, you will be able to confidently apply data analytics skills to your job and add value to your organization. At the same time, you will be the first to learn how to use the new functions in Excel to work 90% faster.

Course code: TGS-2022010867

Course run code: 478634

Course Fee before Training Grant: SGD1000 (nett)

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)

SSG Grant
SSG funding for SSG-supported certifiable course to promote a culture and holistic system of lifelong learning through the pursuit of skills mastery, and strengthen the ecosystem of quality of education and training in Singapore. View more

SkillsFuture Credit
SkillsFuture Credit aims to encourage individuals to take ownership of their skills development and lifelong learning. View more

Objective

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

Outline

Who should attend

This course is targeted to those who are currently working in

• Sales, Marketing,
• engineers in different fields
• data analyst
• QR staff
• Supply Chain,
• Finance,
• other technical staff
• HR and/or
• running your own business.

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

Methodology

This is a two-day hands-on course.

Profile of Jason Khoo

Jason Khoo is a Microsoft Certified Trainer (MCT), ACTA certified trainer of 20 years. He is a Microsoft Certified Power BI Data Analyst Associate and a data analytics practitioner of 30 years. During his time of employment, he has worked in Tibs (currently SMRT), MobileOne Ltd, 3M and Virgin Mobile.

During his tenure, he has worked with multiple databases, extracted and downloaded information from systems and run numerous analysis. These analyses spanned across many departments such as Finance, Sales, Marketing, Human Resources, Payroll, etc.

After his employment, he worked as a data analytics consultant for many companies, including Discovery Asia, 3M, Tanah Merah Country Club, Johnson and Johnson Vision Care, National Environmental Agency, Timberland, etc.
His data analytics skills combined with Excel allowed him to deliver many reports to the clients without them having to incur software cost. These reports include Dashboards, Top 10 charts, Risk Analysis, Business Models, KPIs, etc.

As a trainer, he is passionate about transferring his knowledge and imparting his skills to his participants. To day, he has trained thousands in his face to face workshops and had conducted talks for thousands as well.

Trans-Island Bus Services Ltd (Tibs) –Operations and Revenue Analytics, Passengers Travelling Behaviour Analytics
• Daily tracking of revenue,
• Prepare KPI for LTA,
• Fare revision analysis

Mobile One Asia Ltd (M1) – Financial analytics, Customer Call Usage Analytics
• Full company budgeting and business planning,
• Monthly Analysis,
• KPI reporting

3M – Sales, Cost and Inventory analytics
• Daily and Monthly Sales Forecasting,
• Analysis of Marketing Budget,
• Analysis of Inventory and shipments.
• Cost Analysis for new products (BOM analysis)

Virgin Mobile – Retail, Marketing, Payroll, Admin, IT, Finance Analytics
• Daily KPI reporting,
• Monthly Analysis for Finance, Payroll,
• Developed Fully Automated Business Model driven by KPI