New job, new skillz

I'm teaching myself to use Excel to help me in my new job (planning for a printing company), because I get grids from customers and CSRs, and I can input data into our imposition program with CSV files. So I'm figuring out how to get from point A to point B by manipulating that data rather than entering it manually (which is how we've been doing it thus far). I had some experience years ago creating and using macros in Word to pre-format text from author manuscripts to pull into a typesetting program. So I'm looking at ways I can do that in Excel, and also just generally how you move stuff around, combine and/or separate data, so I can put it in a format my imposition software can understand. Currently I'm copying and pasting, and searching and replacing, but I know I can do a lot more.