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

Welcome back to the VBA blog! This week we are going to learn how to group specific rows by using VBA.

Hello there! We thought we’d take a break from our regular tips and tricks and thought we’d let you know we’re presenting at the Excel Summit South 2019 in Sydney…

Welcome to our Power Query blog. Today, I create a function to add a column to a table.

Welcome back to our Power Pivot blog. Today, we show you how the DATESINPERIOD function works.

On the final Friday of each month, we set a Power BI or 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.

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

Welcome back to this week’s Power BI blog series. This week, we are as far removed from financial modelling as we’ll ever be: we’re going to create a floor plan.

Welcome to our Power Query blog. Today, I look at a way to reduce overheads when combining numerous files.

Welcome back to our Power Pivot blog. Today, we show you how to create a dynamic ranking measure that changes based on selection filters.