I work with this type of scientists, supporting them in an IT capacity. Many of them do try to learn Python, I've been quite impressed by it, but realistically Excel isn't going away any time soon regardless. Sometimes it's the right tool for the job.
(Certainly possible, I teach "I don't want to be a programmer"-types all the time. Taught a class this week in fact.)