I'm Giving Away My Bitcoin. You Should Too. | LinkedIn

Interesting article about Bitcoin.  A completely different conclusion to the writer of that article might have come to would be: increasing supply with slower increasing demand may lead Bitcoin value to fall which could lead to Bitcoin panic and a crash.

I'm Giving Away My Bitcoin. You Should Too. | LinkedIn:

How to Sync Google and Outlook Calendars: alternatives to the defunct Google sync utility - PC Advisor

How to Sync Google and Outlook Calendars: alternatives to the defunct Google sync utility - PC Advisor:

This is a really useful article if you or your family have some users using Outlook and others using Google calendar. The top part of the article covers how to avoid the problem (mainly by sticking to one or the other). At the bottom of the article is a suggestion of some free software that sorts the problem out.

Do note though the limitation: this works well for synchronising one Google calendar with Outlook. It does not seem to work so well where you may have a situation with multiple Google calendars that you may wish to synchronise into Outlook.

'via Blog this'

Excel name box tips

Handy tips from the LinkedIn group 'Excel Gurus'.  Ever been at the bottom of a long spreadsheet, scrolled up to read the title but lost the column before you got to the top?  Typing c in the name box will select the whole column containing the active cell.

Caffeine: The Silent Killer of Success

Caffeine: The Silent Killer of Success:

Especially interesting is that caffeine has a half life of 6 hours - so your lunch time coffee is 25% still active after 12 hours.

Further facts from Wikipedia: 
1 Decaffeinated drinks contain typically 1–2% of the original caffeine content, and sometimes as much as 20%.
2 A generally accepted statistic is that a cup of normal black (often called red in China; as distinct from green) tea contains 40–50 mg of caffeine, roughly half the content of a cup of coffee.

'via Blog this'

Business case for having dual screens

I have been a great believer in using multiple screens for many years.  If you need to be able to justify this for your team, this business case may help.

Excel subtotals and summaries

Some really useful ideas for Excel especially how to create manual subtotals which can be set up to exclude (or include) hidden numbers.

This could be especially useful where a single layout is used for presenting accounts each month and empty rows are hidden.  If the row is not empty the following month but is still hidden, a SUM formula would still add the number which could allow a balance sheet to balance at the bottom but the total to not equal the sum of the (shown) figures above it.  SUBTOTAL(109,range) gets round this problem or would allow a logical check to test this issue.

Speed reading book review

A short book so a quick read (even for a slow reader).  Key points are:

• Consciously use different speeds of reading for different tasks: proof reading is slow, reading for understanding is medium, skimming to find the important bits, for an overview or to remind can be fast.
• Do not 'verbalise' each word, even in your head.  Read chunks not words so that your eyes bounce say twice on each row.
• Decide why you are reading the piece first so that your objectives are clear.  Bearing in mind your objectives, read the intro, chapter heads and conclusion first to check the rest warrants reading and if appropriate, just read the parts that achieve your aims.

How to Speed Read: Faster Reading, Improved Comprehension and Becoming a Better Reader: A Very Easy Guide (30 Minute Read)