Most of the macros you will be writing for Spreadsheet will involve fetching and setting the values, formulas and formats for cells within a spreadsheet. You'll also need to know how to open and create workbooks and deal with worksheets.
See:
Working with cells
Working with Ranges
Working with worksheets and workbooks