In a previous how to video, we learned how to clean and tidy data in Excel using functions like VLOOKUP. In this how to, we will look at how to summarise that data to answer specific questions using the PivotTable utility in Excel.
Viewing entries in
The VLOOKUP function is a straightforward way to merge data in Excel. I use it daily to combine two different dataset when a simply copy and paste just won't do. The most common reason for that is different numbers of rows (entries) between the two datasets we're working to combine. For example one dataset might be a list of people and their job title, the other might be a list of phone calls, with the same person dialled more than once. In that case we could use VLOOKUP to append the list of phone calls with the job title of everyone who is called.