Excel Tips

User Defined Cell Names Spreadsheets cells can be assigned more meaningful names than e.g. A1. Use Insert > Name > Define dialog or simply type the desired cell name into the cell just left from the input field.
Conditional Formatting Conditional formatting can be very useful to call attention to failed code checks, etc. Use Format > Conditional Formatting.