I’ve been a CPA for a decade and don’t use a numpad, though I have to give credit to World of Warcraft for my ability to hit any number with ease. I’ve found you will be most efficient when you never have to leave home row with either hand, so learning to use a trackpoint also helps.
As a CPA I can attest Excel is really useful for financial data analysis and problem solving. It takes time to learn, and there are limitations to manage, but when you know what you’re doing it really gets out of your way so you can focus your attention on the work product instead of the tool.
On how I got efficient, when I started my career I tried to optimize any task I had to perform repetitively, and after 3 years everything was pretty fast. After that I tried to optimize one process every month, and now I have a pool of ideas to pull from when problem solving.