No entertainment is so cheap as reading, nor any pleasure so lasting.
Lady Mary Wortley Montague
Monthly Archives: December 2014
It is better to say, “This one thing I do” than to say, “These forty things I dabble in.”
Washington Gladden
A sense of curiosity is nature’s original School of education
Smiley Blanton (1882-1966)
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.
If at first you don’t succeed you’re running about average.
Margaret H Alderson
Cell Line Breaks Via a Formula
When creating a cell that joins text together you may want to include a line break between parts of the text. A function and a format combined can provide that.
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.
=MROUND(A1,0.05)
The MROUND function does have some issues – see this blog post.
Management is doing things right. Leadership is doing the right things
Peter Drucker (1909 – 2005)
The New Slicer in Excel 2013
Slicers are a graphic filtering tool added in Excel 2010. They allow you to filter Pivot Tables. Excel 2013 added a new slicer that makes filtering by dates a lot easier.
Fear less, hope more; whine less, breathe more; talk less, say more; love more, and all good things will be yours.
Swedish proverb
Outliers
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.
It is not the mountain we conquer, but ourselves.
Sir Edmund Hillary (1919–2008)
Two Excel Functions to Format Numbers as Text
Using numbers in automated text sentences can be frustrating. Typically you don’t want to display decimals, but you do want to use the comma format.
I hear and I forget. I see and I remember. I do and I understand.
Confucius (Chinese Philosopher) 551-479 B.C.