Well, TESalliance has some very good tutorials covering modelling and texturing for Oblivion and Skyrim. Check out their site and have a look around. Most of their modelling tutorials are based upon Blender and Nifskope, though, because the program is free and has is very comparable to 3DS Max. As for textures, I started out by doing retextures of a few things for some mods I'm in the process of developing, and I'm just starting to make my own textures now for a mod that adds in clothing and weapons from RWBY, and a clothing mod for Legend of Korra.