Please note javascript is required for full website functionality.
MVP

Blog

Blog

Monday Morning Mulling: February 2018 Challenge

26 February 2018

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.


A to Z of Excel Functions: the CSCH Function

26 February 2018

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


Final Friday Fix: February 2018 Challenge

23 February 2018

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…


A to Z of Excel Functions: the CSC Function

23 February 2018

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


Power BI Tips: Excel-sior Part 2

22 February 2018

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


Power Query: Returning to Referencing Ranges

21 February 2018

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


Power Pivot Principles: Importing from an Access Database (Continued) and Formatting Data

20 February 2018

Today we discuss formatting and changing table properties.


A to Z of Excel Functions: the CRITBINOM Function

19 February 2018

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


VBA Blog: Can't Row with a Column

16 February 2018

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.


A to Z of Excel Functions: the CORVARIANCE.S Function

16 February 2018

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


Newsletter