Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

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.

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.

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2014
All rights reserved.