April 12, 2016
Hi fellow Excel Addict,
Two weeks ago we had 15 cm (6 in) of snow. This past Saturday it was 17°C (68°F). This morning I woke up to -10°C (14°F). From what I see on TV, many other regions are also experiencing these crazy extremes in their weather. Thankfully, we rarely ever have any disastrous weather events here.
However, on the bright side, the weather for the past few weeks has been mostly sunny and great for running. I have been easing back into a running routine (currently at 3:2 intervals) after more than a year and a half off with an injured knee. I watched the Barkley Marathons on Netflix the other night. I wouldn't attempt that in my wildest, craziest dreams.
In last Thursday's 'Excel in Minutes' newsletter, I showed you how to 'Highlight Upcoming Dates in Real Time'. If you missed it you can read it here. Note that I made a correction to that newsletter shortly after I sent it out. The online version has been updated with the corrections.
Hoping you're enjoying your week and I'll be back again on Thursday with my Excel in Minutes tip.
If you have a favourite tip that you'd like to share, or a problem that you've been trying to solve, that I could possibly include in my newsletter, please send it along to me.
Wishing you an AWESOME week,
Francis Hayes (The Excel Addict)
LAST MINUTE NOTICE:
I just learned that PivotTable expert, John Michaloudis, is running a FREE webinar this week that will teach you how to create PivotTables.
If you’ve always wanted to learn PivotTables but found them overwhelming or even if you already know the basics of Pivot Tables, this 1-hour webinar is going to change all that for you. By the end you’ll be slicing and dicing your data in just seconds using the Pivot Table 'magic tricks' that John is going to teach to you.
Here are just a few of the comments that John has received about his previous webinar...
"Simply awesome, with in an hour I found myself a Pivot expert"
"I would like to say I have been wary and 'scared' of Pivot Tables for years. No longer!"
"Thank you so much for this session. I am new to creating pivot tables but you made it easy to understand."
Find out more about this webinar and choose a date and time to tune in. Please click here.
If you missed my last newsletter, you can click here to view it online.
Avoid Moving to the Next Cell
Most times, when you enter data or a formula into a cell you do want to move to the next cell. However, sometimes you may need to immediately perform another task (i.e. formatting, copying, etc...) with that same cell.
To stay in the same cell rather than having to move back to it, a simple trick is to hold down the CTRL key as you press Enter. If you haven't used this tip before, you may find it hard to break that old habit. But when you do remember to use it, you'll realize how much more convenient it is.
| '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