This week in our series about Microsoft Excel for Mac, we discuss how the destination folder is chosen when you save a copy of a file. This is also applicable to Word and PowerPoint. Be sure to pay attention to the folder destination when you do ‘Save a Copy’ or ‘Save As’ on a Mac.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how Copilot is assisting you to write DAX queries in DAX query view.

Welcome to our Power Query blog. Today, I continue to create a refreshable revision timetable by creating a list of all the subject slots I need for the timetable.

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.ANNOTATIONS.

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.