Need some commodities sales trader advices
Hi all,
About to start a sales internship in an european energy company in two weeks and I am little worried about what should I know about Excel. I learned all the products the company is working on and I follow the different markets (oil&gas, energy, coal) but it's not enough. I know that Excel is really important but I don't know what should I learn to help a sales. I wonder what formulas on Excel are essential as an intern, and what should I know about VBA ? Some people told me about Match, Vlookup, Hlookup but without explaining anything.
Thank you.
I don't really do sales, but I do trading in commodities, so what exactly will be your role, as in what will you be doing?
First, I will do lot of pricing for the clients, it will be the most important task and I will do it a lot.
Then some minor tasks like: execution of flow business orders, production of sales performance reportings, qualitative analysis, data analysis and statistic production. Various types of analysis and monitoring.
Yes I have excel and vba for dummies, but I wanted to know if some formulas are mandatory.
i think there is a book called Excel for Dummies. sounds like that is what you need.
GDF?
Honestly you don't really need to know much on Excel going in, it's much easier to learn by trial and error (and Google). If something seems too asinine to do, there's probably a formula for it.
IF, SUMIF and SUMPRODUCT are probably worth looking into before hand so you have a basic idea of what they can do. Pivot Tables as well (though I tend to avoid them since they're such a black box).
Also, this is just me but I'm a big fan of Index-Match as opposed to VLookup, seems a lot more resilient.
Yes GDF !
Ok thank you, so I don't have to worry about Excel, I will learn during the internship. I wanted to be ready and as efficient as possible. I guess each company has a software for pricing ? and Excel is minor ?
Alright I will work on these formulas. There are good videos on youtube for that. For pivot tables too.
I'm learning all of them, I think that if I master these formulas it will help and I will understand if they ask me to use them.
Btw I don't work at GDF but in metals trading. Still I can't imagine they're asking for too much more on excel. The thing is it's almost impossible to learn stuff on Excel unless you're doing it within the context of a project.
I agree with you. But I can check some videos or stuff on the internet about how to use them.
Do you think VBA is important at this point or it is useless ?
Certainly not useless, maybe try recording a few macros and looking at the code.
Qui optio velit laudantium recusandae consectetur quis. Facere id corporis iste ab. Doloribus aperiam quam provident velit et tempora earum molestiae. Est dolor quidem corporis enim aliquam.
Autem ipsum earum pariatur laudantium voluptatum enim consequatur culpa. Dolores distinctio placeat rem nesciunt et. Consequuntur et nihil tenetur ducimus voluptas. Et sit harum reprehenderit aut.
Minima veniam molestiae et eos. Facere minima at sed qui quia officiis nihil. Iure ea eos sint qui nihil voluptate sed. Optio quidem aut quia.
Consequatur ut qui deleniti eum voluptatem quaerat. Alias ut itaque ut officiis. Nihil consequatur asperiores exercitationem ab. Cumque ut est ducimus labore commodi ea quis. Voluptatibus aliquid suscipit hic recusandae aut eaque. Repudiandae nesciunt dolorem omnis enim alias ut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...