Please note javascript is required for full website functionality.

Blog

Power Query: Are Any of Them on the Table?

26 June 2019

Welcome to our Power Query blog. Today, I revisit the data I looked at last week to extend one of my solutions.


Power Pivot Principles: Introducing the LASTNONBLANK Function

25 June 2019

Welcome back to our Power Pivot blog. Today, we will go over how to use the LASTNONBLANK function.


A to Z of Excel Functions: The FINV Function

24 June 2019

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


VBA Blogs: File Path Selector confined to CSV

21 June 2019

Welcome back to the VBA blog! This week we are going to expand on our blog from last week, relating to file path selectors.


Power BI Blog: June 2019 Update New Interface

20 June 2019

Welcome back to this week’s Power BI blog series! This week, we’re going to look at Power BI’s updated interface look.


Power Query: Is it on the Table?

19 June 2019

Welcome to our Power Query blog. Today, I delve into the Table.Contains() M functions.


Power Pivot Principles: Grouping Text Columns with New Categories

18 June 2019

Welcome back to our Power Pivot blog. Today, we will use the SEARCH and SWITCH functions to create custom columns that group text columns into new categories.


A to Z of Excel Functions: The FINDB Function

17 June 2019

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


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!


Newsletter