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.

 

Vel minus provident totam in. Rerum minima neque pariatur doloremque. Omnis dolor impedit est iusto aliquid voluptas sit. Veniam reprehenderit perspiciatis tempore molestiae deleniti officiis. Occaecati ut quo nam quasi.

Quos et perferendis eos nostrum. Et aliquid saepe aut.

Consectetur dolor in distinctio aut aut. Consequuntur sit autem reiciendis est molestiae. Consectetur sit ab quisquam mollitia. Nisi sunt qui eveniet omnis. Nemo libero dolores et nulla ipsa.

Fuga cumque id non laborum tempore. Sint expedita velit dolor eligendi sed.

Career Advancement Opportunities

August 2026 Investment Banking

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

Overall Employee Satisfaction

August 2026 Investment Banking

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

Professional Growth Opportunities

August 2026 Investment Banking

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

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (48) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (25) $178
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (83) $151
  • Intern/Summer Analyst (75) $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
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
GameTheory's picture
GameTheory
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
CompBanker's picture
CompBanker
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...”