Financial Modeling Tip – The Pyramid Principle Financial modeling spreadsheets can quickly become unwieldy when analyzing complex business problems or dealing with large amounts of underlying data. In this article we share a structured approach for designing Excel models that has proven to be quite useful over the years – we call it the “PyramidContinue reading “Financial Modeling Tip – The Pyramid Principle”
Tag Archives: Data Analysis
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.
Bichon Associates 