One thing about Sheets vs. Excel: Appscript for automation is a lot easier to get set up with than VBA ever was to the point where my org has a ton of things that we just throw a small amount of Appscript at (E.G. generating performance reports) because it just works and it doesn't require a lot of processing power (yay, cloud!)