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

This week in our series about Microsoft Excel for Mac, we show you an important tip about ‘Flash Fill’. On Mac, it’s one of those things that you need to know. If you know, you know. If you don’t know, then ‘Flash Fill’ won’t help you.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how selection expressions – and their behaviour in particular – is changing for calculation groups.

Welcome to our Power Query blog. Today, I continue to create a refreshable revision timetable by calculating how many times each topic should be included.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INFO.ALTERNATEOFDEFINITIONS.

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us with your preferred solution.

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI 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.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at some of the latest updates made in assisting you edit your data model in Power BI Service.

Welcome to our Power Query blog. Today, I continue to create a refreshable revision timetable by calculating the number of slots available.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INDEX.