I would recommend using Lynda.com. We have free subscription as a student here at UW. They offer a TON of courses with helpful videos, transcripts of the video, and exercise files! It is a great resource!
I second what Megan said! My first internship involved some heavy VBA coding, and although I had no previous knowledge of the tool, through Lynda’s guidance I was able to create some fairly rigorous programs.
Learning VBA is definitely a good use of time over break. You will almost certainly recognize the opportunity to apply the tool in your future job or internship, saving lots of wasted time by doing so.