Please note javascript is required for full website functionality.

Blog

Power Query: Exceptional Cases

24 April 2019

Welcome to our Power Query blog. Today, I am going to look at how to protect specific data when transforming text case.


Power Pivot Principles: MAXX

23 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use the MAXX function.


A to Z of Excel Functions: The FACT Function

22 April 2019

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


VBA Blogs: Common Traps 3

19 April 2019

Welcome to this week’s VBA blog! In line with previous months, we’re going to keep this month’s blogs on a theme, and this month’s theme is all about common errors and issues that people run into.


Power BI Blog: Data Profiling Generally Available

18 April 2019

Welcome back to the Power BI blog series! This week, we’re going to look at a tool that we’ve covered before, but is now generally available and has some neat improvements.


Power Query: Files for Today

17 April 2019

Welcome to our Power Query blog. Today, I am going to select files using the date embedded in the file name.


Power Pivot Principles: Conditional Custom Columns with Four Categories

16 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to create conditional custom columns using the AND ‘&&’ and OR ‘||’ operators together.


A to Z of Excel Functions: The F.TEST Function

15 April 2019

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


VBA Blogs: Common Traps 2

12 April 2019

Welcome to this week’s VBA blog! In line with previous months, we’re going to keep this month’s blogs on a theme, and this month’s theme is all about common errors and issues that people run into.


Power BI Blog: New Highlighting and Filtering Icons

11 April 2019

Welcome back to our Power BI blog series! Just a short one, this week, we thought we’d highlight a graphical change to the way interactions work with highlighting and filtering.


Newsletter