I tried to select a few books that I feel would suit most of you. They are also affordable.
If you buy them through this link, I will get a small commission. Thanks :-) from Amazon.
Here a very good reference. The bible for Excel is a book containing really a lot of examples and good explanations.
Excel For Dummies is a reference too, because we are all are sometimes Dummies, me included, and it is a good and not so expensive book.
Excel for Dummies Formulas and Functions version, goes into the details of essentials functions. A bit like ExcelMadeEasy but on paper.
Now VBA Books.
Visual Basic as you have seen is a big part of Excel. Here some books too.
We start with the dummies which is a good way to get a book on VBA.
The next one is interesting for those who would like to learn not only Visual Basic for Applications which is linked to Microsoft suite, but also Visual Basic which is a language you can run without having the microsoft office suite.
O'Reilly has always good books and this one is no exception. A good insight into Macros with some good examples.
Excel Power Programming with VBA gives you good advices and training.
Also do not hesitate to read a REAL book about Excel. A book
is the way to have a good and well know reference always next to you.