what aspects of excel do i need to know for monitoring traders

rascal07

Junior member
Messages
17
Likes
0
Hi guys what aspects of excel do i need to know for monitoring traders? I have a job interview next week for trainee role for an oil company where i have to take an excel test.

Taken from the job spec
This role is focused on supporting the Trade Control Team. The team provides real-time front-line control and management information for management, vessel charters and traders. This includes daily profit and loss measurement, trading exposure reporting, and risk reporting. Because of the unique position of the team in the middle of ETS’s commercial activities, the team will also support broader commercial activities.

Key Responsibility Areas:

- Ensuring that analytical documents are kept up to date
- Generating trade logs
- Monitor vessel charters and traders’ adherence against their delegated authority
- Analyse and investigate results obtained from the underlying data

If any1 could give me a heads up it would be very much appreciated!
 
i think if you can master the fundamental formulas and how to build xls sheets with them you will be ok.
 
Top