This Excel 365 Series 1 – Dynamic Arrays and Power Functions course will take you through the basic of Excel LAMBDA, which enables you to create your own Microsoft Excel custom function without writing any code,
This Excel 365 Series 1 – Dynamic Arrays and Power Functions course will take you through the basic of Excel LAMBDA, which enables you to create your own Microsoft Excel custom function without writing any code, and how you can use it within the workbook, as well as a recursive LAMBDA that loops through cells to replace multiple values.
In addition, it will also cover some of the recent Excel 365 functions, which were released in August 2022.
Pre-requisites
To undergo our Excel 365 – Dynamic Arrays and Power Functions training course, you will need to be:
An intermediate Excel user who already have Excel formulas and functions working knowledge
Proficient in advanced Excel formulas and functions skills or an advanced or expert Excel user.
Software Requirement: Office 365 installed
In October 2018, Advanced Learning Singapore (“ALS”) was registered in Singapore as a corporate training provider providing bite-sized specialised IT courses and soft skills training workshops to the public and private sectors.
We take pride not only in our courses but also our local dedicated trainers. We strive to provide our learners with quality and focused training that will help them transform and enrich their lives.
Our trainers are highly-skilled practitioners with more than 20 years of professional experience, each with their area of expertise, and happy to share their real-life experiences and knowledge.
We recognise the challenge of providing learners with effective experiences that drive and enhance development and business objectives.
We strive in maintaining programme relevance, keeping up with the emerging trends, tools and technologies of our contemporary workforce.
Most of ALS early clients continue to be our clients today, a testament to the enduring quality of our courses and services, as well as our commitment to quality trainers and training programmes provision and relationships.
Our Vision
To be the most trusted training provider for quality, specialised and content relevant training programmes that enable organisations to empower a smarter and skills relevant workforce, transforming lives.
Our Mission
To provide individuals with the most up-to-date and emerging skills and competencies courses that will benefit them with valuable skills ready to meet the demands of tomorrow’s workforce.
This course will equip learners with the techniques to create a new workbook using template, add data to the worksheet, format data, build formulas, insert functions, copy formulas, print worksheet and workbook, sort and filter data list, find and replace text or formatting.
The Intermediate Microsoft Excel Certification is an accreditation that underlines proficiency in utilizing Microsoft Excel at an intermediate level.
Microsoft Office 365 PowerPoint is the tool you need. PowerPoint is easy to use and equipped with many friendly ready to use features to make you presentation faster and easier, enabling you to be more productive and effective in meetings.
This is a one-day hands-on course. The trainer will walk through the topic step-by-step. You will be provided with exercise files on every topic to effectively apply the tips and techniques taught. A short Q & A session will be available after each topic.
ICDL Advanced Word Processing is a high-level certification programme where learners can demonstrate their ability to use the advanced features of word processing applications to enhance their work, improve productivity and save time.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy