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 …
How to use XLOOKUP FUNCTION in Excel?
Table of Contents INTRODUCTION What is the use of Xlookup function in Excel ? Prerequisites to learn Xlookup function in …
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 …