Certainly. I only rarely use excel on these. However, given that there are square, triangular, and Fibonacci numbers, some sort of table is likely to make the solve quicker. I’d prefer to just look up those tables rather than messing with excel.
If you would rather not use tables at all, here are a couple of suggestions. The formula for the nth triangular number is n(n+1)/2. Because of the form of Fibonacci numbers, they get much farther apart, so there really aren’t that many 4 digit ones, relatively speaking.