I think we should gather tutorials in one thread so new additions to the core can get help from this list!
3D / Modelling
Modeling a tree crown with ease - Text
CryENGINE 3 SDK
Realistic Glass - Text - Video
Parallax Occlusion Mapping - Text - Video
Getting started in CryENGINE 3, First object - Text
Great video tutorial sites (Costs money, some tutorials are free though!)