Friday is normally our VBA blog day, so for this week’s Final Friday Fix, we’re going to look at a problem that is fairly easy to solve in VBA, but a bit more challenging in Excel…

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

Welcome to Power BI Tips. Following on from last week, cleaning up the data using the Query Editor.

Welcome to our Power Query blog. This week, I take another look at what I can do with Excel.CurrentWorkbook.

Today we discuss formatting and changing table properties.

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

This is the twelfth blog in the series about using ListObjects to manipulate Tables within an Excel workbook in VBA. Today lets look at the unique properties of ListColumn.

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

Welcome to Power BI Tips. Today we're going to Get Data with an Excel file.

This week, I take a look at the latest improvements to the ‘Add Column from Examples’ functionality...