PLEASE HELP ME WITH EXCEL urgent

hi everyone,

I am interning at a start up. My boss gave me a project and I am stuck. I have to compile a list of biotech companies, find out which countries they operate in and where their headquarters are. Then, I have to put this on a map in excel (for eg. xyz company operates in the US, India and Canada, so there'll be three red dots on those countries on the map, one color for each company). Thing is I have NO idea how to do this. I tried asking my boss and he was like "I haven't done that shit in ages. Figure it out."

I will really appreciate some help with this. Thank you!

 

I get that. I am just not sure how to plot locations on a map in excel

 

Excel sounds like the wrong tool for this assignment. Find some photo editing software. Paste it in Excel if really needed.

"If you always put limits on everything you do, physical or anything else, it will spread into your work and into your life. There are no limits. There are only plateaus, and you must not stay there, you must go beyond them." - Bruce Lee
 

I think I've heard people do stuff with "Power View", which I believe is an Excel add-in. No idea if you have to buy it. I'd try searching Power View to see if that's the tool you're thinking of. Wish I could be of more help - best of luck.

Monkey see. Monkey Doo [Doo].
 
[Comment removed by mod team]
 

Ut sed saepe rerum doloribus. Qui sequi sunt explicabo cumque. Nihil quis velit aliquid deserunt.

Eligendi non quas voluptatem dignissimos. Quam architecto facilis recusandae quasi recusandae qui ex.

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...”