October 11, 2016
Hi fellow Excel Addict,
Maybe you have been wondering why you haven't hear from me in the past
two weeks. Tina and I were were in Montreal last week for a vacation and this past
(Canadian) Thanksgiving weekend we went to Halifax to visit our daughter Stephanie who moved there a few
months ago to start a new job.
|Travels of An Excel Addict|
(Click links below for images from our trip.)
had a great time in Montreal. When we arrived on Wednesday, we did some sightseeing including a trip to the Place Ville Marie Observatory on the 46th floor which gave us an amazing 360° view of the city.
I got up early Thursday morning and ran
13 km (training for my upcoming Cape to Cabot Race on October 16th), including a run to
the top of Mount
Royal. What an amazing view of the city. That afternoon we visited the Jean Talon Market and at night we went to a Montreal Canadiens ice hockey game. Friday afternoon we visited the Biosphère Environment Museum, the former USA pavilion for the 1967 World Fair, located at Parc
Jean-Drapeau on Île Sainte-Hélène. While there, we impulsively
registered for a 5K night run on Saturday. Friday night we went
to the Adele
concert at the Bell Centre. What a concert!
On Saturday we did a little shopping and visited Place des Arts on Rue Sainte-Catherine. When the sun went down we ran 5K around the Formula 1 Circuit Gilles Villeneuve on Île Notre-Dame in the dark with 6000 other runners. Lighting was provided by 6000 blacklight headlamps and the glow-in-the-dark powder we got doused with at several stations along the route. What a unique and fun experience that was!
On Sunday morning we went to St. Joseph's Oratory and from there we walked through a graveyard on our way to the Mount Royal Chalet.
Getting back to our hotel was quite an adventure though. Construction detours
on Mount Royal sent us searching for an alternate route back down the
hill. What normally is a 15 minute walk down the steps and straight to our hotel, turned out to
be an almost two-hour trek through a maze of footpaths in the woods on Mount Royal.
Yes, I know. We made a few wrong turns. The battery in my cell phone had gone dead so I couldn't use my map
and GPS and, being surrounded by trees, it was difficult to know
exactly where we were going. We eventually came out of the woods
on a street about an hour's walk from our hotel.
That day we got
to see way more of Mount Royal than most tourists do. Walking
along some of the same paths as the first explorers of North America did 500 years ago was amazing. It was a long and very tiring day but it was an adventure we were happy to have experienced.
you ever been to Montreal? It's such an amazing city with so much to
see and do. I'll definitely be going back again some time.
Then last weekend we flew to Halifax, Nova Scotia to visit Stephanie. I've been to Halifax several times
before, mostly for running, but this time we drove out to see the picturesque villages of Peggy's Cove,
Mahone Bay and Lunenburg on Saturday.
Sunday morning I was up bright and early for a 15K run
to Point Pleasant Point Park and back. That was my last long run before
the 20K Cape to Cabot race on Sunday. We had Thanksgiving dinner a day
early with Stephanie since we were flying back to Newfoundland on
When we got home on Monday, we had another
Thanksgiving dinner with our other daughter Kristen and her family. Not a good weekend for the turkeys.
It was a busy, fun and adventure-filled two weeks.
Now it's time for me to get back to Excel.
In today's 'Excel in Seconds' tip, I show you how to 'Adjust A Range Of Numbers By A Specific Amount Or Percentage'.
If you were wondering if you missed any of my tips, my last newsletter was on September 27. The tip was 'Summing The Same Cell Across Multiple Sheets'. You
can read it here.
feel free to
share my newsletter with your friends — they will thank you
Hope you have a great week and keep
Hayes (The Excel
TheExcelAddict.com Quote of the Day
"I like things to happen.
And if they don’t happen,
I like to make them happen."
-- Winston Churchill --
(Quote suggested by Paul Dick)
If you missed my last
newsletter, you can click here to view it online.
Adjust A Range Of Numbers By A Specific Amount Or Percentage
you want to adjust a large range of numbers by a the same amount, such
as increasing them by 5%, dividing them by 100 or converting them from
positive to negative. There are several ways to do this in Excel. Many
people create calculation formulas in a separate column, then paste the
results back over the original range.
However, there is a much easier and quicker way to do this.
In an empty cell somewhere in your sheet, enter the value you want to
adjust your numbers by (e.g. increase by 5% = 1.05, convert positive to
negative = -1, etc...).
2) Right click and Copy that cell;
3) Next, select the range of numbers that you want to adjust;
4) Right-click the selected range and choose Paste Special... from the menu;
5) In the Paste Special dialog, select Values, then choose the operation you want to apply (e.g. Add, Subtract, Multiply, Divide) and click OK.
There you have it. So fast and easy, isn't it?
Adjusting Fixed Values
important to note that, when you Paste Special using an operation (i.e.
Add, Subtract, Multiply, or Divide) to cells containing fixed values,
the values in the original cells are adjusted to the new results. For
example, when you multiply a cell containing a fixed value of 200 by
1.05, the result will be a fixed value of 210.
However, when you
Paste Special using an operation (i.e. Add, Subtract, Multiply, or
Divide) to cells containing formulas, the formulas will be adjusted to
include the new calculation. For example, when you use the above method to
multiply a cell containing a formula such as =SUM(A1:A10) by 1.05, the result will be a modified formula, =SUM(A1:A10)*1.05, not a fixed value.
So be very careful when using this tip with formula cells. In fact, I recommend that you not do this with formula cells.
Some of the resources I recommend on my website and in my newsletter
pay me a small referral commission if you purchase from them through
links on my website or using my referral code. This helps offset the
costs of my website. I've worked long and hard to build up my
reputation online over the past 10 years as someone who provides
exceptional value to my readers. So I'm not willing to risk that for a
few dollars. As you know, I don’t just recommend anything. It has to be
of outstanding quality and value. If you are ever not completely
satisfied with anything I recommend, please let me know and I will get
your money back for you...GUARANTEED. You can't lose.