FIRST RF Interview Question: How would you use the offset function in Excel?

Skip to content Skip to footer

Community
Jobs
Companies
Salaries
For employers

Notifications

FIRST RF

FIRST RF Senior Finance Analyst interview

FIRST RF interview question

Senior Finance Analyst Interview

How would you use the offset function in Excel?

Interview Answer

Anonymous

25 Jan 2019

This function is useful for changing the directionality of referenced information in dragging formulas, e.g. from vertical to horizontal, or creating ranges of references in dragging formulas. They wanted me to use it to create more easily refreshed data sets in models using Pivot tables.

FIRST RF interviews

FIRST RF

FIRST RF interview question

Interview Answer

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches