Knowing your destination is half the journey.
Anonymous
Monthly Archives: October 2015
28 May 2014
Japanese Yen Format in Excel
Applying it quickly
To apply the Japanese Yen format can take quite a few mouse clicks.
The macro that does it, on the other hand, is quite simple. Select the range, then run the macro.
Sub JapaneseYen() Selection.NumberFormat = "[$¥-411]#,##0.00" End Sub
If you are unsure how to use macros, see the link below.
Be not afraid of growing slowly. Be afraid of standing still.
Chinese proverb
Getting the Week Number From a Date in Excel
New WEEKNUM Function - ISO 8601 standard
Excel has had a week number function for many versions, but Excel 2013 added a new week number function that complies with the ISO 8601 standard week number.
Great video with ideas on learning a skill quickly and effectively.
10% Happier (2014)
Audio Book review.
Narrated by the author – a TV anchor from the US.
Interesting perspectives. Takes a bit to get going as he goes through his back story. Some parts are a bit long winded, but over all, worth a listen.
Meditation is the answer to the question, how can I be 10% happier?
The shortest answer is doing.
English Proverb
Do what you can, where you are, with what you’ve got.
Theodore Roosevelt (1858-1919)
Adding years or months to a date in Excel
Finding the end date can be easy
When working with loans or leases, it is common to have to add a number of years to a start date to determine the end date. An Excel function can automate that process.
Charts – 10 ideas and examples on what to do, and what not to do.