For me the big one to get users onto is recognizing the multiple levels that exist within every cell
The formatting display layer
The formula display layer
The value display layer
Be aware of what layer you want to work with and anways use Paste Special so that you are only pasting the applicable layer you want instead of the vulgar crtl+v that blindly over-writes all layers with the copied content.
Keep Up with TechRepublic