First things first, if you want to feel like an Excel pro and impress all your friends, you'll need to be armed with an arsenal of shortcuts. Nothing bar nothing is going to make you feel like more of a spreadsheet ninja.
So, here goes, in no particular order, some of the most useful shortcuts you'll need:
Ctrl+` - Reveals all of the formulas used in each box, you can use to toggle between the results and the formula (that strange little symbol is a 'backtick', or, a 'grave accent' - which first appeared in the polytonic orthography of Ancient Greek to mark a lower pitch than the high pitch of the acute accent)
Ctrl+Shift+7 - Quickly and simply draw a border around one or more cells
Alt+E+S+V - After copying a value, use this to paste just the value into a different cell, without carrying over the formatting or any other pesky attribute
Ctrl+Spacebar - This is a quick way to highlight all the values in a column
Shift+Spacebar - How to highlight all the values in a row
Ctrl+Alt+V - Transpose a column into a row with this paste special - after using the normal copy command, use this shortcut in the leftmost cell of the row you would like to paste into, and then simply select the 'transpose' option and see your cells jump into a horizontal formation.
Ctrl+T - After selecting the relevant data, turn it immediately into a table with this shortcut