Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Subtotal function in Excel
  • Reverse List in Excel
  • How to add Trendline to a chart in Excel
  • How To Load Analysis ToolPak in Excel
  • Excel Bar Chart

References

  • Convert text string to valid reference in Excel using Indirect function
  • Count rows with at least n matching values
  • Get nth match with INDEX / MATCH in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to get relative column numbers in a range in Excel

Data Validations

  • Excel Data validation allow weekday only
  • How To Create Drop-down List in Excel
  • Excel Data validation specific characters only
  • Excel Data validation must not contain
  • Excel Data validation only dates between

Category: Cube Functions

Excel Cube functions perform calculations and extract data from a cube, which is stored on an external SQL server.

Complete List of Excel Cube Functions References and Examples

by

Excel Cube functions were introduced in Microsoft Excel 2007. The Cube functions  perform calculations and extract data from a cube, which is stored on an external SQL server. These functions are only supported with a connection to Microsoft SQL Server 2005 Analysis Services or later data source. Data cubes are multidimensional sets of data that …

Continue Reading

CUBESETCOUNT function: Description, Usage, Syntax, Examples and Explanation

by

What is CUBESETCOUNT function in Excel? CUBESETCOUNT function is one of Cube functions in Microsoft Excel which returns the number of items in a set. Syntax of CUBESETCOUNT function CUBESETCOUNT(set) The CUBESETCOUNT function syntax has the following argument: Set: A text string of a Microsoft Excel expression that evaluates to a set defined by the CUBESET function. …

Continue Reading

CUBESET function: Description, Usage, Syntax, Examples and Explanation

by

What is CUBESET function in Excel? CUBESET function is one of Cube functions that defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Excel. Syntax of CUBESET function CUBESET(connection, set_expression, , [sort_order], [sort_by]) The CUBESET function syntax has …

Continue Reading

CUBERANKEDMEMBER function: Description, Usage, Syntax, Examples and Explanation

by

What is CUBERANKEDMEMBER function in Excel? The CUBERANKEDMEMBER function is one of the Cube functions in Microsoft Excel which returns the nth, or ranked, member in a set.  It is used to return one or more elements in a set, such as the top sales performer or the top 10 students. Syntax of CUBERANKEDMEMBER function CUBERANKEDMEMBER(connection, set_expression, rank, ) The CUBERANKEDMEMBER function syntax …

Continue Reading

CUBEMEMBER function: Description, Usage, Syntax, Examples and Explanation

by

What is CUBEMEMBER  function in Excel? CUBEMEMBER  function  is one of the Cube functions in Microsoft Excel which returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube. Syntax of CUBEMEMBER  function CUBEMEMBER(connection, member_expression, ) The CUBEMEMBER function syntax has the following arguments: Connection: A text string of the name of …

Continue Reading

CUBEKPIMEMBER function: Description, Usage, Syntax, Examples and Explanation

by

 What is CUBEKPIMEMBER function in Excel? CUBEKPIMEMBER function is one of the Cube functions in Microsoft Excel which returns a key performance indicator (KPI) property and displays the KPI name in the cell.  A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization’s performance. Note: The CUBEKPIMEMBER function …

Continue Reading

CUBEMEMBERPROPERTY function: Description, Usage, Syntax, Examples and Explanation

by

What is CUBEMEMBERPROPERTY function in Excel? CUBEMEMBERPROPERTY function is one of the Cube functions in Excel which returns the value of a member property from a cube. Usage of CUBEMEMBERPROPERTY function CUBEMEMBERPROPERTY function is used to validate that a member name exists within the cube, and to return the specified property for this member. Syntax of CUBEMEMBERPROPERTY function CUBEMEMBERPROPERTY(connection, member_expression, property) The CUBEMEMBERPROPERTY function syntax has …

Continue Reading

CUBEVALUE function: Description, Usage, Syntax, Examples and Explanation

by

What is CUBEVALUE function in Excel? CUBEVALUE function is one of Cube functions in Microsoft Excel which returns an aggregated value from the cube. Syntax of CUBEVALUE function CUBEVALUE(connection, [member_expression1], [member_expression2], …) The CUBEVALUE function syntax has the following arguments: Connection: A text string of the name of the connection to the cube. Member_expression(Optional): A text string of a multidimensional …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • SWITCH function example in Excel
  • How to use Excel TRUE Function
  • IF with wildcards in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IFNA function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get week number from date in Excel
  • Get last working day in month in Excel
  • Add workdays no weekends in Excel
  • Display Days until expiration date in Excel
  • Count birthdays by month in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Group times into 3 hour buckets in Excel
  • Group arbitrary text values in Excel
  • Group numbers with VLOOKUP in Excel
  • Group numbers at uneven intervals in Excel

General

  • Subtotal invoices by age in Excel
  • How to Create Calendar in Excel
  • Basic text sort formula in Excel
  • Check if multiple cells have same value in Excel
  • How to generate random number weighted probability in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning