Please note javascript is required for full website functionality.

Blog

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.


Power Query: Interactive Query

10 April 2019

Welcome to our Power Query blog. This week, I look at how to make a functional query more interactive.


Power Pivot Principles: Conditional Custom Columns Using IF, OR and ‘||’

9 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to create conditional custom columns with multiple criteria… again.


A to Z of Excel Functions: The F.INV.RT Function

8 April 2019

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


VBA Blogs: Common Traps 1

5 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 Model Tab

4 April 2019

Welcome back to the Power BI blog series! This week, we’re going to talk about the new updates to the Relationship tab that was made generally available last month.


Newsletter