Excel has had an AutoCalculation feature for many versions. This means you can see the result of common functions without typing a single formula.
Excel Hacksby David and Raina Hawley (O'Reilly)
Great book with solutions to difficult issues in Excel.
A mix of amazing formulas, macros and manual techniques to get around some of Excel’s limitations.
The authors run the OzGrid.com website which is based in WA.
Their website is a great resource for Excel users.
Just don’t give up trying what you really want to do. Where there is love and inspiration, I don’t think you can go wrong.
Ella Fitzgerald (1918-1996)
Made to Stickby Chip and Dan Heath
This is a brilliant book.
It is relevant for many different areas. Public speaking, management, financial reporting – even telling jokes.
It covers the six critical areas that you need to focus on to get your message across so that it sticks.
Its very practical and also humorous.
You’ll never think about kidney transplants the same again (read it and you’ll understand).
Convert date to its Financial Year End Date
To convert a date to its financial year end date you can use the following formula, assuming the date is in cell A1.
The (MONTH(A1)>6),6,30) part returns TRUE when the month number of the date is above 6. In Excel TRUE = 1, hence 1 is added to the year of the date. If the month number is 6 or less it returns FALSE and in Excel FALSE = 0, so the year is left unchanged.