Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power BI Tips: 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 Blog: 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.


A to Z of Excel Functions: the COVAR Function

9 February 2018

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


Power BI Tips: Get Data – Connecting to Different Data Sources

8 February 2018

Let’s start using Power BI. Power BI is a data visualisation tool so the first and foremost thing that needs to be done is to get some data into Power BI.


Power Query: Cell Referencing

7 February 2018

Welcome to our Power Query blog. This week, I take a look at how to reference a cell in an Excel workbook from Power Query.


Power Pivot Principles: Filtered Imports

6 February 2018

Today we look at filtering the data a little before importing it form Excel.


A to Z of Excel Functions: the COUPPCD Function

5 February 2018

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


Newsletter