TEMPE, AZ – Video 3 of Aaron Alvarado’s how-to video series on presenting fleet data details how to combine and separate data fields in Excel using the concatenate/de-concatenate function. Using a formula to separate fleet data into appropriate columns will allow viewers to better manage data.

This is the third of a five-part How-to video series on presenting data for fleet benchmarking, presented by Alvarado, fleet manager for the City of Tempe, Ariz. Alvarado has covered how to graphically depict idle time and how to embed this graph into Excel. Next Monday, he will review forecast modeling.