Today we discuss what are relationships (in Power Pivot) and how we may create them...

Last week, we asked how you could set up a cell to pick up text from parts of an Excel spreadsheet, and present it in a ready-for-email form.

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

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.