Report Offensive Message

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.