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

MYOB Training Centre Logo

Microsoft Excel

Excel remains as one of the most appealing software applications that the community around the world relies on till this day.

by MYOB Training Centre [Claim Listing ]
COMAT Logo

ICDL - Documents (Microsoft Word 2016)

The Word Processing module allows candidates to demonstrate the ability to use a word processing application to accomplish everyday tasks associated with creating, formatting, and finishing word processing documents, such as letters and other everyday documents.

by COMAT [Claim Listing ]
Coursemology Logo

Advanced Microsoft Powerpoint 2016

Advanced Microsoft PowerPoint Course is a certification programme for learners who wish to create effective, high-impact presentations using advanced features and who need to be able to prove their skills in this area.

by Coursemology [Claim Listing ]
Oaks Training Logo

Microsoft Excel 2019 (Basic To Intermediate)

This 2-days hands-on course covers all the essential basics you will need to enter data and build organized spreadsheets. It also provides guidance on how to create a proper database, organizing your data such that it can be used to work with multiple worksheets.

by Oaks Training [Claim Listing ]
Intuition International Logo

Microsoft MS PowerPoint and MS Word (2013, 2016, 2019 and 365) for Office and Business Presentation

Our instructors are exclusive to us and we only engage excellent instructors to ensure all learners meet their individual needs and receive quality teaching. Our curriculum is unique and they include exercises to help participants retain knowledge for long-term use.

by Intuition International [Claim Listing ]

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