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

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.

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

Contact Us

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

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