|

What hiring managers and recruiters are looking for

This video surprised me: I had no idea that financial types had progressed further than just using VLOOKUPs and Pivot Tables.

Leila Gharani’s video on Excel interviews

I thought Pivot Tables would be part of the landscape for those in finance but Power Query, Power BI, simple and advanced VBA? Match and Index?

Wow.

There is also “removing duplicates” which I don’t recall having to do, or at least very infrequently. My take on duplicates is: if the original source contains duplicates, take out the duplicates in the original source and then re-run your download or access. There must be something else going on that compels people to remove duplicates in the Excel.

A lot of the things Leila talks about I already use but there were a few functions that I didn’t know: AGGREGATEs and the newer 365 functions such as XLOOKUP. The AGGREGATE I just learned is very similar to SUBTOTAL but has some advantage over SUBTOTAL. And I just found out that the online Excel has some of the 365 functions which I don’t think were there before. I think Microsoft changed the online Excel and made some functions available so I’m going to have to play with the online version to get familiar with XLOOKUP, UNIQUE and FILTER. Those functions are the ones that come to mind.

So much to learn and so little time.

Similar Posts