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

The new Excel Dynamic Arrays will never be the same! New & Exclusive

Dynamic Arrays may well be the most significant change to Excel formulas in years, and it is a very welcome one by Excel users.

One thing in Excel remained the same throughout the years – one formula, one cell to get the result. With dynamic arrays, if a formula returns multiple values, it will automatically spill into a range of cells where the results are displayed. The output is always dynamic; the results are automatically updated when the source data changes.

Unlike legacy Excel functions, LAMBDA functions allow you to iterate the process – similar to VBA’s do-while loops but without coding. You’ll never want to go back once you’ve seen how the new Dynamic Arrays work!

Excited? Discover our new Excel 365 Dynamic Arrays and Power Functions course today.

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

Course is perfect. Packed most commonly & frequently used DAX that will help in my job. Trainer was patient & clear in explaining the concept.
BI Analyst, Carrier TransicoldPower BI Desktop Series 2 - Advanced DAX Formulas
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
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
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
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
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 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
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
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
Well done! I've learnt a lot of new data stuffs from Alaster course.
Sales Support Manager,
Carrier TransicoldMicrosoft 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
Direct & efficient tips, lesson was very clear & objective oriented.
Executive, NEAExcel 100 Tips & Techniques
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
Excellent programme and fruitful for work processes.
Bail Extension Officer, SPFDynamic & Interactive Excel Dashboard
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.

Create Digital Fill-In Form In Word
& Auto Import Form Data
From Excel Course

Course Date: 05 Oct 2022

Register

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

Course Date: 06 - 07 Oct 2022

Register

Exclusive

Excel 100 Tips & Techniques
Course

Course Date: 20 - 21 Oct 2022

Register

Exclusive

Excel Power Query - Automating
Data Preparation Course

Course Date: 25 - 26 Oct 2022

Register

Excel Data Cleansing & Building
Techniques Course

Course Date: 27 - 28 Oct 2022

Register

Excel Pivot Table In-Depth
Course

Course Date: 01 Nov 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 gained through 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 offers bite-sized specialized courses, especially in IT skills, to promote in-depth learning. 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