- Underline the name column
- Monetary Values needed to be monetary values
- Dates needed to be MM/DD/YYYY - which not everybody does.
- Some columns were date ranges (combine start and end date).
- Aug 2 = 08/02/2016
- 8/2 = 08/02/2016
- August 2 = 08/02/2016
Making Date Ranges
Dates are amazing, but you cannot concatenate (combine them as text with other dates to have pretty date ranges. Maybe not the biggest deal to some, but I am slightly AR when it comes to that stuff.
First - changing a date to text. You can do this with the text formula (yeah, I know, go figure). If the date is in A1, then the formula would look like this =text(A1, "MM/DD/YYYY") or whatever format you would like the date to be. Just make sure it is in the quotes.
Second - to concatenate (combine things in different cells) you use the "&" sign.
Putting it together - you can see in the picture above that I have the text formula 2 times. After the first one you see & which means I am joining that with something else. The quotes and dash ("-") is there because I want a dash between the 2 dates. The second & is because I then would like to add the second date to the cell. Here is the final product.
If I change the dates in cell A2 or B2, then the date range will change as well.
One other suggestion I have for you is to protect sheets or ranges. If there is a range that you would like to protect, highlight the cells and find Protected sheets and ranges in the Data menu. Protecting a range or a sheet means that it is uneditable.
Not everybody understands spreadsheets. Usually because there is so much that you can do with them and people are afraid of them. Save yourself the frustration and lock the cells that you would like others to leave alone.
I know there are so many things that you can do and I am just scratching the surface. The conditional formatting was not the first thing that I tried to format text in the template, so I figured I would share that.
For more comprehensive educational uses of Spreadsheets in education, I would consult Alice Keeler's Blog. For more information on Spreadsheets in general, try GCFLearnfree or Mr. Excel.