Please note javascript is required for full website functionality.

Blog

Power Query: Appearing Cultured

31 October 2018

Welcome to our Power Query blog. This week, I look at how M and culture can go together.


Power Pivot Principles: Resource Management with Calculated Columns

30 October 2018

Welcome back to our Power Pivot blog. Today, we discuss factors to consider when creating and using Calculated Columns.


Challenges: Monday Morning Mulling: October 2018 Challenge

29 October 2018

On the final Friday of each month, we set an Excel problem for you to puzzle over for the weekend. On the Monday, we publish a solution – or two as in this case. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Challenges: Final Friday Fix: October 2018 Challenge

26 October 2018

On the final Friday of each month, we’re going to set an Excel challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only!


Power BI Blog: Visiting Ideas 4 – Dynamic date slicer

25 October 2018

October is Ideas month for our Power BI blog!


Power Query: Presenting Text

24 October 2018

Welcome to our Power Query blog. This week, I look at how text output can be presented.


Power Pivot Principles: Perspectives

23 October 2018

Welcome back to our Power Pivot blog. Today, we discuss how to create and use Perspectives in PowerPivot.


A to Z of Excel Functions: The DSTDEVP Function

22 October 2018

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


VBA Blogs: Going Through the Visual Basics – Part 10

19 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 declaring constants.


Power BI Blog: Visiting Ideas 3 – Custom Visuals template

18 October 2018

October is Ideas month for our Power BI blog! If you haven’t been there yet, go check out ideas.powerbi.com. This is essentially the suggestion box for Power BI, where users can submit great ideas that they’d like to see and vote on other ideas that they agree with.


Newsletter