Is it safe to assume you have no prior inexperience with this type of program? I guess most users here have used game maker/multimedia fusion/ect before so Construct is just a nice upgrade. But yes, for a person fresh into this it can be overwhelming, because Construct is powerful. Lucky for you we have a friendly, helpful group that is growing, and everyone is friendly and ready to help!
The best thing to do early is try to clone pac-man, pong, breakout, ect, then slowly build up to more complex stuff. I know, I know, you want to make Final Fantasy VII 2, but you gotta get the basics down first!
I'll gladly make an example cap of something simple (or a basic platform tutorial) if you want. I'm not the best instructor though Just gimme a few hours, and I'll post a few.