Contextures Excel Newsletter 20130402

Search Contextures Sites

Contextures
Newsletter Index

Contextures
Excel news
by email

Email:

Name (optional):

We respect your email privacy

Contextures News

Excel Weekly News from Contextures Apr 04, 2013

Did you enjoy the long weekend, and get away from the computer for a little while? The weather wasn't great on Sunday, here in the Toronto area, but there was a beautiful sunset at the end of the day. You can see my photo at the end of the newsletter.

Now that we're back to work, in this week's Excel news, you'll see how to go back to previous cells, sort a pivot table with a custom list, and other tips. Thank you for reading the Excel news!

- Debra ddalgleish@contextures.com

Go Back to Previous Location

In Excel, you can store up to 4 temporary locations, and go back to those locations quickly. This is handy if you’re making updates to a big workbook, and want to switch between a couple of sheets without lots of scrolling.

To see the details, click here: Go Back to Previous Locations

Show RSS Feeds on Excel Worksheet

Do you use Google Reader to keep up with your favourite blogs and websites? I use Google Reader a few times every day, and was disappointed to learn that it will be shut down on July 1st.

I'm looking for a replacement reader, and it looks like Feedly will be pretty good, as long as they find a way to transfer our feeds from Google in July. And it's free, so the price is right!

In the meantime, you can also import RSS feeds into Excel. It certainly isn't a replacement for Google Reader, but it's quick and easy to set up, so try it out!

To see the details, and to download the sample file, click here: Show RSS Feeds on Excel Worksheet

Sort Pivot Table With a Custom List

By default, a pivot table's items are sorted alphabetically. You can change the settings, so items are sorted based on their values.

And, you can even create a custom list of items, such as cities or regions, then sort your pivot table in that order.

Click here, to read the details: Sort Pivot Table With a Custom List

Video: Divide Numbers Without Formulas

In Excel, you can quickly add, subtract, multiply or divide, without using formulas. Just type a number on the worksheet, copy the cell, and use the Paste Special options.

Watch this short video to see the steps for using Paste Special to divide a group of cells.

For written instructions, and other data entry tips, please go to this page on my Contextures website: Change Values With Paste Special

Recommended Excel Tools

They aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.

Contextures PivotPower Premium Add-in

Contextures 30 Excel Functions in 30 Days

Excel Online Course

Excel Charting Tools

Excel Dashboard Kits

Excel Project Management Templates

Excel VBA School

Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.

Sunset Photo

Here's the beautiful sunset we enjoyed on Sunday night -- a wonderful way to end a long weekend.

Home

Excel Tips

Excel Files

Products

Videos

Blog

Contact

Privacy Policy

Contextures Inc., Copyright ©2014
All rights reserved.

Debra Dalgleish

Contextures Newsletter Index Contextures Excel news by email Email: Name (optional): We respect your email privacy	Contextures News Excel Weekly News from Contextures Apr 04, 2013 Did you enjoy the long weekend, and get away from the computer for a little while? The weather wasn't great on Sunday, here in the Toronto area, but there was a beautiful sunset at the end of the day. You can see my photo at the end of the newsletter. Now that we're back to work, in this week's Excel news, you'll see how to go back to previous cells, sort a pivot table with a custom list, and other tips. Thank you for reading the Excel news! - Debra ddalgleish@contextures.com Go Back to Previous Location In Excel, you can store up to 4 temporary locations, and go back to those locations quickly. This is handy if you’re making updates to a big workbook, and want to switch between a couple of sheets without lots of scrolling. To see the details, click here: Go Back to Previous Locations Show RSS Feeds on Excel Worksheet Do you use Google Reader to keep up with your favourite blogs and websites? I use Google Reader a few times every day, and was disappointed to learn that it will be shut down on July 1st. I'm looking for a replacement reader, and it looks like Feedly will be pretty good, as long as they find a way to transfer our feeds from Google in July. And it's free, so the price is right! In the meantime, you can also import RSS feeds into Excel. It certainly isn't a replacement for Google Reader, but it's quick and easy to set up, so try it out! To see the details, and to download the sample file, click here: Show RSS Feeds on Excel Worksheet Sort Pivot Table With a Custom List By default, a pivot table's items are sorted alphabetically. You can change the settings, so items are sorted based on their values. And, you can even create a custom list of items, such as cities or regions, then sort your pivot table in that order. Click here, to read the details: Sort Pivot Table With a Custom List Video: Divide Numbers Without Formulas In Excel, you can quickly add, subtract, multiply or divide, without using formulas. Just type a number on the worksheet, copy the cell, and use the Paste Special options. Watch this short video to see the steps for using Paste Special to divide a group of cells. For written instructions, and other data entry tips, please go to this page on my Contextures website: Change Values With Paste Special Recommended Excel Tools They aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you. Contextures PivotPower Premium Add-in Contextures 30 Excel Functions in 30 Days Excel Online Course Excel Charting Tools Excel Dashboard Kits Excel Project Management Templates Excel VBA School Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales. Sunset Photo Here's the beautiful sunset we enjoyed on Sunday night -- a wonderful way to end a long weekend.