What’s Your Favorite Excel Function?

Published on April 9, 2017

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.

Tomorrow we'll #concatenate and cleanse in class. I need a shirt that says that. ??? #excelismagic

A post shared by Emese Felvegi (@felvegi) on