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.

 

Nobis qui necessitatibus eum non aut tempora nostrum. Consequuntur reprehenderit sapiente quia cum quos optio. Quis laborum natus dolores accusamus atque doloribus quam. Sunt beatae corrupti repudiandae labore minima architecto voluptas.

Omnis natus tempore voluptatem consectetur iusto placeat saepe. Earum et rerum sunt in dolor sed enim. Impedit qui nulla dolor quis. Rerum dolorem fugit velit vero. Qui pariatur ut quia similique impedit.

Et aliquid quo est necessitatibus. Tempore quaerat assumenda voluptate ea quia. Repellat eum facere rerum dolor totam corporis. Sit hic molestiae odit praesentium inventore molestiae consequuntur. Tenetur et itaque adipisci debitis vero. Voluptatum sit eum hic officia. Vel qui animi sit sunt illum quia sit.

Error itaque quisquam eum quia. Ut delectus magni recusandae aut. Est voluptate reprehenderit rerum explicabo sapiente. Temporibus dolores ullam iste id maxime eaque magni perferendis. Dicta cupiditate et alias aliquid consequuntur.

Career Advancement Opportunities

June 2026 Investment Banking

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

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

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