Please note javascript is required for full website functionality.

Blog

Power Query: Inquiring Minds

17 July 2019

Welcome to our Power Query blog. In a plot twist, today’s blog is about how Excel can make Power Query data easier to handle.


Power Pivot Principles: Introducing the RANKX Function

16 July 2019

Welcome back to our Power Pivot blog. Today, we show you how use set up slicers to dynamically segregate text data based on text inputs.


A to Z of Excel Functions: The FIXED Function

15 July 2019

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


A to Z of Excel Functions: The FISHERINV Function

12 July 2019

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


Power BI Blog: Mekko Chart

11 July 2019

Welcome back to this week’s Power BI blog series. Over this week and next, we are going to create a beautiful visual: the Mekko Chart.


Power Query: Reliable References

10 July 2019

Welcome to our Power Query blog. Following on from last week’s look at duplicating and copying queries, today the topic considers referencing queries.


Power Pivot Principles: Grouping Text Columns with New Categories Dynamically using an Input Table – Part 2

9 July 2019

Welcome back to our Power Pivot blog. Today, we show you how use set up slicers to dynamically segregate text data based on text inputs.


A to Z of Excel Functions: The FISHER Function

8 July 2019

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


VBA Blogs: Create text file from Excel table

5 July 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: Waffle Chart (cont'd)

4 July 2019

Welcome back to this week’s Power BI blog series! This week, we’ll continue to have more fun playing with amazing visual effects of Waffle Chart.


Newsletter