Menu
Archive for February, 2018
{ 4 Comments }
How windy is Wellington? – Using Power Query to gather wind data from web
Published on Feb 22, 2018 in Power BI, Power Query
Let’s take a whirlwind trip to coolest little capital – Wellington. It is a windy place, so hold on to your hats and spreadsheets.
Almost everyone who spends more than 2 days in Wellington would agree that it is a windy place. But how windy is Welly? In this two part series, we will use Power Query, Excel charts and coffee to answer that question.
But, first let’s start with a joke.
What happens when you throw a boomerang in Frank Kitts Park?
You will have to buy another one, coz you are not getting that one back.
Continue »{ 246 Comments }
VLOOKUP(), MATCH() and INDEX() – explained in plain English
Published on Feb 10, 2018 in Featured, Learn Excel
VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton of time. In my opinion understanding VLOOKUP, INDEX and MATCH worksheet formulas can transform you from normal excel user to a data processing beast. Today, […]
Continue »
