Please note javascript is required for full website functionality.

Blog

VBA Blogs: Going Through the Visual Basics – Part 6

14 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 running a macro.


Power BI Blog: Q&A Power BI Desktop

13 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: Good Relations

12 September 2018

Welcome to our Power Query blog. This week, I consider how to upload data from a relational database.


Power Pivot Principles: Introducing the DATESYTD Function

11 September 2018

Welcome back to our Power Pivot blog. Today, we introduce one our first time intelligence functions.


A to Z of Excel Functions: The DOLLAR Function

10 September 2018

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


VBA Blogs: Going Through the Visual Basics – Part 5

7 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 the VBA Editor


Power BI Blog: Tooltip Reports

6 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: Excellent Examples

5 September 2018

Welcome to our Power Query blog. July brought some improvements to Power Query/Get and Transform. I look at how creating a column from examples has developed.


Power Pivot Principles: Basic Use of Calendar Table

4 September 2018

Welcome back to our Power Pivot blog. Today, we discuss the steps we should take when creating a Calendar Table.


Challenges: Monday Morning Mulling: August 2018 Challenge

3 September 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.


Newsletter