Translations:Basic Excel Trainer/109/en

Step2

  1. Delete the following columns:
    • D ('GPS POSITION')
    • B ('No')
  2. Insert a row above (existing) row 3.
  3. Insert a column between (existing) A and columns.
  4. Enter the new column headers in the appropriate cells in row 3.
    • The order of the columns doesn't necessarily match the order of the listed fields. Match the fields to their appropriate data; we can reorganise the order of columns later.
  5. Delete rows 1:2.
  6. Make a copy of the worksheet, place it at the end, and name the copy STEP3.
  7. Save the workbook.