Download Year 2023 Training Calendar

Download Now
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
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
The steps were clear & I can refer to the notes for reference anytime. Thank you for your patient in going through the training step by step. The course & trainer were great, everything was better than expected.
Manager, CPFBPower BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization
What I like most 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 Series 1 - Automating Data Preparation
I like the little tips & unknown shortcuts in Excel. Learning these will help us save a lot of time in our daily work & let us use Excel more efficiently. Alaster is very knowledgeable & helpful! Please continue your great work in educating the workforce on how to better use Excel.
Senior Executive, CPFBExcel 100 Tips & Techniques
Knowing how to split the flat file was very useful as it helps me to see how all concepts that we've learnt over the past 2 days fall nicely into place - glad that was covered at the end of the class. 🙂 Thank you for going above & beyond the syllabus to share your knowledge so freely with us, to help us better understand the concepts & how to better apply them in our work!
Manager (HROD), NYCData Analysis with Excel Power Query, Data Model & Power Pivot
I like the hands-on guidance throughout all the exercises. Engaging & knowledgeable trainer. One of the many courses that I've really enjoyed attending. Learnt a lot from you. Thanks!
Deputy Director, Singapore PolyExcel Power Query Series 1 - Automating Data Preparation
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
The trainer is willing to share with us some of the advanced Excel skills commonly use in all industry. She is good, approachable & friendly. Enjoy her lesson. Will keep a look out for her course.
Senior Finance Admin, EM ServicesExcel Pivot Table In-Depth
Useful content that I will apply in my work to create a strategic dashboard for my department. Keep it up! Doing things in this step by step manner is very helpful!
Manager, NCSSPower BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization
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
Clear, concise & valuable skills learnt. Keep up the good training patience & methods!
Assistant Manager, NYCExcel 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
It will increase efficiency with the "automated steps". Alaster is very knowledgeable & very clear in his instructions.
Deputy Director, Singapore PolyExcel Power Query Series 1 - 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 Series 1 - Automating Data Preparation
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 Techniques
The detailed steps of each formula & how Mr Alaster is patient with us for each step. Mr Alaster is patient and willing to help us even though we make one certain mistake. Thank you for going the extra mile!
Executive, NUHData Analysis with Excel Power Query, Data Model & Power Pivot
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
Useful Excel skills & shortcuts to improve work efficiency. One of the best trainers that I have encountered. Really knowledgeable & very clear in his teaching. Share his shortcuts & functions. This course is pretty good.
Senior Executive, CDACExcel Data Cleansing & Building Techniques
Everything is perfect. Superb. She makes complicated things/lessons become so interesting & nice to learn. All is great!
Senior Customer Relations & Admin, EM ServicesExcel Pivot Table In-Depth
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, CPFBPower BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization
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 Series 1 - Automating Data Preparation
Practical lessons with exercises that can be implemented in actual work situations. Trainer is patient & very helpful. His explanations are clear & easy to understand.
Executive, Hongkong LandExcel Advanced Formulas & Functions
I like the hands-on practices in particular helped to guide & reinforce how to navigate the BI program. Alaster is very knowledgeable & willing to share his tips & know-how. Please keep it up. We enjoyed the class. 🙂
Executive, CPFBPower BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization
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 Series 1 - 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
Very Informative. Good techniques, clear and concise.
Investigation Officer, SPFPowerPoint 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
Trainer is very helpful & patient during the course. Got to learn about other tips & tricks in Excel too. Thank you for teaching us & guiding us through the course!
Financial Analyst, BeyonicsData Analysis using Dynamic & Interactive Excel Dashboard
Very practical application of the techniques & tips taught. Very engaging & the pace of the course was just right!
Executive, SG EnableExcel 100 Tips & Techniques
Very useful. Good training & advise. All is good! Will come again.
Senior Manager, MINDEFPower BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization
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
Very experienced trainer. Very approachable and helpful.
Training Officer, SPFExcel 100 Tips & Techniques
Very comprehensive & put across in an interesting & engaging manner.
Senior Deputy Director, CPFBPower BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization
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
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
Great learning experience and I am sure it would help in my reports. Thank you for your patience.
Project Specialist, AdvantestExcel 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
Session was good & trainer made the participants to engage in every step of the learning. Thank you!
BI Analyst, Carrier TransicoldPower BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization
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
The lessons were very useful especially the tips & best practices to make your BI more efficient & effective. Thank you!
Manager, MINDEFPower BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization
Very patient & encouraging! I have learned a lot from Alaster.
Senior Manager, TALMicrosoft Power BI Desktop
I like best about this course is learning how to convert raw data into meaningful figures for further analysis. Trainer is willing to share his expertise knowledge.
Human Resource Manager,
EM ServicesExcel Pivot Table In-Depth
Well done! I've learnt a lot of new data stuffs from Alaster course.
Sales Support Manager,
Carrier TransicoldPower BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization
Very useful & the delivery was very clear.
Manager, MINDEFExcel 100 Tips & Techniques
Trainer is very knowledgeable & all topics covered are well explained. Well done!
Executive, Singapore PolytechnicWord Tips & Techniques
Knowledge imparted is practical and useful. Will attend more courses from Alaster.
Assistant IA Manager, THGData Analysis with Excel 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 & OceaniaPower BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization
Very clear instruction & the material is very detailed & clear.
Assistant Director, MINDEFExcel 100 Tips & Techniques
Trainer is highly knowledgeable on subject and willing to share.
CFO, THGExcel 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
Excellent. Very good trainer. All good.
Community Policing Officer, SPFPowerPoint Tips & Techniques
I like everything about this course. Superb experience. Trainer Alaster is professional. His delivery was superb & he was very friendly & patient throughout. Close to perfect!
Police Officer, SPFExcel 100 Tips & Techniques
Too good!
Inventory Executive, THGExcel Advanced Formulas &
Functions
The course content was well-organised & the materials & practice template was well-done. Thank you for an engaging session!
Assistant Director, SG EnableExcel 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
Alaster is very patient in explaining doubts.
Executive, JTCWord 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
Fabulous. Awesome. Very informative & practical.
CPO, SPFWriting Better Emails
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
Editing email to be short & concise. It will help me send email with lesser error.
CPO, SPFEditing & Proofreading Skills
Previous
Next

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.

New & Exclusive

Power BI Desktop Series 2 -
Advanced DAX Formulas
Course

Course Date: 09 - 10 Feb 2023

Register

Excel Advanced Formulas &
Functions Course

Course Date: 09 - 10 Feb 2023

Register

PowerPoint Tips & Techniques
Course

Course Date: 15 Feb 2023

Register

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

Course Date: 16 - 17 Feb 2023

Register

Exclusive

Excel 100 Tips & Techniques
Course

Course Date: 20 - 21 Feb 2023

Register

Excel Pivot Table In-Depth
Course

Course Date: 22 Feb 2023

Register
View All 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 specialised IT courses 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.

Our wide range of Soft Skills Training courses provide insight, skills and tools for personal and professional development. 

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 2023 Training Calendar

Popular Links

All Courses

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