Please note javascript is required for full website functionality.

Blog

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 Blogs: 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.


Power BI Blog: Excel-sior - Part 1

15 February 2018

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


Power Query: Setting a Better Example

14 February 2018

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


Power Pivot Principles: Importing from an Access Database

13 February 2018

In this post, we discuss how to import data from an Access database.


A to Z of Excel Functions: The CORVARIANCE.P Function

12 February 2018

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


VBA Blogs: Having a Row

9 February 2018

This is the eleventh blog in the series about using ListObjects to manipulate Tables within an Excel workbook in VBA. Today we will be looking at all the commonalities between ListColumns and ListRows on the Item level.


Newsletter