Forum Discussion
Trying to do a weekly tracker for excel
In that context, I would suggest to just gather the data in one transaction table, and use the pivot table to track the numbers in that manner as you go along, then you will start to see a trend and develop an analysis strategy which will dictate which excel functions you're going to be using to formulate equations for a specific analysis of the data set you have gathered.
watch this video to get an idea of what I'm talking about:
https://www.youtube.com/watch?v=e-CFYi52gpc
Week 1=100 meals, week 2=100 meals Week 3=100 meals, week 4=100 meals. I tring to find out if there is a better way of doing this then entering
='date' !cell number+'date' !cell number
Then repeating this formula for 7 days.
In that context, I would suggest to just gather the data in one transaction table, and use the pivot table to track the numbers in that manner as you go along, then you will start to see a trend and develop an analysis strategy which will dictate which excel functions you're going to be using to formulate equations for a specific analysis of the data set you have gathered.
watch this video to get an idea of what I'm talking about:
https://www.youtube.com/watch?v=e-CFYi52gpc