Imagine a weekly task of sending out a simple report. To do this you rely on data from someone else. When the layout of the data changes chaos reigns! What can we do? Continue reading
Data Disaster: non normalized data
Posts Tagged → vlookup
Excel data concept taught backwards
I’ve been a data analyst since 2001. It’s often challenging to accurately & quickly explain certain concepts. There is one that is a classic. I’m going to explain it with the help of Hugh MacLeod’s book “Evil Plans”. No nerdy data terms. The concept first. Continue reading
True Vlookup Tragedy
The vlookup function is often used to prove a bare minimum of Excel knowledge because it’s both useful and common. Continue reading
Video 00137 Vlookup_Returns Multiple Values
Vlookup returns only 1 value, right? Well…normally yes but there are some tricks to return multiple values (numbers) and add them up. Continue reading
Video 00017 VLOOKUP Introduction Part2
This video reviews two parameters of Excel’s vlookup function (‘col_index_num’ and ‘table_array’). Continue reading