Skip to content

Data Empower – The Data Matrix

Search for:
Log in

Menu

Close
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
Search for:
Log in

Category: Excel

  • Home
  • Excel
Excel

How to Disable the Research Pane in Excel

Written by ilyar126 July 28, 2024January 29, 2025

What an annoyance! I personally, have never found any use in Excel’s Research Pane, other that it being really annoying and becoming such a distraction if it pops up unexpectedly, just like that dude Jar-Jar-Binks in Star Wars! If you find yourself wanting to disable it, follow these steps: Method 1 (the only one I […]

Excel

Excel Cube functions explained: Cubevalue, Cubeset, Cubemember, Cuberankedmember

Written by ilyar126 June 5, 2023June 1, 2025

Want to give some magic to your Excel modeling? Then its time to call Galdalf and seriously learn about Excel Cube functions! One of my favorite Excel functions to do business modeling are Cube functions. They act as a more efficient replacement for SUMIFS, GETPIVOTDATA functions that serve to sum aggregated results with various filters […]

Excel

Analyze in Excel PowerBI Cube not refreshing new dimensions after publish

Written by ilyar126 February 25, 2022February 25, 2022
Analyze in Excel PowerBI Cube not refreshing new dimensions after publish

What to do if your PowerBI Excel cube is not refreshing new dimensions? Dont let your Excel spoil your refreshing drinks. Read on to find the answer.

Excel

Excel – measure distance between any points on Earth

Written by ilyar126 September 2, 2021May 9, 2023
Excel – measure distance between any points on Earth

If you want to measure a distance between any two points, there is an Excel formula that does just that. For that you solely need the coordinates of locations (Latitude, Longitude) and a blank Excel worksheet.

Excel

Excel CUBEVALUE vs SUMIFS & GETPIVOTDATA

Written by ilyar126 July 28, 2021February 7, 2025

Get a comprehensive comparison between CUBEVALUE, GETPIVOTDATA and SUMIFS functions broken down into 12 categories and get recommendation when to use which formula.

Follow me on Ganjing World!

Get the SQLBits T-Shirt now!

Copyright © 2025 Data Empower - The Data Matrix | Powered by BuddyX WordPress Theme