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 - email@example.com
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
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.
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
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!
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.
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.
Contextures Inc., Copyright ©2017
All rights reserved.