C
cdharrison1
I need instructions on how to create a 5 year forecast. Thanks
F
Frank Kabel
Hi
this depends on your desired algorithmn and your data. You need to
provide more details
this depends on your desired algorithmn and your data. You need to
provide more details
N
njoynthevu
Hi Frank,
First I think I need to let you know my skill level. I am able to do all of
the basic and intetmediate functions. I also ko how to collect data for pivot
tables and create them. I have never created a forecast although I have used
them to create other reports.
I am currently unemployed and I have a possible interview that includes
creating a five year forecast.
I am a "saver" and keep a lot of reports that may be useful to me, Thus I
have at my disposal a workbook with extensive sales data that I can use to
practice. I could really use your help in starting from scratch. I have
Execl 2000 on my personal computer, however I do not know the version I will
use during my interview.
Thank you for responding to my question. By the way, what time is it in
Franfurt? It's about 2 PM for me. I live in the U S, in Michigan--the state
that's shaped like a mitten.
Cheryl
First I think I need to let you know my skill level. I am able to do all of
the basic and intetmediate functions. I also ko how to collect data for pivot
tables and create them. I have never created a forecast although I have used
them to create other reports.
I am currently unemployed and I have a possible interview that includes
creating a five year forecast.
I am a "saver" and keep a lot of reports that may be useful to me, Thus I
have at my disposal a workbook with extensive sales data that I can use to
practice. I could really use your help in starting from scratch. I have
Execl 2000 on my personal computer, however I do not know the version I will
use during my interview.
Thank you for responding to my question. By the way, what time is it in
Franfurt? It's about 2 PM for me. I live in the U S, in Michigan--the state
that's shaped like a mitten.
Cheryl
F
Frank Kabel
Hi
the problem is you first have to decide what kind of tren you have in
your data. But maybe starting with a linear interpolation you may have
a look at Excel's FORECAST function in Excel's help for creating based
on your existing data the following data
the problem is you first have to decide what kind of tren you have in
your data. But maybe starting with a linear interpolation you may have
a look at Excel's FORECAST function in Excel's help for creating based
on your existing data the following data