Annual growth rate

[angelam01]

Helloo!
I need to, calculate on an annual basis the share of employees in the home country of a given table in Excel and then
calculate the annual growth of employees abroad. Are these two different tasks or the same?
I have two different columns for the employees in the home country and abroad. What formulas should I use?
Thank you so much If anyone can help me!

• 

 

[sprigelz]

I'm curious as to how you got the 8% in 2018.

See below for my representation;
Take the total growth from 2017 to 2018 and divide by 2018 final number.
C4 =

=(C2-B2)/C2

For the Share of employees in Italy, I just divided 2018 numbers Italy and Worldwide and Italy accounts for 67.14% of your employee total.
C5 =

=C2/C3