This lesson is great for taking a deeper dive into using functions. The premise for the activity is students are pretending to be recently hired by a fictional radio station to clean up their archaic record-keeping practices. Students transform a disorganized, incomplete and mistake-ridden employee information spreadsheet using functions.
They use the power of some of Excel’s text manipulation and date calculation functions. It is a perfect follow up to Excel 2016 - Simple Functions - NBA Sa