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

EXCEL FUNCTIONS-XMATCH

XMATCH FUNCTION is a new function introduced in some of the EXCEL VERSIONS, such as EXCEL 365, EXCEL FOR ANDROID …
Read More

EXCEL FUNCTIONS-XLOOKUP

CONTENTS INTRODUCTION PURPOSE OF XLOOKUP IN EXCEL PREREQUISITES TO LEARN XLOOKUP SYNTAX: XLOOKUP FUNCTION EXAMPLE 1-XLOOKUP ( EXTRACTING A SINGLE …
Read More

EXCEL FUNCTIONS -UNIQUE

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

EXCEL FUNCTION- LAMBDA

INTRODUCTION The LAMBDA function is a new entry in the vast empire of Excel. The function is yet to be …
Read More

EXCEL FUNCTIONS-LET

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

EXCEL FUNCTIONS-FILTER

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

EXCEL FUNCTION-CONCAT

INTRODUCTION CONCAT function is the latest successor of the older CONCATENATE FUNCTION almost performing the same task but in a …
Read More