One of the best features of Excel may be the Macro Recorder.
This allows you to learn how to code 80% of what you need to do without remembering or looking up syntax. You perform the function in Excel while recording and viewing the code. This give you samples. A good example is adding borders you a spreadsheet. Record adding borders, and then take the generated code and put it into a routine called AddBorders |