Search Contextures Sites
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 - firstname.lastname@example.org
- Chart Compares High and Low Scores
- Show Running Total in Pivot Table
- More Excel Tips
- Excel Announcements
- Video: Slice Through Halloween Horror Film
- Weekly Photo: Painted Pumpkin
- Featured Excel Product
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:
- Sumit Bansal shows 2 ways to extract usernames from a list of email addresses. And if you have Excel 2013, you can use the new Flash Fill feature.
- If you have the Power BI tools, Kasper de Jonge outlines how to get started with Power Pivot (Part 1). Watch the short video, to see the steps.
- When he belatedly heard about Spreadsheet Day, Steven Levy republished his 30-year-old article on the significance and dangers of spreadsheets.
- Paolo Lenotti shares 5 Excel power hacks, and Susan Harkin offers 6 tips for working more efficiently in Excel. Unfortunately, her tip #5 doesn't work in Excel 2013 – that feature was moved to the Ribbon.
- If the built-in table row formatting doesn't meet your needs, Andrew Engwirda shows how to do alternate, alternate row banding, with conditional formatting
- Finally, for a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
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
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 ©2014
All rights reserved.