Government Fleet Top News

How-to Video 3: Combining and Separating Data Fields in Excel

November 26, 2012

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.

Comment On This Story

Name:  
Email:  
Comment: (Maximum 10000 characters)  
Leave this field empty:
* Please note that every comment is moderated.

FleetFAQ

Fleet Management And Leasing

Jack Firriolo from Merchants will answer your questions and challenges

View All

 

Public Fleet Tracking And Telematics

Amin Amini from Verizon Connect will answer your questions and challenges

View All

 

Fuel Management

Bernie Kanavagh from WEX will answer your questions and challenges

View All

 

Recent Topics

Hi everyone, don't forget to cast your votes for the Public Fleet Hall of Fame! Three industry veterans will be inducted this year, and...

View Topic

Hello to all the members I am checking to see if anyone is using a company for GPS/AVL called Fleet Complete (AT&T)? I would like to...

View Topic

Fleet Documents

1134 Fleet Documents (and counting) to Download!

Sponsored by

Established in 1986, Fleet Response creates custom-designed fleet management services for its clients.

Read more