I've never understood this ebay API development environment and what (if anything) I would be able to do with it.

Is there some reading material or even a Youtube video that can explain what its all about at a top level.

e.g. could i develop a small applet to interface my Excel accounting spreadsheet with my ebay account, so it can extract relevant accounting ifoormation directly into my spreadsheet?