#excel #virtualinternship #finance
This video goes through my suggested solutions for the Goldman Sachs Excel Skills for Business Task 2.
**Key tips**
Grow at 10% first year, then growth rate decreases by 1% the following years:
Assuming we begin in A1...
(A1) * 1.1 = A2
A2/A1 - 1% = A3
We can drag the formula across in A3 to obtain a growth rate that decreases by 1% with each additional cell
Shortcut to fill a row (on Mac)
Highlight the desired row of cells
Press enter to type in a cell
To fill all the cells selected press control and enter simultaneously.
Music Credit: Where It's Always Warm by Vlad Gluschenko is licensed under a Creative Commons License.
[ Ссылка ]...
[ Ссылка ]
Support by RFM - NCM: [ Ссылка ]
Ещё видео!