Auto color cells + more Excel tips
Excel Weekly News from Contextures September 30, 2014
In this week's Excel news, you'll see how to automatically color data entry cells, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the Excel articles. If you have suggestions for future topics, please let me know.
- Debra - firstname.lastname@example.org
On a data entry sheet, select a number of options from a drop down list. That number of options show up in the data entry area. Then, select a color for each item, from another drop down list. In the cell to the right, the selected color is shown..
Click here to see the details, and watch the video: Show Color With Conditional Formatting
If you have multiple copies of a pivot table in a workbook, on different sheets, you can use the GETPIVOTDATA function to pull the total amount from a specific pivot table.
Click here to see the details, and watch the video: Get Total from Specific Pivot Table
I've known Doug Hong online for a few years, and enjoy his Excel videos on YouTube (the DougH channel). Doug has just created a new online course -- Excel 2010 for the New Project Manager. The course is on the Udemy website, and the regular registration fee is $99.
Doug is giving my newsletter subscribers an exclusive coupon for free registration, if you sign up by October 7, 2014. If you take the course and find it helpful, please leave a review -- there is a review/feedback tool on the course's web page.
For details on the content, you can watch the course introduction video, before you register. The course covers the basics of Excel 2010, and some of the features that you'll need for project management.
Excel 2010 for the New Project Manager Course -- free registration link -- expires Oct 7, 2014
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:
2-Day Course (Dutch): Excel VBA for Financials, 2-day course
(in Dutch), led by Excel experts, Jan Karel Pieterse and Tony
de Jonker. This course is specifically aimed at the Finance professional.
It has no frills, and no technical mumbo-jumbo – just the VBA
you need to achieve more success in your daily job.
Date: November 19 and December 3, 2014. Location: Utrecht (Netherlands)
You can run into problems if you copy multiple ranges, and try to paste them to a new location. You might see an error, "That command cannot be used on multiple selections", or values might be pasted, instead of formulas.
See the steps for copying and pasting multiple selections in this short video tutorial.
We went for a walk in a nearby conservation area on Friday, and the leaves are starting to change colours. The water in the small lake was very still, and made a perfect reflection of the trees. Soon, I'll have to bundle up to stand outside, so I'll enjoy this beautiful weather while it lasts.
In addition to all the free
Excel tips and tutorials, there are other Excel tools that you can
invest in. To learn more about the products listed below, click
on the links to take a look at their features, and decide if they're
right for you.
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.