Past Special>Formats is useful when you spend time setting up a sheet with customized formatting and then you need to make the sheet expand over/down.
Data>Remove Duplicates is useful when you have rows containing line items and you want, say, all the “names” in one of the columns. It’s quicker than making a pivot table, which is the other way I know how to do it.
Home>Wrap Text can be thought of as a button with the same functional semantics as Bold or Underline, that is, it’s either on or off for any given position in the document. It does what it says – if you enter more data than can fit in a column horizontally, and wrap text is in the ON state, then the text will wrap, taking up additional vertical space.