Please note javascript is required for full website functionality.
MVP

Blog

Blog

VBA Blog: 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: 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 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 Blog: 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...


Power BI: Excel Publish to Power BI

31 January 2019

Last week we showed you how to set up Teams and how it is linked to Power BI. This time, we’re going to talk about linking Teams and Excel, and how you can link it up to Power BI.


Power Query: Conditional Column Splitting

30 January 2019

Welcome to our Power Query blog. This week, I look at an example where one column contains both header and detail data.


Power Pivot Principles: Variables and Disconnected Tables in Power BI

29 January 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use a combination of disconnected tables and variables to produce unique slicers in Power BI.


Monday Morning Mulling: January 2019 Challenge

28 January 2019

On the final Friday of each month, set an Excel 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