LI: To use a variety of software to create programs that accomplish specific goals
As budding data scientists, we have now done a lot with our data. We have learnt how to read it, clean it up, analyse it and even visualise it!
However, we can do more! Today we’re going to look at some advanced formulas that will take our skills on Excel to the next level.
The formula we will look it is named: XLOOKUP. This allows us to type in what we want, and it will return it.
Task
Use XLOOKUPs to show the temperature by month for each city. When you type in the box, ‘Peterlee’ it should then deliver all of the details for Peterlee.
Help!ChallengeVocabulary