Search Contextures Sites


Newsletter Index


Excel news
by email




30 Excel Functions in 30 Days




Contextures News

Excel Weekly News from Contextures Apr 23, 2013

Will spring ever arrive? I'd like to get my garden started, and set up a spreadsheet to keep track of what has been planted. The birds look a bit chilly too, like the little yellow finch that you can see in my photo at the end of the newsletter.

In this week's Excel news, you'll see how to show running totals in a worksheet, fix conditional formatting in a pivot table, and other tips. Thank you for reading the Excel news!

 -  Debra

Pivot Table Conditional Formatting

If you use conditional formatting in a pivot table, it might not update correctly, if you add new data or change the layout.

There is a setting that you can change, to ensure that the formatting automatically adjusts.

To see the details, and a short video, click here: Pivot Table Conditional Formatting

Create a Running Total in an Excel Column

Instead of showing an overall total, you can create a running total on a worksheet, by using the SUM function in each row.

To see the details, and a short video, click here: Create a Running Total in an Excel Column

Click to Move Excel List Items Up or Down

In this Excel file from Jim Cone, you can click the up/down arrows to rotate a list of items on an Excel sheet. For example, if January is at the top of the list, one click moves February up, and January rotates to the bottom of the list.

Click here, to read the details, and to download the sample file: Click to Move Excel List Items Up or Down

Video: Create Named Ranges from Worksheet Labels

It's a good idea to use named cells in your worksheets. You can use names in formulas, and quickly select a named range.

This video shows you a quick way to create several names with a single click, by using the labels that you typed in worksheet cells. For more on naming ranges, please visit the Excel Names page on my Contextures website.

Excel Dashboard Course Recommendation

For a limited time, Mynda Treacy from My Online training Hub is opening her Excel Dashboard course, and if you sign up by 8 pm Pacific time on May 1st, you can get the course for 20% off. Use the Discount code: DASH

The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there’s even an option to download the videos.

The previous classes were very successful, and you can read the glowing reviews from the students, who loved all the techniques that they learned in the course, and are using them to impress their colleagues.

Click here to find out find out details of the course, read the student comments, and watch the 'behind the scenes' video that shows you what you'll receive as a member.

Remember, if you sign up by May 1st, you can get the dashboard course for 20% off. Use the Discount code: DASH

Are your skills up to date

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.

Yellow Finch Photo

It's still a bit cold, but a few more birds are starting to appear, like this little yellow finch. He was sitting in a tree in front of our house last Friday, and it was easy to spot his bright feathers.

Learn how to create Excel dashboards.


Privacy Policy


Contextures Inc., Copyright ©2014
All rights reserved.