WSP Excel Course and Financial Model on Resume (Back Office)

Hey everybody,

Long time lurker, first time poster here. Thanks for all the help everyone has given me over the years. 


I am currently working a back office job for a bank and while applying for new jobs I am consistently asked about my excel knowledge. The excel I use on a daily basis is a lot of v lookups, filtering, etc. (no financial modeling or anything). 

I recently completed the WSP Excel Crash Course so I could get a refresher. I wanted to list it on my resume so that hiring managers can see that I know a good amount of functions and more importantly, that I can learn new functions if I have not used them before. 


Is this considered a good idea if I am going for another back office, non-glamorous finance job? 

If it is a good idea, what would be the best way to list what I learned in the class without listing every single function that I learned? 


Currently, I have it listed as such; 

Online Classes

WallStreetPrep(dot)com Excel Crash Course

  • Learned Nested IF Statements, Index Match Match, & Count If.
  • Learned Conditional Formatting, Paste Special, & Dynamic Headers
  • Learned V-Lookup, Pivot Tables & Text to Columns


Also, I am also thinking about building a 3 statement model (learning from the WSP course) and posting that model online so I can reference it on my resume. Not really to show off my basic financial modeling skills, but to have something that shows that I can use excel at a proficient level. 


I guess the draw backs to these ideas would be that;

A) It looks stupid.

B) I could get grilled on technical questions about excel or financial modeling.


My argument against B would be, none of the jobs I am applying to require financial modeling experience or don't do any financial modeling at all and therefor they may not hold too much weight on a bad/ basic model since I am self taught and showing initiative.

If I got grilled on excel functions that I don't know, I think that I could argue that since I learned the functions listed above, I can learn other equally complex functions. 


What do you all think?


Thanks for all the help. Sorry if this was too long or was asked before. 




 

Et eum et pariatur officiis necessitatibus ad reiciendis. Eaque magni quis excepturi nulla. Rerum commodi consequatur neque sed. Eum aliquid nam alias necessitatibus quae corrupti et consequatur.

Accusantium maxime minus iure eos. Porro repellendus voluptatum blanditiis est quod. Quos esse qui iure incidunt dolor. Sequi rerum at consequatur impedit praesentium ut culpa eum. Quidem natus vero minima est culpa hic ipsam.

I'm an AI bot trained on the most helpful WSO content across 17+ years.

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
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
98.8
10
numi's picture
numi
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...”