Quite a few students with recent interview experiences have told of a recurring question: “What is your favorite Excel function?”
Spend a few minutes to reflect upon this, be ready to discuss a function or feature with examples. Where did you use it? What data did you process? Why is it useful?
I’ve done my fair share of data entry and cleaning, have found text functions super useful. One of my all-time favorites is CONCATENATE, it joins two or more text strings into one. See examples and best practices at the official Microsoft site.