Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The DGET Function

6 August 2018

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


VBA Blogs: Going Through the Visual Basics – Part 1

3 August 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 first part starts with the most basic of Visual Basics


Power BI Blog: Upgraded Quick Insights

2 August 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: Seating Plans

1 August 2018

Welcome to our Power Query blog. This week, I look at an example where I need to calculate the stock needed from a supplier.


Power Pivot Principles: Tidying Data

31 July 2018

Welcome back to our Power Pivot blog. Today, we discuss potential steps we can take when we receive ‘messy’ data.


Monday Morning Mulling: July 2018 Challenge

30 July 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. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Final Friday Fix: July 2018 Challenge

27 July 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: Access-ible Data - Part 3

26 July 2018

Introduction to viewing relationships in a database with Power BI.


Power Query: Technically Dating

25 July 2018

Welcome to our Power Query blog. This week, I look at some useful logical M functions to convert data into dates or vice versa.


Power Pivot Principles: Introducing Slicers

24 July 2018

Welcome back to our Power Pivot blog. Today, we consider slicers in PivotTables created using Power Pivot.


Newsletter