# Finding my way around Excel functions

6 December 2021

I am really not a big fan of Excel but there are situations where I cannot avoid it. It becomes very frustrating to not be able to program all what I could do with Python/Pandas.

Today, I managed my way around with functions found on this website: my use cases revolved around:

• concatenating strings with the & operator;
• finding a line matching a regexp in a different sheet with MATCH;
• build up the string for a cell reference with INDIRECT.