Need some good recommendations for learning advanced excel including macros.
You may explore...
MS Excel 2019 Bible by Michael Alexander, Dick Kusleika. This is sort of bible so it will cover a lot of things including basics to advanced including some focus on VBA macros and programming. (This is over 1000 pages)
Excel 2013 Power Programming with VBA - John Walkenbach (This is also over 1000 pages and goes very much in depth of VBA)