Excel Noob Checking In

I've been at an internship with Schneider Electric for about 2 months now and have been using excel quite a bit! As an engineering major I have used excel for basic calculations and data storage for a while, but this internship requires a whole new understanding. Not because of the work I do, but because I want to make my intern project something the company uses until I come back in the winter. This requires learning how to use macros that allow data transfer between worksheets easy, for the common employee, to understand. I'm here to learn baby, learn!