Hi Mynda,
I am a beginner in Excel and my Boss assigned me to create a Cost Saving Template which pertaining to Transportation Cost and I created on my own and searching google but finally your videos has been popped up and which are very interesting. So I attached my template and would you please able to look into this and advise what do you think about the date column and as well as the Saving accomplishment drop down columns. And also, would you think is this looks alright prior I submit to my MGR since it have to submit this first thing in the Monday morning.
Look forward to hearing from you.
Sincerely,
Chan
Hi Chan,
Thanks for sharing your file. My only concern is that as you have a column with a date header I suspect you will either be creating more worksheets for the future dates, or adding columns. Neither of these follow the recommended tabular layout you should use in Excel.
It would be better to add a column for 'Date' and then have a separate column containing the data validation currently in column B.
Hope that points you in the right direction.
Mynda
