Please note javascript is required for full website functionality.
MVP

Blog

Blog

VBA Blog: 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: 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 Blog: 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: 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.


Newsletter