Virtual: Zoom (Learn more)
In-Class (Bring your own laptop)
You can also register by:
Learners should have some working knowledge of Microsoft Excel. This course is suitable for users of Microsoft Office 2019 or 2021.
Must read Things You Would Need to ensure you are properly equiped for this course.
In a data-driven economy, obtaining the right and accurate data or clean data is key to any operation and project. Are you being bogged down by the tedious work of extracting data and ensuring the data is accurate and appropriate for your analysis?
Did you know that there is a quick and efficient way you can get what you need automatically without worrying about creating Excel formulas of handling Excel functions, saving you much valuable time, enabling you to spend more time to work on your analysis and report? Introducing Excel Power Query in Office 365!
Office 365 Excel Power Query is a data transformation and data preparation engine and it comes with a graphical interface for getting data from sources, such as, from a web page, Access database, or CSV to name a few. It has an Excel Power Query Editor prepare or clean up your data easily such as removing a column, filtering rows, changing text case, or trimming. It can even merge, append, group by, pivot, and unpivot. What’s the best part about all these? With Excel Power Query, it can all be automated! What you need is only a few clicks away.
Using Microsoft Office 365 Excel Power Query, you can perform the general extract, transform, and load (ETL) processing of data. A time saver for anyone working with data.
Ms Ow Yeong Yin Leng
Qualified and Experienced to facilitate this course
Additional Dates: If the dates listed are not suitable for you and you have a group interested in the same course, you can contact us to arrange a date of your choice, subject to our trainer availability.
Evening classes or Classes in Mandarin are also available on request. Contact us for arrangements.
Group discounts are also available. Request a quote from us.
Yes, Power Query made Excel much easier to use.
- Pearly Lock (State Courts)
Thank you for the interesting session. Convenient and easy to receive course materials.
- Kamaruzaman Aziz (National Youth Council)
Trainer had efficiently answered our enquiries. Though trainee have a bit of issues with computer / version / add-ins, it does not hinder her from delivering the course efficiently.
- Sarah Salim (State Courts)
I have really benefitted from this course as I know what to apply in my course of work. In the current practice, I do not use the right tools to get my work done. After learning from this course, I am confident that my work will be more efficient.
- Norhalim (Private Sector)
Clear explanation at a comfortable pace.
- Teo Sing Yee (MOF)
No Exam! Ample hands on practice to master lessons taught.
Certificate of Attendance will be given subject to 90% attendance.
Local native speaking Trainers with more than 20 years of experience.
Microsoft Office 365 Excel Basic to Intermediate
Microsoft Office 365 Excel Advanced
Microsoft Office 365 Excel Data Cleaning for Data Analytics
Microsoft Office 365 Excel Automating Data Extraction and Cleaning with Power Query
Microsoft Office 365 Excel Pivot Table for Data Analysis and Analytics
Empowering the Enduser is what we are committed to equiping our learners. We understand the challenges and expectations faced in their daily work. To help learners bridge the gap is what drives us. We believe in the common person and their will to succeed.
Select courses can be delivered in Mandarin on request basis via Zoom.