Sheet Protection – No password

When you protect a sheet with a password, you must make a note of the password, otherwise you create problems for yourself.

Did you know you don’t have to supply a password?

To apply sheet protection, right click the sheet tab and choose Protect Sheet.

When the Protect Sheet dialog displays just press Enter or click OK.

This protects the sheet with no password.

This stops accidental changes and you can easily unprotect the sheet to make changes.

You can right click the sheet tab to unprotect as well.

Tools of Titans (2016)

I am over half way through the book and it has lots of great ideas, concepts, tricks and tips. Highly recommend.

Tim is famous for the 4 hour work week book, but more recently his podcasts have become legendary.

The book is based on the people Tim has interviewed and had on the Podcast (not all the podcasts are interviews). I am a big fan of the podcast and the book delivers.

Great to have so much information in one book.

In the introduction Tim says to skip stuff that doesn’t interest you. I have skipped over a lot of the “supplement” chapters as it isn’t my thing.

But there are still lot of gems in this book no matter what your stage in life.

The kindle version has lots of internal links within the book.

Definitely worth your money, time and effort.

Tim Ferriss Podcast

I have been listening to Tim Ferriss’s podcasts for a few years now.

Its brilliant!

As well as having many famous people on, he also has people who aren’t so famous but are amazing nonetheless.

Many episodes go over 2 hours.

Highly recommend – great for car travel.

There is occasional swearing, not much, but if you don’t like that, you have been warned.

The content is well worth ignoring the occasional swear word.

 

FREE Excel Webinar – Excel Yourself 2016

My next free webinar will be held this month – Excel Yourself 2016. I will cover 5 of my magazine articles from the year and include some extra content.

There are two dates to choose from 15 & 19 Dec. Content is the same on both days.

The sessions start at 1pm AEDST (10am AWST) and run for an hour.

Click here to see more details and register.

Relationships Shortcut

Excel 2013 added the Data Model to Excel.

The Relationships option (Data ribbon) is part of that model. It allows you to create relationships between tables so that you can use a PivotTable to report on multiple tables.

See my December 2016 INTHEBLACK article for an example.

The keyboard shortcut to create or edit, a Relationship is easy to remember – it is

Alt a a

Pressed in sequence, not held down.

Rework

A short book with short chapters meant to get you thinking differently about work.

Much of what the book covers goes against the “common” advice out there.

It gets you thinking (sometimes differently) and that’s one thing a good book is all about.

David Heinemeir Hansson has recently been featured on two Tim Ferris podcasts – two excellent episodes.