Please note javascript is required for full website functionality.

Blog

VBA Blogs: Going Through the Visual Basics – Part 9

12 October 2018

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog looks at the concept of a variable scope at a project level.


Power BI Blog: Visiting Ideas 2 – DAX editor

11 October 2018

October is Ideas month for our Power BI blog!


Power Query: Group Dynamics

10 October 2018

Welcome to our Power Query blog. This week, I look at how to calculate a group share.


Power Pivot Principles: Importance of Contiguous Dates

9 October 2018

Welcome back to our Power Pivot blog. Today, we discuss why it is important to have Contiguous Dates in a calendar table.


A to Z of Excel Functions: The DPRODUCT Function

8 October 2018

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


VBA Blogs: Going Through the Visual Basics – Part 8

5 October 2018

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog looks at the concept of a variable scope at a module level.


Power BI Blog: Visting Ideas

4 October 2018

Last week, we had a training session where someone suggested a great idea for an improvement to Power BI. That gave us a great idea – October is going to be Ideas month for our Power BI blog!


Power Query: Let It Be

3 October 2018

Welcome to our Power Query blog. This week, I look at (some of the most) simple M statements.


Power Pivot Principles: Introducing the CLOSINGBALANCEMONTH Function

2 October 2018

Welcome back to our Power Pivot blog. Today, we introduce the CLOSINGBALANCEMONTH function.


Challenges: Monday Morning Mulling: September 2018 Challenge

1 October 2018

Welcome to this month’s Monday Morning Mulling! Last week, we set a challenge that has stumped project finance specialists worldwide – how do you set up an upfront or establishment fee for a debt facility, in a way that updates automatically and doesn’t require a macro to run it or to switch on iterative calculations?


Newsletter