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 ?

11 Comments
 
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.

 

Commodi inventore eum recusandae dolores numquam. Reprehenderit cupiditate est velit odio non. Molestias ut placeat non culpa porro odio veritatis. Aut dicta natus dolore error quibusdam placeat. Quis debitis necessitatibus omnis numquam. Exercitationem laboriosam quia recusandae. Ut sapiente et eligendi sit quam quia ea.

Voluptatem fugit saepe qui voluptas provident itaque. Iusto et sed quia qui est. Eum eveniet aliquam atque cum. Tenetur qui odio et at dolore exercitationem dolor nostrum. Omnis sint exercitationem non dolores. Rerum pariatur sapiente dolorem eum.

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.8%
  • Morgan Stanley 07 97.3%

Overall Employee Satisfaction

September 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 07 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan No 97.3%

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (51) $260
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (26) $182
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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...”