Power Query – Bichon Associates

Consolidating Excel Worksheets with Power Query

Adding together data scattered across many worksheets is a common Excel challenge. In this article we’ll show a clever and flexible way to tackle this using Power Query.

Power Query Basics – Automating a Foreign Exchange Rate Feed in Excel

In this article, we’ll walk through how to build an Excel spreadsheet using Power Query to pull foreign exchange rates from the Bank of Canada’s website. Even if you’ve never used Power Query before, in 15 minutes or less you’ll get a basic understanding of the tool and be left with a useful automated exchange rates spreadsheet.