Please note javascript is required for full website functionality.

Blog

Challenges: Final Friday Fix: September 2018 Challenge

28 September 2018

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.


Power BI Blog: M Intellisense

27 September 2018

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.


Power Query: Erasing Errors

26 September 2018

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


Power Pivot Principles: How to Refresh Data in Power Pivot

25 September 2018

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


A to Z of Excel Functions: The DOLLARFR Function

24 September 2018

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


VBA Blogs: Going Through the Visual Basics – Part 7

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


Power BI Blog: Q&A Row Level Security

20 September 2018

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.


Power Query: 10 Top Tips

19 September 2018

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


Power Pivot Principles: Introducing the TOTALYTD Function

18 September 2018

Welcome back to our Power Pivot blog. Today, we introduce another time intelligence function.


A to Z of Excel Functions: The DOLLARDE Function

17 September 2018

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


Newsletter