I just did this today. No notarizing needed in Wisconsin at least.
Back of the title needed to be signed by both parties, dated, and current mileage.
I had to fill out a form (printed from the dmv website).
It could have been mailed if I had a set of plates to transfer, but I didn't. I went in and the total process including waiting took about 15 minutes.