Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The CUBEKPIMEMBER Function

2 March 2018

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


Power BI Blog: Excel-sior Part 3

1 March 2018

Welcome to Power BI Tips. Following on from last week, creating our first visualization, a clustered column chart


Power Query: Passing (Reference to) Excel Parameters

28 February 2018

Welcome to our Power Query blog. This week, I take a look at how to pass Excel data as a parameter in Power Query.


Power Pivot Principles: Creating Relationships

27 February 2018

Today we discuss what are relationships (in Power Pivot) and how we may create them...


Monday Morning Mulling: February 2018 Challenge

26 February 2018

Last week, we asked how you could set up a cell to pick up text from parts of an Excel spreadsheet, and present it in a ready-for-email form.


A to Z of Excel Functions: The CSCH Function

26 February 2018

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


Final Friday Fix: February 2018 Challenge

23 February 2018

Friday is normally our VBA blog day, so for this week’s Final Friday Fix, we’re going to look at a problem that is fairly easy to solve in VBA, but a bit more challenging in Excel…


A to Z of Excel Functions: The CSC Function

23 February 2018

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


Power BI Blog: Excel-sior Part 2

22 February 2018

Welcome to Power BI Tips. Following on from last week, cleaning up the data using the Query Editor.


Power Query: Returning to Referencing Ranges

21 February 2018

Welcome to our Power Query blog. This week, I take another look at what I can do with Excel.CurrentWorkbook.


Newsletter