Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The CUBESETCOUNT Function

19 March 2018

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CUBESETCOUNT function.


A to Z of Excel Functions: The CUBESET Function

16 March 2018

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CUBESET function.


VBA Blogs: Wending down the hill Until you Do

16 March 2018

Last week we looked at For Each…Next loops – but this time let’s have a look at While Wend loops.


Power BI Blog: Text isn't Limiting! - Part 2

15 March 2018

Welcome back to Power BI Tips! Continuing with the US Census Historical Population Estimates text file exercise.


Power Query: Moving Date

14 March 2018

This week, I look at how to transform extracted data into a useful table.


Power Pivot Principles: A Design for Life

13 March 2018

oday, we consider some of the menu options in the Power Pivot window, focusing on the Design tab.


A to Z of Excel Functions: The CUBERANKEDMEMBER Function

12 March 2018

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CUBERANKEDMEMBER function.


VBA Blogs: Getting Loopy Each Time

9 March 2018

Loops are a powerful tool in programming to repeat a sequence of instructions. But what if you want to perform an action to every object in a set?


A to Z of Excel Functions: The CUBEMEMBERPROPERTY Function

9 March 2018

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CUBEMEMBERPROPERTY function.


Power BI Blog: Text isn't Limiting! - Part 1

8 March 2018

Welcome back to Power BI Tips! Looking at a new exercise with importing and massaging data from a text file from the US Census.


Newsletter