For brokers who currently do not use a Point of Sale to create their export file and manually edit their csv file.
Here is a very good video tutorial for Excel demonstrating the 10 most important features of Excel.
The two most important things brokers need to know (Autofilling numbers and sorting) are covered in the first 2 examples and the rest is pretty much bonus free training. It also covers finding duplicate records which is helpful to find and isolate duplicate TIcketID issues.
Download the attached sample MyTickets.csv file if you do not have a file to work with.