Please note javascript is required for full website functionality.
MVP

Blog

Blog

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


Power Query: Functional Query

3 April 2019

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


Power Pivot Principles: Conditional Custom Columns Using IF, AND, and ‘&&’

2 April 2019

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


Monday Morning Mulling: March 2019 Challenge

1 April 2019

On the final Friday of each month, we set an Excel problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Final Friday Fix: March 2019 Challenge

29 March 2019

On the final Friday of each month, we’re going to set an Excel challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for...


Power BI: Custom Visuals – Infographic Designer

28 March 2019

Welcome back to the Power BI blog series! This week we are going to take a look at the Infographic Designer, typically one of the featured custom visuals on the marketplace.


Power Query: Types of Value

27 March 2019

Welcome to our Power Query blog. This week, I introduce more Value() M functions; Value.Type() and Value.ReplaceType().


Newsletter