by John MacDougall | Oct 30, 2017 | Templates
This template allows you to pull data from Moz Open Site Explorer (OSE) into Excel using Power Query (Get & Transform in Excel 2016). Moz OSE is an online tool that allows you to see what sites link to a given site (known as a backlink). Links to a site is...
by John MacDougall | Oct 30, 2017 | Pivot Tables
Excel isn’t a database, but that hasn’t stopped people from using it as one. People have been doing this since early versions of Excel and creating relationships between different tables using VLOOKUP or INDEX and MATCH. The good news is that more and more...
by John MacDougall | Oct 15, 2017 | Pivot Tables
Pivot tables are awesome! They’re one of Excel’s most powerful features, they allow you to quickly summarize large amounts of data in a matter of seconds. This collection of awesome tips and tricks will help you master pivot tables and become a data ninja!...
by John MacDougall | Oct 7, 2017 | Power Query
At work this week, I needed to compare two tables to see if the they had similar data. The problem was they were aggregated at different levels with different dimensions and some data in table A was not in table B and some data in table B was not in table A. I needed...
by John MacDougall | Oct 2, 2017 | Formulas
Example =PI()*POWER(C3,2) Download Example File Generic Formula =PI()*POWER(Radius,2) Radius – This is the radius of the circle which you want to calculate the area of. What It Does This formula will calculate the area of a circle given its radius. How It Works...