Welcome to Power BI Tips. Following on from last week, creating our first visualization, a clustered column chart

Welcome to our Power Query blog. This week, I take a look at how to pass Excel data as a parameter in Power Query.

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.