WhatsApp UsSkype Us9:00am to 5:30pm (Mon-Fri) Stay Safe!

Microsoft Office 365 Excel Power Query - Automating Data Extraction and Cleaning

Training Modes
 Virtual: Zoom (Learn more)
 In-Class (Bring your own laptop)

Course Code
 
OKEPQA
Duration
 
7 Hours (1 Day)
Course Fee
 
$392.40 inclusive of GST
Funding
 
UTAP for NTUC Members
This Course is For
 
Anyone who works with raw data and need to ensure that the given data is clean and accurate for analysis and report generation in Office 365 Excel without the need to manually enter Excel formulas.

Preferred Date

You can also register by:

  1. Form: Click here to download. Email back to us.
  2. Ministries on HRP / ACE: Inform your Training Coordinator the Course Code, Course Date and the Training Provider is Oaks Training c/o GIL Consultancy.
    IMPORTANT NOTE: OAKS TRAINING begins with the letter O and not the symbol @ in HRP
  3. PHONE: Call +65 6423 1183.


Prerequisites

Learners should have some working knowledge of Microsoft Excel. This course is suitable for users of Microsoft Office 2019 or 2021.

Important Note
Must read Things You Would Need to ensure you are properly equiped for this course.


Empower Your Data Management Effortlessly!

Are you tired of the data drudgery that comes with manual manipulation in Excel? As a manager, team leader, or an Excel user, we understand the challenges of ensuring data accuracy for analysis.

Here's the fantastic news: Bid farewell to tedious data tasks and welcome the magic of Excel Power Query in Office 365! This incredible tool is designed to simplify data management, saving you valuable time.

With Excel Power Query, you don't need to be a data expert or rely on complex formulas. Its intuitive interface allows you to effortlessly fetch data from web pages, databases, and CSV files. Cleaning up data is a breeze with the Excel Power Query Editor - remove unwanted columns, filter rows, change text case, and trim data with ease. Unlock advanced features like merging, grouping, and pivoting data, all without manual calculations.

The best part? Microsoft Office 365 Excel Power Query automates these tasks, giving you back time and ensuring accuracy.

Whether you're an analyst, marketer, or an everyday Excel user, Microsoft Office 365 Excel Power Query is here to simplify your data workflows. Embrace efficiency and make way for more analysis and decision-making.

Don't let data overwhelm you. Empower yourself with Microsoft Office 365 Excel Power Query and experience a new level of data management ease and efficiency. Enroll now and unlock a world of possibilities!

Sign up today and supercharge your data prowess!


Our Friendly Trainer

Ms Ow Yeong Yin Leng

Qualified and Experienced to facilitate this course

  • More than 25 years of training experience
  • Native speaking Trainers
  • Microsoft Certified

Special Request

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.


Reviews

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
No Exam! Ample hands on practice to master lessons taught.

Certificate
Certificate of Attendance will be given subject to 90% attendance.

Trainer
Local native speaking Trainers with more than 20 years of experience.

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.

Classes in Mandarin

Select courses can be delivered in Mandarin on request basis via Zoom.

  • Microsoft Office
  • Video Editing
  • Essential Digital Skills

Contact Us

Mon-Fri, 8:30am-5:30pm
WhatsApp: Click here
Skype: Click here
Phone: 6423-1183
Online Enquiry: Click here
Locate Us: Click here

Facebook