Excel Expert for tuition
Budget: $25 – $50 AUD
I am wishing to learn how to create a database in excel.
Currently I keep dail data on a chicken shed.
the data is kept in A4 printable sheets in one worksheet in excel
Each day i insert another sheet for the days data
I end up with about four hundred sheets on the one worksheet
This makes aggregating the data quite difficult
I would like to have the data I collect in a database using rows for each day
Then I would like a form where I could input the data and it would show me only the data for that day and then calculate various sums from the data
I could also easily calculate aggregated data from many days etc...
Attached is a screen shot of the worksheet I currently use
Currently I keep dail data on a chicken shed.
the data is kept in A4 printable sheets in one worksheet in excel
Each day i insert another sheet for the days data
I end up with about four hundred sheets on the one worksheet
This makes aggregating the data quite difficult
I would like to have the data I collect in a database using rows for each day
Then I would like a form where I could input the data and it would show me only the data for that day and then calculate various sums from the data
I could also easily calculate aggregated data from many days etc...
Attached is a screen shot of the worksheet I currently use