ok, well I am free for the day so I will give you some tips.

first off, like everyone else said, frames are no good. They make it painful, and Flash navigation is a huge waste of time/navigation do to the fact that theres no point for it.

next thing, Way too much text. Add some more pictures to the white boring pages. (this is reffering to the How To tab and down)Seriously, the white page is so boring. If you want a banner on top and not have to redo it everytime, then please make a template. Also, the text all being centered makes it less interesting as well, the font doesnt fit your site, get rid of the Times New Roman style font.

Then.. Yes there is more, lol. Your How to/ FAQ sections; ok.. Dont put them in a drop down menu and then hit go. This isn't selecting a country. Instead, put them in a table, with the name and a much better/longer description of what you will learn, or what it is about in detail. You will help more people this way. Also, you pages are boring. Its the centered text all over the site. Do something else with it, change the font, change the size in some places. Make links to other pages using keywords, etc...

Now, there are probably other things people will find or tell you about. But if your friend doesnt fix anything this is what he needs to fix.

1. Give it some room to breathe. Everything is jam packed in there.
2. Give it some more color, pictures, or a font change.
3. Get rid of the Flash navigation, as for the rest, it is just a suggestion, but I think these are important.