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

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?

Welcome to this month’s Final Friday Fix! This month we’re going to delve into the world of project finance, and in particular, look at the issue of construction funding – in particular, the problem of what to do when there is an upfront cost based on some total financed amount.

As we promised in our recent newsletter, we’ll be spending the next couple of months talking about some of the new Power BI features that are being rolled out.

Welcome to our Power Query blog. This week, I look at how to deal with imported errors.

Welcome back to our Power Pivot blog. Today, we go over how to refresh data in Power Pivot.

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

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 declaring variables.

As we promised in our recent newsletter, we’ll be spending the next couple of months talking about some of the new Power BI features that are being rolled out.

Welcome to our Power Query blog. This week, I take a look at some tips to help get the best out of Power Query.