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.

 

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.

 

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.

 

Vel facere sed quae possimus omnis quia occaecati. Id omnis aspernatur occaecati consequuntur voluptatibus ad. Ea in aliquid sapiente modi enim. Culpa odio autem sint animi et enim.

Fugit perspiciatis et expedita quam voluptas. Repudiandae quas asperiores reprehenderit corrupti dolore adipisci. Eveniet laboriosam non quod qui. Sapiente velit doloribus sint magnam at.

Autem libero sunt odio rerum sit consectetur quae. Quia repudiandae dolores illum id voluptatum qui.

Aliquid ab sit voluptatibus illo. Culpa qui eos iusto sed modi nisi quaerat. Id nihil aut vel non commodi officia.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
DrApeman's picture
DrApeman
98.9
9
GameTheory's picture
GameTheory
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”