Skills soft has an interesting course if you need data analysis. Big data power tools $31, I use to teach this type of stuff to IT professionals for a week at $2800 per student on discount.
Good if you want to use excel as a production planning tool. You need to understand recursion, for maximizing your schedule and minimize your inputs.
You can then post your master schedule to MS project and detail out your tasks and FTE requirements for each task.