Excel Again

I'm trying to figure out one of my work projects, the one based on data analysis.  I feel so tantalized because I know I can do all this in excel, but I just don't know how.  I've spent the last hour trying to teach myself how to do a pivot table, and it almost does what I need, but not quite.  It's really frustrating.