Many Excel users struggle with time-consuming data cleaning, repetitive tasks, and the complexity of managing multiple datasets. This 2-day short course on Data Analytics with Power Query and Excel is designed to address these common challenges. You’ll gain practical skills to automate and streamline your Excel work, transforming the way you handle data.
Throughout the course, you will:
- Transform, Clean, and Shape Data: Learn to efficiently use the Power Query Editor to automate data transformations, clean messy datasets, and shape your data for analysis.
- Import, Merge, and Combine Datasets: Master the ability to import data from various sources, merge different datasets, and create a unified combined view of your data.
- Analyse Data Using Basic Statistical Techniques: Enhance your data analysis skills by applying essential statistical techniques, enabling you to draw meaningful insights from your data.
- Build Dynamic Dashboards: Discover how to create interactive dashboards using PivotTables and PivotCharts, allowing you to visualise data in a way that supports better decision-making.
By the end of this course, you’ll have the confidence and skills to manage and analyse your data more effectively, saving time and improving accuracy in your day-to-day Excel tasks.
Learning Objectives
By the end of the course, participants will be able to:
- Transform, clean and shape your data using Microsoft Excel Power Query Editor
- Import, merge and combine different datasets
- Analyse data set using basic statistical techniques
- Build dashboards using PivotTables and PivotCharts
Who should attend?
Managers, professionals, executives and support staff involved in data collection, preparation and presentation for analysis and decision-making.
Entry Requirement
Basic IT Literacy.
Certification
Certificate of Attendance.
Trainer’s Profile
Sim Biow Ee graduated with a BSc (Hons) in Computer Science from University Science of Malaysia. She has 11 years of software development and project management experience in the finance, manufacturing and education sectors before joining RP in 2010. At RP she has developed and/or delivered courses for Data Wrangling, Data Visualisation, Business Intelligence and Software Development. She has conducted corporate training for the likes of M1, Micron, MHA, MINDEF and PSA.
Lee Yow Jinn is a Senior Lecturer at RP School of Infocomm. Formerly a Deputy Director with RP Office of Organisation & Service Excellence.
He has over 20 years of experience in the public sectors including Post Office Savings Bank (now DBS Bank), Network for Electronic Transfers (NETS). Projects he has completed include branch automation, process automation, Automated Machine (ATM) deployment, banking system enhancement, electronic payment system and e-commerce development. He has conducted corporate training for the likes of MHA, Govtech and NYC.
Please click on the "Register" button to view the updated course schedule and fees on the Skills Training & Enhancement Portal (STEP).
Please click on the "Register" button to view the updated course schedule and fees on the Skills Training & Enhancement Portal (STEP).