Excel Weekly News from Contextures July 23, 2013
Running total over years + more Excel tips
In this week's Excel news, you'll see how to remove picture backgrounds, show a running total over years, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
You probably don't add too many pictures in Excel, but sometimes a company logo, or other type of graphic is required on a worksheet. There are some powerful graphic tools in Excel -- much more than you would expect in a spreadsheet program!
If you have Excel 2010 or later, you can remove the background in a picture, which might make it easier to position, so it doesn't overlap the numbers and text.
And, there is a book giveaway too, for John Walkenbach's 101 Excel 2013 Tips, Tricks & Timesavers. Go to my blog, and add your favourite Excel tip in the comments, to enter the draw for this book. The deadline is tomorrow, Wednesday, July 24th, at 12 noon, Eastern time.
Click here to see the details, and to enter the giveaway: Remove Picture Background and Excel Book Giveaway
Instead of using formulas, you can quickly create a running total in a pivot table, to show how amount accumulate over time. However, if you group the dates in the pivot table, by years and months, the running total will stop at the end of each year, and start over in the next year.
To avoid this, you can use a new field in your source data, which combines the year and month, and use that field in the pivot table.
Click here to see the details, and to watch the video: Running Total Stops at Year End
Drop down lists, created with data validation, make data entry easier on a worksheet. However, data validation does have some quirks, and I found another one recently -- missing arrows in Excel 2013.
Click here to see the details on the missing arrows in Excel 2013: Missing Drop Down Arrows in Excel 2013
Here are a few more Excel articles that I read this week, that you might find useful:
Instead of showing a worksheet comment in a plain yellow rectangle, did you know that you can change a comment's shape and colour? Watch this short video to see the steps.
For more information on comments, please visit my Contextures website: Excel Comment Tips
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 July 31st, you can get the course for 20% off.
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 July 31st, you can get the dashboard course for 20% off.
It was so hot and humid last week, that I tried to avoid spending time outside. Thank goodness for air conditioning! At least this daisy was looking fresh and cool, because the rest of us weren't.
Save time with our "Done For You" Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.