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

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

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.

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.

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

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.

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.

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!

This week, we’re going to divert a little bit away from Power BI directly, and talk about how it can integrate into Microsoft Teams. This is the central part of what Tim’s presentation in Singapore last week was all about. We’ll spread this over the next few weeks. This first week, we’re just going to introduce what Microsoft Teams is, and how it can interface with Power BI.

Welcome to our Power Query blog. This week, I look at extracting a number from a mixed column.