Dynamic Charts + more Excel tips
February 24, 2015
In this week's Excel news, you'll see how to create dynamic charts, select multiple items from a drop down list, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
You can add a drop down list in a worksheet cell, by using data validation. When you select an item from the list, that value is entered in the cell. If you go back to the list, and select a different item, that value replaces the cell's current value.
With a bit of programming, you can select multiple items from a drop down list, and have new values added to the cell's contents. The code can be copied from my sample file, and added to your workbook.
This is the most popular article that I've ever posted on my blog, with over 300 comments, and you can read the details here: Select Multiple Items from Excel Data Validation List
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:
Instead of manually creating links, you can use Excel HYPERLINK function to create them. For example, if you have a list of company names in column A, and website URLs or email addresses in column B, use a formula to create hyperlinks in column C.
Click here to watch the short video that show how it works: Create Links With Excel HYPERLINK Function
Last week, we had a Family Day holiday here in Ontario, Canada, and enjoyed a long weekend. Our city hasn't had too much snow this year, compared to other regions, but it's been bitterly cold. I guess that's why my granddaughter had the park all to herself, when we went out for a bit of fresh air. It was a fun, but short, outing.
This week, I'm pleased to recommend Excel University -- an online Excel training course designed specifically for accountants. I went through several of the modules, and was very impressed by the content, delivery, and course structure.
The course focuses specifically on the Excel features, functions, and techniques that are most useful to accounting professionals. The training is practical and the concepts are easily applied to your workbooks. You'll learn how to get your Excel tasks done more quickly, how to save time, and how to automate your recurring-use workbooks.
The online course is taught through lecture videos, homework activities, and quizzes. A passing score of 70% unlocks the certificate of completion.
The Excel University format combines the best elements of traditional CPE delivery methods, including live seminars, webinars, and self-study. This is a unique training format for CPE and it is the most effective way to learn Excel.
Instructor Jeff Lenning, CPA and Microsoft Certified Trainer, has taught thousands of CPAs and accounting professionals how to streamline their work by using Excel more effectively. He is a dynamic instructor and many of his Excel articles have been featured in accounting publications such as the Journal of Accountancy.
Click the link to learn more about Excel University.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: January 26, 2020 4:22 PM