There are 2 tutorial sections that should be considered priceless for you Hive.
The first is the 2da editing tutorial where there is at least 2 tutorials that would be 100% useful for the questions in your first set of questions one is by Stoffe and it explains the appearance.2da file it's columns and what they are used for. The other is by myself which walks you through from beginning to end the process of creating new playable characters in the game. The elements in the tutorial I provide are 100% useful when creating a non-recruitable NPC in the game by omitting anything involved in changing the portraits.2da file. For Recruitable NPC creation you will have to tweak the portraits.2da file for it to be right and proper.
Now the 2nd section that should be your friend and companion is the scripting section. As for adding your NPC in game should be handled through scripting. I would avoid using the module editor process untill you are completely ready to build your own areas. Even then I would still rely upon testing with scripting before hard placing a character into a module through the module editor.
Also the general tutorials section has the original getting started tutorials thread that has links to old threads that walk through many of the other various aspects of NPC creation and scripting to place your NPC in game.
Here are those 3 subforums.
General Tutorials ->
http://www.lucasforums.com/forumdisplay.php?f=592)
2da editing ->
http://www.lucasforums.com/forumdisplay.php?f=596)
Scripting ->
http://www.lucasforums.com/forumdisplay.php?f=597)
Here are some useful threads from those subforums.
Appearance.2da Walkthrough ->
http://www.lucasforums.com/showthread.php?t=148638)
Creating a New Appearance ->
http://www.lucasforums.com/showthread.php?t=149992) (It has pictures)
Spawning items, creatures, placeables ->
http://www.lucasforums.com/showthread.php?t=143536)
Do you want to mod SW-KOTOR ->
http://www.lucasforums.com/showthread.php?t=151013)