Forum Discussion

MOHAMED Helmy's avatar
MOHAMED Helmy
Copper Contributor
Mar 28, 2018

All Functions that user excel can uses its

The user of Excel 2016 can use these basic types of functions : 
1- Worksheet Functions - more than 480 and less than 500
2- Functions of VBA - less than 200 functions ,
     behind Worksheet Functions that used in VBA (almost)
3- DAX functions - Power pivot - 253 functions
4- M Functions - get & transform - about 630 functions
5- functions Excel 4 Macros - old version that Microsoft still Supported it can used in two places function in custom name or sheet Excel 4 Macro
6- Functions MDX - about 156 functions - PivotTable
7- Custom functions - limited with memory of pc
Note : the file not completed

No RepliesBe the first to reply

Resources