Function library
Every Excel function
All 521 functions from Microsoft’s list, grouped the way Excel groups them. 500 run right here in the practice sheet; the rest come with step-by-step guides for desktop Excel.
Cube
Read from a Power Pivot data model or OLAP cube.
7 functions
CUBEKPIMEMBERReturns a KPI (key performance indicator) value, goal, status or trend defined in an OLAP cube or Data Model.CUBEMEMBERPicks one item (a member or tuple) from the Data Model so CUBEVALUE can use it — like a row or column heading in a PivotTable.CUBEMEMBERPROPERTYReturns a property of a member in an OLAP cube (for example a product’s colour or a customer’s city).CUBERANKEDMEMBERReturns the nth member of a set — the way to build “Top 5” lists from a Data Model.CUBESETDefines a group of members (for example every product) that CUBERANKEDMEMBER and CUBESETCOUNT can work with — handy for Top-10 lists.CUBESETCOUNTCounts how many members a CUBESET contains.CUBEVALUEReturns a total (a measure) from a Power Pivot Data Model or an OLAP cube, filtered by the members you list.