0   reviews on Udemy

New Excel Functions in Office365

New Functions in Microsoft Excel for 2021
Course from Udemy
 0 students enrolled
 en
What the new dynamic arrays feature in Microsoft Excel means
How the new RANDARRAY function works
How the new UNIQUE function works
How the new SEQUENCE function works
How the new SORT and SORTBY functions work
How the new FILTER function works
How the new XLOOKUP function can replace VLOOKUP
How to build IF statements with the new IFS function
How the new SWITCH function works
How the new TEXTJOIN function can replace CONCATENATE and CONCAT
How the new Excel functions can be used in management reporting

In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions.

The functions I am going to cover are:

· RANDARRAY- creating a table of random numbers or random dates

· UNIQUE – identifying the distinct items in a list

· SEQUENCE – listing numbers with a set interval

· SORT and SORTBY – new ways of dynamically sorting data

· FILTER – building the ability to filter data into formulae

· XLOOKUP – replacing VLOOKUP with greater flexibility

· IFS and SWITCH making it easier to construct IF statements

· The new CONCAT, and TEXTJOIN text functions


These functions are available to users with a current Office365 subscription. They are not available in any earlier versions of Excel including Excel 2019.

If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.

New Excel Functions in Office365
$ 19.99
per course
Also check at

FAQs About "New Excel Functions in Office365"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK