Welcome back to the VBA blog. This week, we are going to learn how to use VBA to filter a data table based upon multiple criteria.

Welcome back to this week’s Power BI blog series. This week, we are going to look at a few ways to export data from Power BI.

Welcome to our Power Query blog. Today, I use Column From Examples to help me put my data into grade boundaries.

Welcome back to our Power Pivot blog. Today, we look at the EARLIER function.

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

Welcome back to this week’s Power BI blog series. This week, we are going to look at the Key Performance Indicator (KPI) visual.

Welcome to our Power Query blog. Today, I look at a way to create a set of data from multiple tables.

Welcome back to our Power Pivot blog. Today, we look at how to create a PivotChart that highlights the number of absent students in university classes.

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