Excel Wiz, Do You Know This?

if I want to refer to a fixed cell location, not value, regardless how i insert rows and cols, what do I do? using $ and names won't do. any idea?

6,248 WSO Academy Investment Banking Session Reviews: 4.82/5

Class of '21 Nov 2026 Cohort

5.00/5

Investment Banking Mock Interview

“Thank you, Ryan - a very helpful session, especially for the PE perspective. We worked through my behavioural stories, and he showed me how to reshape them into one cohesive story of about 5 minutes, with more emphasis on the numbers and on my sell-side and buy-side roles. His tricky question on switching jobs was especially useful - it covers a likely interview question - and so was the buy-side vs sell-side discussion. On the technical side, we covered how project finance debt is sized in practice, with merchant risk, which was a good contrast to the availability-payment structures common in the GCC. Thanks again - looking forward to the next session.”

Class of '29 Nov 2026 Cohort

5.00/5

Investment Banking Career Roadmap (optional)

“Julian was straight to the point and didn't beat around the bush. He answered all of my questions in a clear way while also giving me advice and tips on how to approach my future. Helped me gain a much more clear mindset so I am more confident on what I need to do and how I need to go about it. Additionally, he helped me understand which tasks are the most important to do, gave me a clear split helping me understand what to focus on most/least. He also gave me good ideas for my 7 stories, and how I should be memorable and show my hunger for IB. ”

See All 11,523 WSO Academy Reviews

3 Comments

skiloa

ST

19y

Use =indirect()...review help on this function

Reply

Quote

Report

Other

nadvice

?

19y

You can name the cell and reference to it. Search the help function in excel

Reply

Quote

Report

Other

Equity Kicker Mezzanine Debt

H2O

O

19y

Quia asperiores nulla nihil tempore dolor provident. Laboriosam iure ut odit aperiam vel maxime. Omnis consectetur est neque dicta et non. Minus consequatur perferendis magni culpa. Id sed dolores quo animi eligendi culpa. Sint enim et fugit quo quia fugiat temporibus.

Facere ut laudantium eaque eum voluptatibus. Hic velit totam ea rem ut cumque incidunt. Officia modi perspiciatis amet.

Reply

Quote

Report

Other

+230	Are target prospects getting dumber?	40	6m
+218	MBB Pay Raises	42	19m
+201	UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT	38	1h
+191	How do YOU manage networking requests?	25	35m
+184	Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment	36	45m
+183	Another $115bn Mega deal for these banks. Congrats!	36	42m
+180	US 2027 SA IB worried about background check	28	20s
+178	Leaked Interview Questions to Recruiting Services	67	13m
+177	Career Crossroads	18	4m
+167	Investment Banking is Divine	24	9m

1	redever	99.2
2	kanon	99.0
3	BankonBanking	99.0
4	Secyh62	99.0
5	dosk17	98.9
6	GameTheory	98.9
7	CompBanker	98.9
8	DrApeman	98.9
9	Betsy Massar	98.9
10	Kenny_Powers_CFA	98.8

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Excel Wiz, Do You Know This?

Score Breakdown

Feedback

Score Breakdown

Feedback

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Excel Wiz, Do You Know This?

See All Comments - 100% Free

Trending Content - Investment Banking Forum