Can ChatGPT do analysts grunt work ??

I’m having a thought that GPT 4.0 can be used for building excel models ( by generating VBA scripts ) and generating emails and reports and summaries and analysis in pitch decks. When Microsoft embeds GPT into Excel and PPT, maybe it can change the fonts and colors upon English instructions by generating invisible machine codes. Example: tell GPT to “change all footnote to font 10 from page 15 to page 30”, then GPT does it. 


How legitimate is this idea ?

 
Most Helpful

Yes ChatGPT probably has the potential to help many white collar workers outsource grunt work, back-end work, repeatable work to AI. This will probably lift worker productivity considerably. Now the question is how do companies react to that? Lay workers off? Or rather spread workers across more projects to boost revenues

Who knows what will actually happen. Time will tell. AI is an exciting innovation.

 

Long term probably means less Analyst and Associate seats across the street as the AI makes people more productive. Plus great for seniors so they can keep a higher % of what they bring in, all else equal.

We gotta make it to the mid / senior level before AI takes our job.

 

Some of this will likely be done by ChatGPT and the rest one by office 360. Our firm doesn’t allow office documents or models on the cloud, so unlikely to be impacted soon. 

 

Microsoft owns the Office Suites ( Excel PowerPoint etc ) which are the most trusted softwares in all highly-regulated industries. And the owner of ChatGPT also happens to be Microsoft 🤯 I don’t think this is a coincidence. They’re up to something.

 

Microsoft owns a minority stake of Chat GPT but ok. And yes they are - search up CoPilot

 

Dolorem nihil cumque nesciunt voluptatem saepe velit voluptatem et. Incidunt sint aut corporis amet. Nobis perspiciatis quaerat dignissimos. Voluptate temporibus cumque porro. Incidunt asperiores voluptas nihil dignissimos non.

Career Advancement Opportunities

April 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 03 97.1%

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $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

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
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
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...”