Daily Tips

21 December 2012 = If your spreadsheet does not want to calculate, press the F9 key

22 December 2012 = By combining the countif and if formulas, you can automatically count your data in a numerical manner.

28 December 2012 = You can add as many spreadsheets as you like with customized names in one click by using macros

3 January 2012 = You can use the RAND formula to automatically select a number between different numbers. Works well with multiple choice