Manual document processing can be a cause of your company losing money and your employees losing interest in their duties. The best way to speed up all organization processes and increase your data is to deal with everything with cutting-edge platform like DocHub. Deal with all of your files and Save 12 Month Sales Forecast in PPR in a matter of seconds and save more time for relevant tasks.
With DocHub, you possess limitless use of your files and Templates available to you at any moment. Discover all functions right now with your free DocHub profile.
in this video were gonna go over how to create a simple monthly sales projection on Excel so in the end this is what were gonna try to build okay so were gonna go ahead and start and open up a new tab and the first thing you want to do is you want to start off by labeling the columns by typing in the month in the second month youre gonna go ahead and type in sales projections or projected cells all right now that we have that the next thing you want to do is you want to type in the months so were gonna go ahead and type in January and were gonna use the abbreviation now at this point we want to make sure that we have Excel do all the work so were gonna go ahead and click this black cross on the bottom right hand side of the cell and if I click and drag down I should be able to have Excel input all the months for the rest of the year okay the next thing I want to do is type in the number amount of cells for the month of January so lets say we sold $50,000 and our project cells