Specialised IT Courses
Our focus is on in-depth learning. Register for our unrivalled range of bite-sized advanced IT Courses, which are personally developed by our highly skilled and experienced local native trainer to allow you to learn beyond the generic skills to meet your professional development and personal learning needs.
View IT Courses
Soft Skills Courses
Register for our Soft Skills Courses, which are developed by our highly experienced trainers to provide insight, skills and tools for personal and professional development.
View Soft Skills Courses
About Us
We are not one of the largest and most established training providers, but we are one of the most reliable, responsible and innovative training providers that provides high quality, specialised and focused advanced IT and Soft Skills training courses in Singapore.
Find Out More
Experience The Difference
Our approach to learning and development is to make a difference.
Contact Us
Learn In-Depth
Take the first step toward learning more new in-depth skills you'll need for jobs of today and tomorrow with ALS now.
Download 2022 Training Calendar
Previous
Next

How will Power Query change the way you use Excel? New!

Data in the real world is messy. Power Query is an Excel business intelligence tool that allows you to import data from a variety of sources and then clean, transform, and reshape the data as needed.

Power Query will change the way you work with data in Excel and save you hours of time that you can use to explore your data, gain deeper insights, and make better decisions.

The query can be set up once and refreshes the data with a single click, allowing current or updated data to be updated quickly. You will be amazed by the data transformation capabilities of Power Query in Excel!

Our new and exclusive Excel Power Query – Automating Data Preparation course will give you the tools to make a real difference at work!

All our courses are not subsidised and non-claimable using SkillsFuture credit. Learners are required to bring along their own laptops for all IT courses.

What Our Learners Say

Alaster is an excellent trainer. He is clear & systematic in his teaching & the lesson is of good pace for beginners with no background in using Power BI. Thank you & enjoyed his lesson thoroughly.
Senior Manager, CPFBMicrosoft Power BI Desktop
This course enabled me to do data cleansing in a more efficient way. Alaster is very knowledgeable and helpful in answering my questions.
Finance Manager, Carrier TransicoldExcel Power Query - Automating Data Preparation
A well delivered course with the right pace. I like the real life examples used to illustrate how we can clean up data which is similar to what we encounter. Thank you for sharing the bonus tips.
Manager, CDACExcel Data Cleansing & Building Techniques
This course allows me to learn more about data analytics & presentation that will very well be useful in my job. Training material is very well-organized & teaching is very well-articulated.
Business Analyst, Teekay MarineMicrosoft Power BI Desktop
Very Informative. Good techniques, clear and concise.
Investigation Officer, SPFPowerPoint Tips & Techniques
Honestly legit one of the best trainers. Really learnt a lot. Very knowledgeable, very smart and very nice tone to the voice. Not a single boring moment during class.
Senior Officer, NEAData Cleansing & Building
Technique
I like the hands-on exercises which allow us to understand Excel better. Trainer is patient & provided many tips for students. He goes out of the way to help students even after the course!
Assistant Manager, MINDEFExcel 100 Tips & Techniques
Mr Leong is a very patient trainer who willingly offers advice on issues.
Head RPOD, SPFData Analysis with Excel Power Query, Data Model & Power Pivot
Very patient trainer. Knowledgeable. Comfortable pace of teaching. Hands-on practices are useful. Good guidance & notes.
Senior Manager, CRAData Analysis with Excel Power Query, Data Model & Power Pivot
Very comprehensive & put across in an interesting & engaging manner.
Senior Deputy Director, CPFBMicrosoft Power BI Desktop
This course is very useful. Learning tips that can make work more efficient & accurate. Thanks for sharing & coaching us so patiently.
Assistant Manager, SG EnableExcel 100 Tips & Techniques
Alaster Leong has paced the course well & assisted to facilitate understanding.
Senior Assistant Director, MHAData Analysis with Excel Power Query, Data Model & Power Pivot
Very patient and structured in his teaching and very easy to understand. Pace is just nice.
Senior Specialist, A*STARExcel Pivot Table In-Depth
Session was good & trainer made the participants to engage in every step of the learning. Thank you!
BI Analyst, Carrier TransicoldMicrosoft Power BI Desktop
Very useful. Good training & advise. All is good! Will come again.
Senior Manager, MINDEFMicrosoft Power BI Desktop
Thank you for your kind patient & guidance! Your demos were clear & you explained the concepts well - made Excel less daunting & foreign for me.
Assistant Manager, JTCExcel Pivot Table In-Depth
Very experienced trainer. Very approachable and helpful.
Training Officer, SPFExcel 100 Tips & Techniques
Great learning experience and I am sure it would help in my reports. Thank you for your patience.
Project Specialist, AdvantestExcel 100 Tips & Techniques
The lessons were very useful especially the tips & best practices to make your BI more efficient & effective. Thank you!
Manager, MINDEFMicrosoft Power BI Desktop
Wonderful trainer. Alaster conducted his course in a clear, concise and professional manner. I thoroughly enjoy my training here with him and hope to join his courses in the future.
Senior Executive, NEAExcel Data Cleansing & Building Techniques
Trainer knows a lot of tips on this course and willing to share what is not within the workbook. Definitely worth the time!
Senior Executive, JTCExcel 100 Tips & Techniques
Well done! I've learnt a lot of new data stuffs from Alaster course.
Sales Support Manager,
Carrier TransicoldMicrosoft Power BI Desktop
The trainer is very good, patient and conducting in an appropriate pace. The notes provided is also very clear and systematic.
Senior WSH Inspector, MOMExcel Pivot Table In-Depth
Direct & efficient tips, lesson was very clear & objective oriented.
Executive, NEAExcel 100 Tips & Techniques
Excellent programme and fruitful for work processes.
Bail Extension Officer, SPFDynamic & Interactive Excel Dashboard
Very detailed & relevant examples.
Lead Executive, Singapore PolytechnicExcel 100 Tips & Techniques
Very patient & encouraging! I have learned a lot from Alaster.
Senior Manager, TALMicrosoft Power BI Desktop
Trainer is very knowledgeable & all topics covered are well explained. Well done!
Executive, Singapore PolytechnicWord Tips & Techniques
Very useful & the delivery was very clear.
Manager, MINDEFExcel 100 Tips & Techniques
Knowledge imparted is practical and useful. Will attend more courses from Alaster.
Assistant IA Manager, THGExcel Power Query, Data Model & Power Pivot
Trainer has great knowledge & able to answer our questions. Able to provide tips for better work in using Power BI.
Associate, Kumon Asia & OceaniaMicrosoft Power BI Desktop
Very clear instruction & the material is very detailed & clear.
Assistant Director, MINDEFExcel 100 Tips & Techniques
Thanks for the very clear and patient guidance! It's especially helpful when we discuss over real use cases.
FVP, UOBMicrosoft Power BI Desktop
Great knowledge & clear explanation. Very helpful & provide relevant tips to improve on my existing project.
Self-SponsoredMicrosoft Power BI Desktop
Too good!
Inventory Executive, THGExcel Advanced Formulas &
Functions
Please keep up your good work. Your tips you have imparted will help us in many ways than you imagine!
Sales Support Business Consultant, AdvantestExcel 100 Tips & Techniques
Trainer is highly knowledgeable on subject and willing to share.
CFO, THGExcel 100 Tips & Techniques
Trainer explains and guides very well.
Admin Officer, SPFExcel 100 Tips & Techniques
Excellent. Very good trainer. All good.
Community Policing Officer, SPFPowerPoint Tips & Techniques
A lot of example that helped us to understand the topic.
Community Policing Officer, SPFBetter Grammar For Business
Thank you for being upbeat and always giving us ample chance to role-play and put on our thinking cap as well as challenging us to push our knowledge.
Customer Service Executive, ICAEI Skills To Make A Difference In Your Service To Customers
Fabulous. Awesome. Very informative & practical.
Community Policing Officer, SPFWriting Better Emails
Previous
Next
Generic selectors
Exact matches only
Search in title
Search in content

Upcoming Courses

All IT Courses are conducted in PC/Windows operating system; unless stated otherwise. 

Exclusive

Power BI Desktop Series 1 -
Data Model, DAX & Dashboard
Visualization Course

Course Date: 18 - 20 May 2022

Register

Data Analysis Using Dynamic &
Interactive Excel Dashboard
Course

Course Date: 26 - 27 May 2022

Register

Data Analysis With Excel Power
Query, Data Model & Power
Pivot Course

Course Date: 02 - 03 Jun 2022

Register

Exclusive

Excel 100 Tips & Techniques
Course

Course Date: 09 - 10 Jun 2022

Register

Exclusive

Excel Real World Essential -
Bridging To The Next Level
Course

Course Date: 09 - 10 Jun 2022

Register

Exclusive

Excel Data Cleansing &
Building Techniques Course

Course Date: 16 - 17 Jun 2022

Register
View More IT Courses

No GST! We are a non-GST registered company, yet.
The more you learn, the more you save!

Highly skilled practitioners local trainers
with more than 10 years of training experience.

All our courses are not subsidised and non
claimable using SkillsFuture credit.

A Certificate of Completion will be awarded to
learners who attain at least 75% attendance.

No Assessment! Relax and master the skills and knowledge learned with ample hands-on practice.

Morning and afternoon coffee break with light
refreshments and lunch will be provided.

ALS Home


Quality IT Courses and Soft Skills Training Provider in Singapore

ALS promotes in-depth learning and has bite-sized specialised courses, with a strong focus on IT skills. The majority of our IT course outlines are unprecedented in the training market. They are applicable to any industry and benefit the public at large. We ensure that our learners leave with individualised practical skills and knowledge, transforming and enriching their lives.

We as learners ourselves, believe in the importance of creating a positive environment where every individual learns the best when they feel welcomed, comfortable, supportive and happy. Ultimately, we want to provide the best possible learning experiences for our learners.

Stay Connected

We hate spam, and we respect your privacy. Your information is safe with us. We do not sell your personal information to third parties. 

Leave this field blank

About Advanced Learning Singapore

About Us

Join Us

Download 2022 Training Calendar

Popular Links

IT Courses

Soft Skills Courses

Company-Sponsored Registration Form

Self-Sponsored Registration Form

Contact Us

Operating Hours:
9:00am – 5:00pm
Monday – Friday, excluding Singapore Public Holidays

Contact:
Tel: +65 6711 0530 
info@advancedlearningsg.com

Advanced Learning Singapore Facebook                Advanced Learning Singapore LinkedIn