What Excel functions do I need to know for Trading Assistant/Market Support Analyst role?

Hi all, this is my first post. Forgive me if this qn has already been asked.

I'm looking to apply for a jobs as Market Support Analyst and Trading Assistant/Assistant Trader at a trading firm.

The job requires me to be an intermediate user of Excel, including knowing how to process, analyze and present data.

This is the job scope if it helps:

 - Providing first level support and control for trading desks

 - Validating contracts between trading desk inputs against external sources

 - Monitoring irregular trading transactions i.e. late bookings, amendments  or cancelled trades without justification etc.

 - Tracking month to date deals for cost reporting

 - Monitoring the feeding of electronic executed trades for fail trades including application uptime

 - Assist in trade life cycle event management such as exercise, fixing, expiry, early termination etc.

 - Tracking for corporate actions and event driven scenarios

 - Assisting in queries and issues raised by internal or external stakeholders i.e. accounts, finance, brokers etc. 

 - Assisting in amendment or cancellation of booking when as required

 - Performing end-of-day reconciliation between external sources and system inputs

 - Performing end-of-trade day session reporting for trade statistics

  - Managing documentation and administration for business processes

I haven't been using Excel in years because I was in a different industry that didn't require it.

What Excel functions do you recommend I learn for the job?

Thank you.