Classroom/ Online: Yes/ Yes
Scheduling Date(s):
Note: Please click specific date for detailed venue and course fee etc.
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
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:
- Use Excel for data analytics
- Identify trends and patterns through data analytics
- Interpret results using data analytics methods.
- Share your analysis through data story telling
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
Who should attend
This course is targeted to those who are currently working in
An intermediate level of Excel skills is recommended. Some experience in Pivot Table is highly recommended.
- 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.
Particular 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
