Course Information

  • Sessions 2 days
  • Duration 15 hrs
  • Level Beginner
  • Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Course Brochure

Prerequisite

This course is for beginners. No prerequisite is required.

Certification

  • Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.

Excel Power Query and Power Pivot Masterclass

Course Code: C1097
Share

What's This Course About

Excel Power Query and Power Pivot Masterclass equips you with the skills to clean, combine, model and analyse large volumes of data in Microsoft Excel using Power Query and Power Pivot. These powerful built-in tools let you automate data preparation that once took a great deal of manual work, build data models across multiple tables and create insightful reports that refresh with a single click. The masterclass is designed for analysts, finance and operations staff, and experienced Excel users who want to take their data skills further.

You will start by reviewing data with Power Query, connecting to Excel files, CSV files, folders and databases, and using the Power Query editor to clean data, remove errors and duplicates, change data types, split and merge columns, and unpivot and reshape tables. Next you will move on to data analysis with Power Query and Power Pivot, appending and merging queries, loading data into the data model, creating relationships between tables and building PivotTables and PivotCharts from the model.

The final topic covers advanced data analysis using Power Query and Power Pivot, including custom columns, parameters and query folding, writing DAX measures and calculated columns, time intelligence calculations and key performance indicators. Every topic is hands-on with realistic business datasets, so you build reusable, automated reports. By the end of the masterclass, you will be able to prepare and analyse complex data efficiently in Excel and deliver reliable, refreshable insights.

Why Take This Course?

  • Hands-On Learning Learn by doing. Every topic is practised hands-on, so you leave with skills you can use at work straight away.
  • Live Coaching Experienced instructors coach you live, answer your questions and guide you step by step.
  • Free Post-Course Consultation Stuck after class? Message your trainer any time for guidance as you apply what you have learned.
  • Always-Updated Materials Materials are refreshed to stay relevant. Log in to our LMS any time to get the latest version.

Funding Options

No funding is available for this course

For funding, please checkout the details at CASL - Excel Power Query and Power Pivot

Course Fee

$700.00 (GST-exclusive)
$763.00 (GST-inclusive)

Course Date

Course Time

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Course Details

What You'll Learn

Topic 1: Review Data with Power Query

Topic 2: Data Analysis with Power Query and Power Pivot

Topic 3: Advanced Data Analysis using Power Query

Course Info

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:

Hardware: Windows laptop (Power Pivot is not available in Excel for Mac)

Job Roles

Job Roles

  • Data Analyst
  • Business Analyst
  • Financial Analyst
  • Marketing Analyst
  • Operations Analyst
  • Business Intelligence Developer
  • Report Developer
  • Data Consultant
  • Data Manager
  • Risk Analyst
  • Compliance Analyst
  • Database Administrator
  • Systems Analyst
  • Performance Analyst
  • Strategy Analyst
  • Supply Chain Analyst
  • Product Analyst
  • Project Manager
  • Research Analyst
  • HR Analyst

Trainers

Trainers

Dr. Alvin Ang is a data scientist and data science educator with a PhD in Operations Research, an MSc in Logistics and a BEng in Mechatronics, Robotics and Automation Engineering, all from Nanyang Technological University. Operations research is the mathematics of better decisions, and his published work on Kanban production-control systems at IEEE conferences reflects the quantitative rigour he brings to every class. He has served as an IBM Data Science Instructor, a Research Fellow at NUS, a Principal Consultant in data science and an Assistant Professor of Mathematics at SP Jain School of Global Management, where he was named Mathematics Professor of the Year, and he lectured undergraduates in statistics and quantitative methods at SUSS. Since 2021 he has trained professionals at Tertiary Infotech in Python, R, SQL, statistics, Excel analytics, Tableau, Power BI, Apache Spark, machine learning and deep learning, and he founded DataFrens.sg, a community for data scientists in Singapore. An ACLP-certified adult educator, he is known for connecting technical concepts to practical, real-world applications, a strength echoed in hundreds of learner recommendations.

In Excel Power Query and Power Pivot Masterclass, Dr. Ang shows how to get far more out of Excel as an analysis tool. Learners clean and structure data, analyse it with formulas, PivotTables, Power Query and Power Pivot, and present findings in clear charts and dashboards. As a data scientist who teaches Excel analytics alongside Python and R, he emphasises sound analytical thinking and repeatable workflows rather than one-off spreadsheets.

Sanjiv i is an ACTA certified experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions. Sanjiv's goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers Sanjiv has rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle. Here are a few of his BI/analytics projects driven at scale: Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB), Helped develop key KPIs – identified key KPIs and helped land this in the DB, Developed a budget audit tool that captured budget inputs from a host of countries across the globe, Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team.
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.

Liew Sing Loon is a ACTA certified trainer. Liew Sing Loon graduated from the National University of Singapore (NUS) in 1992 with a Second Upper Honors Degree in Electrical Engineering. He started his career as an Electronic Product Design Engineer for four years in a Multinational Company which sell the products worldwide. The job provided him practical knowledge in various aspects of manufacturing operations ranges from Design, Quality, Production and Procurement. He then spent fifteen years in Information Technology Sector as a Key Account Manager in selling IT solutions to Banking, Telecommunications and Government clients. The job provided him the opportunities to propose IT solutions, integrating software, hardware and services, to solve customers’ problems to achieve their strategic business objectives. He joint a German Product Test company to develop its business in providing product Safety, Immunity, Electromagnetic Compatibility (EMC) Certification test. While working in the industry, Liew Sing Loon obtained a Master of Science (MSc) in Technology Management from NUS.
In the last decade, Liew Sing Loon has been Adjunct Lecturer in several Institutes of high learning, transferring his knowledge on Quantitative & Statistical Analysis, Operations, Project & Quality Management to learners ranging from Diploma, full time undergraduates and working adults.Liew Sing Loon has a Certificate of Completion in Education Psychology Course and Teaching & Learning in Higher Education Program conducted by National Institute of Education (NIE).

Dwight Nuwan Fonseka is Head of Data Science at Plano Pte. Ltd. and an ACLP-certified trainer with deep expertise in data analytics, machine learning, and AI applications. He has extensive hands-on experience developing predictive models, RShiny dashboards, and deep learning solutions using R, Python, TensorFlow, and Keras. With a strong professional background in healthcare, finance, and customer analytics, Dwight brings an applied perspective to teaching AI, focusing on both the opportunities and risks of emerging technologies.

Review

Customer Reviews (2)

it was one of the most engaging and enriching learning experience Review by Course Participant/Trainee
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 attended a Power Query and Pivot training session conducted by Alvin Ang, and I must say—it was one of the most engaging and enriching learning experiences I’ve had in a while.

Alvin has a remarkable ability to tailor his teaching to suit the pace and learning style of each participant. His sessions are highly interactive, filled with real-world examples, and thoughtfully paced to ensure no one is left behind. What stood out most was how he connected technical concepts to broader societal trends, making the learning both relevant and inspiring.

He also encouraged us to see upskilling as a vital part of staying competitive in today’s fast-evolving world—a message that truly resonated with me.

With his deep expertise in Data Science, AI, and a wide range of analytical tools, combined with his passion for teaching and mentoring, Alvin is not just a trainer—he’s a true enabler of growth. I highly recommend him to anyone looking to build data capabilities, whether you’re just starting out or looking to deepen your expertise. (Posted on 10/21/2025)
All good Review by Course Participant/Trainee
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
Nur atikah binti shaari (Posted on 2/18/2024)

Write Your Own Review

You're reviewing: Excel Power Query and Power Pivot Masterclass

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
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