Excel Course Bundle Discount
We have a course bundle discount for two essential Excel courses. Check it out!
Find Out More
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

Master DAX to grasp Power BI at its full potential! New launch!

DAX is Power BI formula language and is a library that provides users with an array of methods for analyzing and shaping data. Without DAX, you would miss out 95% of Power BI’s potential as a great analytical tool. Just like Excel, you can’t really maximise the functionality of these spreadsheets without understanding the formulas.

With the ability to create efficient DAX formulas will help you extract the most useful information from your data and gain deeper insights from your visualizations.

Using DAX will truly unlock Power BI’s capabilities and learning DAX will introduce you to a whole new world of Power BI.

Be the first to enrol in our Power BI Desktop Series 2 – Advanced DAX Formulas course, which will launch on November 28-29, 2022, to help you build expert-level data analysis capabilities using DAX in Power BI!

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

What Our Learners Say

What I like about this course is learning how to manipulate data in the shortest time. The trainer is systematic & clear in explanation.
Senior Executive, SingHealthExcel Power Query - Automating Data Preparation
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
Able to learn new skills & functions. The trainer is very nice & positive, always willing to help & guide the class.
MPIM Ops Asia Analyst, LS&Co.Excel Power Query - Automating Data Preparation
The notes prepared/given are very comprehensive. The trainer is very detailed & understands/willing to explain the techniques as well as clarify doubts. He is very clear & concise in the explanation & steps.
Senior Executive, CDACExcel Power Query - Automating Data Preparation
This course will definitely help in my work as there are many functions in pivot table that I do not know previously. The trainer is patient & clear.
Senior Treasury Analyst, Coach Operations Singapore Pte LtdPivot Table In-Depth
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
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
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
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
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
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
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 Informative. Good techniques, clear and concise.
Investigation Officer, SPFPowerPoint Tips & Techniques
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
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
Too good!
Inventory Executive, THGExcel Advanced Formulas &
Functions
Great knowledge & clear explanation. Very helpful & provide relevant tips to improve on my existing project.
Self-SponsoredMicrosoft Power BI Desktop
Trainer is highly knowledgeable on subject and willing to share.
CFO, THGExcel 100 Tips & Techniques
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 explains and guides very well.
Admin Officer, SPFExcel 100 Tips & Techniques
Excellent. Very good trainer. All good.
Community Policing Officer, SPFPowerPoint Tips & Techniques
This course gave me the confident to engage member of the public in future with the right question. The trainer is super cheerful, motivational & direct to his learning objective.
NPCO, SPFHow To Talk To Anyone: The Art Of Everyday Conversation
Fabulous. Awesome. Very informative & practical.
Community Policing Officer, SPFWriting Better Emails
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
A lot of example that helped us to understand the topic.
Community Policing Officer, SPFBetter Grammar For Business
I am able to learn different skills to maintain a conversation & to keep others interested in a conversation with me. Thank you for engaging & assisting us in learning & tackling conversational skills which is not as simple as many might perceive.
Ground Response Officer, SPFHow To Talk To Anyone: The Art Of Everyday Conversation
Previous
Next
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Upcoming Courses

All IT Courses are conducted in PC/Windows operating system. There will be no laptop provided. Learners are required to bring along their own laptops for all IT courses.

How To Talk To Anyone: The Art
Of Everyday Conversation
Course

Course Date: 22 Aug 2022

Register

Excel Automation With VBA
Series 1 - Fundamentals
Course

Course Date: 25 - 26 Aug 2022

Register

Better Grammar For Business
Course

Course Date: 29 Aug 2022

Register

Exclusive

Excel Power Query - Automating
Data Preparation Course

Course Date: 01 - 02 Sep 2022

Register

Exclusive

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

Course Date: 07 - 09 Sep 2022

Register

Exclusive

Excel Real World Essential -
Bridging To The Next Level
Course

Course Date: 12 - 13 Sep 2022

Register
View More IT Courses
View More Soft Skills 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