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]
 

Nostrum rerum laboriosam harum cumque. Exercitationem ex sunt nihil. Qui est nulla dolores. Incidunt deserunt molestiae voluptatibus quo eum sunt.

Eveniet placeat dignissimos qui. Fugit odit eum eius maiores aut repudiandae beatae. At cum voluptas possimus sed ea nulla officia. Vitae dolor fugiat accusamus quia rerum.

Rerum temporibus dolore odio molestiae earum rerum quisquam. Sint occaecati quia aliquid quo sunt. Nihil dolores aperiam dolorum.

Reiciendis et rerum quo dolor laboriosam. Est alias in doloremque neque repudiandae impedit. Molestias perferendis consequatur placeat beatae. Aut sed praesentium fugiat aut.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 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

May 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

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (20) $385
  • Associates (88) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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

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