How-to Video 3: Combining and Separating Data Fields in Excel
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.
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.
More Operations
How Dakota County Built a More Structured Fleet Operation
Kevin Schlangen shares how Dakota County’s fleet moved from reactive repairs and limited oversight to a more structured approach built around planning, training, and long-term cost control.
Read More →
Is Your Fleet Ready Before the Storm Hits? | GovCast Cheat Sheet
Could better preparation before a storm and new vehicle technology help fleets recover faster while improving safety?
Read More →
New York City Orders Safety Technology for Municipal Fleet
New York City is expanding the use of pedestrian alerts and intelligent speed assistance across its non-emergency fleet. The executive order establishes new technology requirements for future vehicle purchases while accelerating retrofits on thousands of existing municipal trucks.
Read More →
The Network Behind Better Government Fleet Decisions
A discussion on why relationships across the government fleet community have played such an important role and what shapes the leadership response.
Read More →
Ford, BlackRock, Google and Carhartt Form Skilled Trades Workforce Alliance
The alliance plans to develop a stronger pipeline between training programs and available jobs while examining workforce efforts already underway across the country.
Read More →
The Network Behind Better Government Fleet Decisions
A discussion on why relationships across the government fleet community have played such an important role and what shapes the leadership response.
Read More →
What Makes Fleet Technicians Stay? | GovCast Cheat Sheet
The technician hiring and retention discussion is not new, but the way fleets respond to it continues to matter.
Read More →
On the Road with Government Fleet: Essential Podcasts for Professionals
Let's celebrate listening! Check out a GovCast podcast and discover the insights and strategies that can transform your fleet management approach.
Read More →
How Real-World Vehicle Use Guides Replacement And Budgets
Three public fleet leaders explain how they use real-world vehicle data and long-term planning to keep aging assets in service and make more informed replacement and budgeting decisions in a high-cost environment.
Read More →