It is better to say, “This one thing I do” than to say, “These forty things I dabble in.”

Washington Gladden

David vs Goliath

Audio book review – this book goes into detail about some small vs large encounters and discusses what they have in common.

Some very interesting and amazing stories.

On Writing

A great book if you’re thinking of becoming a writer.

It starts with the autobiographical back story to help you understand how he became the writer he is and then goes into some good tips for all writers.

Finishes with his horrific accident that nearly killed him and how writing helped him recover.

I’m not a fan of his fiction books, but I am a fan of this book.

The real voyage of discovery consists not in seeking new landscapes but in having new eyes.

Marcel Proust (1871-1922)

Special Rounding

When you need to round to a certain number, e.g. 5 cents, you can use the MROUND function.

If cell A1 contains a number then the following formula will round the value to the closest 5 cent value.


The MROUND function does have some issues – see this blog post.

Fear less, hope more; whine less, breathe more; talk less, say more; love more, and all good things will be yours.

Swedish proverb


Audio book review – A great listen.

It takes you on a journey of understanding into the stories behind how many well known people succeeded.

Very interesting and sure to provide some enlightening conversations about the stories.

Covers things from air crashes to ice hockey and maths in between.

Highly recommend.

Formatted table shortcuts

Two of Excel keyboard shortcuts work differently in Formatted Tables (tables that are created using Format As Table icon on the Home ribbon)

Ctrl + Space normally selects the entire column(s). In a formatted table it selects the data in the column. Pressed again it selects the heading and the data pressed once more it selected the whole column.

Shift + Space normally selects the whole row(s), in a formatted table it will select the row within the table.