Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Get nth match with INDEX / MATCH in Excel
  • Convert text string to valid reference in Excel using Indirect function
  • Find closest match in Excel
  • Create hyperlink with VLOOKUP in Excel
  • How to get relative row numbers in a range in Excel

Data Analysis Examples

  • Randomize/ Shuffle List in Excel
  • How to create running total in an Excel Table
  • How to Create One and Two Variable Data Tables in Excel
  • How to count table columns in Excel
  • How to calculate correlation coefficient Correlation in Excel

Data Validation Examples

  • Excel Data validation date in next 30 days
  • Excel Data validation date in specific year
  • Excel Data validation unique values only
  • Data validation must not exist in list
  • Prevent invalid data entering in specific cells

Category: Cube Functions

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

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

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

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

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

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

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

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
  • BAHTTEXT function: Description, Usage, Syntax, Examples and Explanation
  • Count Number of Words in Excel
  • How to pad text to match equal length in Excel
  • How to extract nth word from text string in excel
  • Add line break based on OS in Excel
  • How to calculate Next working/business day in Excel
  • Calculate series of dates by workdays in Excel
  • Convert date to Julian format in Excel
  • How to get year from date in Excel
  • Add decimal minutes to time in Excel
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
  • RATE function: Description, Usage, Syntax, Examples and Explanation
  • PDURATION function: Description, Usage, Syntax, Examples and Explanation
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • Calculate payment for a loan in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles