Search Contextures Sites


Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days



Contextures News

Running Totals + more Excel tips

Excel Weekly News from Contextures October 28, 2014

In this week's Excel news, you'll see how to troubleshoot with a report diagnostic display, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the articles. If you have suggestions for future topics, please let me know.

 -  Debra -

Chart Compares High and Low Scores

Last weekend, I helped someone who needed a chart for a fantasy football league, to show the highest and lowest win/loss scores for each week. To do this, I made a clustered stacked chart, by carefully arranging the data

Click here to see the details, and download the sample file: Chart Compares High and Low Scores

Show Running Total in Pivot Table

With a running total in a pivot table, you can see how amounts accumulate over a period of time, or through another field, such as products, or customers.

Click here to see the details, and watch the video: Show Running Total in Pivot Table

And check my Pivot Table blog tomorrow, Wednesday, Oct. 29th, for an exciting pivot table course giveaway.

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

  • New Book: Advanced Excel Essentials, by Jordan Goldmeier Pre-order today, for the Wednesday, Oct. 29th release.
  • Abbot Katz is presenting a series of Excel courses in London on consecutive Monday evenings, November 3-24, at the offices of the Guardian newspaper near the Kings Cross station

Video: Slice Through Halloween Horror Films

Slasher movies are a scary Halloween tradition, and you if you have a list of movies, you can quickly find all the horror films, by using Excel Slicers. Don't watch all of them, or you'll never get your Excel work done!

The Painted Pumpkin

Happy Halloween! When I was a kid, we had to carve the faces into our pumpkins, risking life and limb! Apparently painted pumpkins are popular now, and that will be safer for those little fingers. My granddaughter made this one, with a bit of help.

Mystery Object: Last week's mystery object was a Braille slate, and its stylus, used to punch messages into thick paper. You had to write things backwards, so they could be read from left to right. I met a blind girl at camp one summer, and she gave them to me, so we could be pen pals.


Featured Excel Product

To celebrate the first anniversary of his VLOOKUP book, Chandoo is having a sale this Thursday and Friday (Oct. 30-31)

During this 2 day sale,

The sale starts on 30th October morning (Japan time) and ends on 31st October midnight (Pacific time)


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


Learn how to create Excel dashboards.


Privacy Policy


Contextures Inc., Copyright 2014
All rights reserved.