...I'm hoping to find a software that doesn't require me to be some sort of video editing major.. but still let me do things such as motion tracking, and video-in-a-video scenarios.
... I'm pretty new to video editing -- I've been using windows movie maker (bleh!) so.. if you can pretend your talking to a five-year-old, that'd be awesome...
I installed the trial to see if this was the software for me, and I threw in some video clips...Confused!
Well, sir or madam five-year-old, I'm not surprised one bit that you're confused. You've downloaded perhaps the most feature-packed and detail-reliant piece of multimedia software on the market.
You can NOT pick up a couple of tricks to use in AE with a guarantee of success. You can NOT expect to use AE intuitively and expect success. That's just the nature of the application. I'm not joking: many have tried to do so and many got frustrated and gave up. That's a shame because it's great software.
You need patience to use After Effects, because you nave to learn the basics. Here is an excellent source for learning those basics.
And don't expect to get everything overnight. AE knowledge is a journey, not a couple of lessons.
Just so you don't think that Dave's alone on this one, I thought I'd chime in.
In computer programs, a general rule is that the ease of use is inversly proportional to the power of a program - and After Effects is a very powerful program.
Now, the tasks you are asking about may appear to be fairly simple - HOWEVER, they rely on a fairly well-developed skill set as a foundation. You absolutely can not just start poking around in After Effects and figure things out or just learn a few things in it that will make you successful. There is a reason some of us get paid a liveable wage for using this software. Dave has pointed you to a great beginning resource. Here's another (note, this series does continue beyond what's linked on this page, so check the rest out when you finish with these).