Search Contextures Sites
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 firstname.lastname@example.org
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
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.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
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.
Contextures Inc., Copyright ©2014
All rights reserved.