To view this newsletter in your browser click here.
August 16, 2016
In Newfoundland, our summers are pretty short. July is usually pretty dependable for nice weather but August can be a hit or miss. This year however, we have had really nice weather in July and so far in August, except for a couple of wicked days of wind, rain and cold in the first week of August.
So it's with a little hesitance that I am sitting back in front of my computer today while the sun is shining warmly and brightly outside. Yes, I am an Excel addict but in this part of the world we really do appreciate every warm day we get.
Over the past three weeks I have been so busy doing 'vacation stuff' that I've barely had time to sit down at my computer. I have read all of my emails and responded to a few (with easy answers) but not much Excelling.
My Tely 10 story
Since my last newsletter on July 21, I ran the Tely 10 Road Race and was really pleased that I beat my previous best time. There is an interesting story behind that result. Since I had started running only 6 months previous, after being out with a knee injury for 18 months, I was hoping I could at least tie my previous best Tely 10 time of 88 minutes. Everyone kept telling me to 'take it easy and don't injure yourself again'. But secretly my goal was to beat my previous best time by 2 minutes (i.e. 86 minutes) because that's what I had done in my previous two Tely 10s. On race day, my wife and I arrived at the start of the race and that's when I discovered that...
...I had forgotten my watch.
Now I had to run the 16 km. (10 mi.) race that I had been training for for months without a clue as to my time. If you are a runner you probably have had runs where you've given everything and the end of the race is a blur. That was me. I didn't even notice the time as I crossed the finish line. I had no idea what my finish time was until an hour later when the results were posted. I believe that if I didn't forget my watch that morning, my time may have been 5 minutes slower.
Cape to Cabot
I was so stoked after my Tely 10 experience that I registered for the Cape to Cabot 20km race in October. This is a race that I've always said that "you'd have to be crazy to run".
Well, you can call me crazy.
The C2C has been called "The Toughest Race in Eastern North America". The race starts just below the lighthouse at Cape Spear National Historic Site, the most easterly point in North America, and climbs and descends three major hills (100m/328ft, 127m/417ft, 206m/675ft) before reaching the waterfront of historic old St. John's. Then it's just one more mile to go, all uphill (151m/495ft)!
Traveling Excel Addicts
Also, last week I was also very honoured to meet a couple of my Excel Addict subscribers, Dwayne and Patti Cartwright from Texas, who were touring Newfoundland in their 'home on wheels'. I stopped by to visit them at a local campground and we chatted for about an hour. I always love receiving emails from fellow Excel Addicts but meeting them in person was awesome. Patti and Dwayne told me they are thoroughly enjoying their visit to Newfoundland and I wished them safe traveling.
So, that's what I've been doing for the past few weeks.
I hope you don't mind my long email today. Thought you may be wondering where I had been for the past 3 weeks.
Tell others about my newsletter
If you find my Excel tips helpful, please feel free to share my newsletter with your friends—chances are they will too.
If you missed last 'Excel in Minutes' tip (from 3 weeks ago), 'How to Copy Formulas And Keep Cell References From Changing', you can read it here now.
Wishing you a great week end keep on Excelling,
Francis Hayes (The Excel Addict)
P.S. This is your Last chance to register for MYNDA'S EXCEL DASHBOARD COURSE. Learn how to make interactive Excel Dashboards like the one below which is based on Olympics data spanning 1896 to 2012. Actually it's 3 dashboards in one file with tabs (like a browser) to allow you to navigate between them! REGISTRATION CLOSES THURSDAY AUG 18 AT 8 PM (PST)
WATCH the DASHBOARD WEBINAR REPLAY: In just 1 hour Mynda will teach you how to build an interactive dashboard. There are still a couple of days left to catch a replay of the webinars before Mynda's Dashboard course registration closes, so if you aren't sure what a dashboard is or how these skills might be relevant to you then click here to watch the replay. In just 1 hour Mynda will teach you how to build an interactive dashboard.
To view this newsletter online click here.
If you missed my last newsletter, you can click here to view it online.
You can access even more tips on my website by going to my members' page.
To update your contact info, click the 'Change Subscriber Options' at the bottom of this email.
Get Back to Your Selection
If you have a cell or range of cells selected and scroll to another part of the worksheet, then you want to get back to the selected cells, a shortcut to quickly jump back and still retain your selection is CTRL + Backspace.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630