Please note javascript is required for full website functionality.

Blog

Power Query: Zoned Out

13 February 2019

Welcome to our Power Query blog. Last week’s blog looked at solving a particular problem by using DateTime.AddZone(). This week, I look at some of the M functionality for dealing with time zones.


Power Pivot Principles: Revisiting the SUM function

12 February 2019

Welcome back to our Power Pivot blog. Today, we discuss the SUM function.


A to Z of Excel Functions: The EXP Function

11 February 2019

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


VBA Blogs: Select Case Flexibility

8 February 2019

This month, we’re talking about the Select Case statement. This week, we’re going to introduce tips to make the case statements more flexible.


Power BI Blog: Publishing to Teams

7 February 2019

This is the final segment of our Teams project – how do we get our data from Power BI back into Teams?


Power BI Blog: Custom URLs in Table Visualisations

6 February 2019

Welcome back to this week’s Power BI blog series. This week, Jonathan Liau takes a look at how to add custom URL links into Table values.


Power Query: In the Zone

6 February 2019

Welcome to our Power Query blog. This week, I look at some issues when dealing with extracted dates.


Power Pivot Principles: Variables and Disconnected Tables in Power Pivot

5 February 2019

Welcome back to our Power Pivot blog. Today, we revisit using Variables and Disconnected tables, this time in Power Pivot


A to Z of Excel Functions: The EXACT Function

4 February 2019

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


VBA Blogs: Selecting The Right Case

1 February 2019

This month, we’re going to talk about the Select Case statement. This week we’re going to introduce the Select Case statement and how it works, then next week we’ll modify it to make it more flexible, and lastly, we’ll answer a client question about the statement’s efficiency in the last VBA blog this month.


Newsletter