MICROSOFT EXCEL FUNCTIONS- OFFICE 365 – MICROSOFT 365

OFFICE 365

OFFICE 365 FUNCTIONS

 

OFFICE 365 or MICROSOFT 365 or EXCEL 365 contains the functions which have been introduced in this version only and not available for any of the versions prior to the MICROSOFT 365 or EXCEL 365.

This group contains many IMPROVED, POWERFUL and USEFUL functions for the various areas. Some important functions are XLOOKUP, XMATCH, COUNTA etc.

Here is the list of functions which fall under this category. Click the function for its further details i.e. formula syntax, examples, purpose etc.

OFFICE 365 FUNCTIONS

LEARN XMATCH FUNCTION IN EXCEL WITH EXAMPLES

Table of Contents INTRODUCTION PURPOSE OF XMATCH IN EXCEL PREREQUISITES TO LEARN XMATCH WHAT IS THE SYNTAX OF XMATCH IN …

EXCEL FUNCTIONS-XLOOKUP

Table of Contents INTRODUCTION PURPOSE OF XLOOKUP IN EXCEL PREREQUISITES TO LEARN XLOOKUP SYNTAX: XLOOKUP FUNCTION EXAMPLE 1-XLOOKUP ( EXTRACTING …

EXCEL FUNCTIONS -UNIQUE

UNIQUE is another new function which is still available for only OFFICE 365, Excel for Office 365 for Mac Excel …

EXCEL FUNCTION- LAMBDA

Table of Contents INTRODUCTION PURPOSE OF LAMBDA FUNCTION PREREQUISITES TO LEARN LAMBDA FUNCTION SYNTAX: LAMBDA FUNCTION EXAMPLES: CREATING A FUNCTION …

EXCEL FUNCTIONS-LET

INTRODUCTION Hi! Remember the junior classes of Mathematics when we used to let the value of X.Something same has been …

EXCEL FUNCTIONS-FILTER

INTRODUCTION In practical applications, in maximum cases , we have a large data which can’t be managed by just having …

EXCEL FUNCTION-CONCAT

Table of Contents INTRODUCTION PURPOSE OF CONCAT FUNCTION IN EXCEL PREREQUISITES TO LEARN CONCAT FUNCTION SYNTAX: CONCAT FUNCTION EXAMPLES: CONCAT …