Excel 365 Dynamic Arrays Series 1 - Power Functions

by Advanced Learning Singapore Claim Listing

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,

S$910

Contact the Institutes

Fill this form

Advertisement

Advanced Learning Singapore Logo

img Duration

2-Day

Course Details

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

  • Central Branch

    100 Peck Seah St,, Central

Check out more MS Excel courses in Singapore

Aventis Learning Group (ALG) Logo

Microsoft Excel Tips & Tricks For Beginners

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.

by Aventis Learning Group (ALG) [Claim Listing ]
Koenig-Solutions Logo

Intermediate Microsoft Excel

The Intermediate Microsoft Excel Certification is an accreditation that underlines proficiency in utilizing Microsoft Excel at an intermediate level.

by Koenig-Solutions [Claim Listing ]
Oaks Training Logo

Microsoft Office 365 PowerPoint (Basic To Intermediate)

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.

by Oaks Training [Claim Listing ]
Ccisg Logo

Microsoft PowerPoint Tips, Tricks and Techniques

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.

by Ccisg [Claim Listing ]
James Cook Institute Logo

MS Word

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.

by James Cook Institute [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy