KhanofTarkir
New Member
- Joined
- Sep 3, 2014
- Messages
- 24
Hi everyone,
Just started work as an analyst and got staffed on a model with inter-workbook linkages, named ranges for formulas, hundreds of rows/columns, etc.
I would rate my excel skills as 3/10 at best - what are your best practices for navigating quickly and efficiently within a sheet and between sheets? Is there a better of way of finding out the location of a referenced 'named range' in a formula within the workbook that is not on the same sheet as the formula?
Thanks!
Just started work as an analyst and got staffed on a model with inter-workbook linkages, named ranges for formulas, hundreds of rows/columns, etc.
I would rate my excel skills as 3/10 at best - what are your best practices for navigating quickly and efficiently within a sheet and between sheets? Is there a better of way of finding out the location of a referenced 'named range' in a formula within the workbook that is not on the same sheet as the formula?
Thanks!
Last edited: