Forum Discussion
MOHAMED Helmy
Mar 28, 2018Copper Contributor
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