Please note javascript is required for full website functionality.

Blog

VBA Blogs: File Path Selector

14 June 2019

Welcome back to the VBA blog! This week we are going to cover something we had to do for one of our consulting jobs.


Power BI Blog: Microsoft Business Applications Summit 2019

13 June 2019

This week, we’ve got a monster tip for you – if you’re not aware, we’ve just had the Microsoft Business Applications Summit 2019, held in Georgia, Atlanta!


Power Query: Finding Fuzzy

12 June 2019

Welcome to our Power Query blog. After last week’s adventure in Power BI, I discover the fuzzy features of Excel Power Query.


Power Pivot Principles: Introducing the SEARCH Function

11 June 2019

Welcome back to our Power Pivot blog. Today, we introduce the SEARCH function.


A to Z of Excel Functions: The FIND Function

10 June 2019

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


VBA Blogs: Shape References

7 June 2019

Welcome back to the VBA blog! This week we are going to cover something we’ve had to do in one of our consulting jobs. It is a little niche, but it may be a good source of inspiration for some of us.


Power BI Blog: Key Influencers Binning

6 June 2019

Welcome back to this week’s Power BI blog series! This week, we’re going to look at Binning support for Key Influencers, a new feature that came out with Power BI’s May 2019 update.


Power Query: Fuzzy Matching

5 June 2019

Welcome to our Power Query blog. Today, I am going heading off into Power BI for a feature I’d like to see more of in Excel Power Query.


Power Pivot Principles: Introducing the CONCATENATE Function

4 June 2019

Welcome back to our Power Pivot blog. Today, we introduce the CONCATENATE function.


Challenges: Monday Morning Mulling: May 2019 Challenge

3 June 2019

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