I wanted to suggest a few books that I’ve used in the past which are extremely helpful in learning Excel. I’d recommend checking any one of these books out as they have lots of useful information and examples for how to get the most out of Excel:
The last book is specifically related to Macros and involves programming with VBA (Visual Basic for Applications). I would recommend any of these as self-teaching tools for doing additional learning outside of my lessons. Many of these have earlier 2007/2003 counterparts which would be good if you have that version of Excel.
Additional Excel Online Training Resources