Working with Excel Lists: Tracking Vehicle Data (Part One)

Excel techniques used:

• Freeze rows and columns
• Find and replace values in a worksheet
• Create a list range
• Sort data in a list using sort button, AutoFilters, and sort command
• Add data using insert row and data form
• Filter data in a list using custom AutoFilters
• Apply conditional formatting to a range
• Use the total row to calculate totals in a list

(Zoom in by clicking the pictures)