I'm working on a handful of guides designed for brand new users. Pokemon Essentials is a fantastically powerful toolset, but it is really lacking basic documentation. These guides will include walkthroughs of all of the functionality of the Editor, which should be enough help to get people up and running even if they don't necessarily know how to use RMXP.
After I have finished documenting the functionality of the Editor, I plan to do a full walkthrough of creating a small region. This will likely be a clone of Fire Red, running from Pallet town to Pewter City. That should give me enough room to experiment with all of the game's basic features, and should give enough specific examples to round out any gaps in the Editor documentation.
Update: External Editor guide is online. It is essentially a table of contents, but it's helpful if you're not sure where to look or what to search for. It links to existing articles which had much more comprehensive content than I would have been able to write myself.