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

Olygen Logo

Advanced Powerpoint Infographics Masterclass

Many people present assuming attention from the audience. However, in this age of information explosion, audience attention does not come automatically, but needs to be captured & maintained. You cannot just tell what you know, but what is of value to your audience.

by Olygen [Claim Listing ]
Edulearn International College Logo

Certificate In Ms Office Basic Level

Certificate In Ms Office Basic Level course is offered by Edulearn International College. Edulearn International College is a Private Education Institute (PEI) Registered with the Committee for Private Education which is part of SkillsFuture Singapore(SSG).

by Edulearn International College [Claim Listing ]
VTeach Logo

Microsoft PowerPoint (Advanced)

Upon completing this course, you will be able to customize the PowerPoint application, and effectively create, collaborate on, secure, and distribute complex multimedia presentations for a variety of situations.

by VTeach [Claim Listing ]
Training Singapore Logo

PowerPoint 2013 Course

You will learn about the new enhanced features and components in Excel 2013 and dynamic interface of the Microsoft PowerPoint 2013.

by Training Singapore [Claim Listing ]
Global Training Partners Logo

MS Access 2013 Course

Outlook 2013 training is offered by Global Training Partners. University professors and national experts create our course curriculum.

by Global Training Partners [Claim Listing ]

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