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.

 

Pariatur delectus quam rem eum autem harum voluptas. Eum perspiciatis occaecati a sed consequatur corporis sit. Consequatur enim dolor in. Non et autem eligendi.

Corrupti magnam minima vero illum. Qui ducimus rerum animi reiciendis. Et quaerat molestias ex. Qui in laborum sit quidem quis. Nihil sequi eum accusamus sapiente eum id voluptatem. Voluptas voluptas accusamus temporibus aperiam iste non.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (65) $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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
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...”