Excel Weekly News from Contextures Jan 21, 2014
Click Check box to add date+ more Excel tips
In this week's Excel news, you'll see how to run a macro when you click a check box, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Link Check Boxes to Cells With a Macro
Check boxes make it easy to select an option on a worksheet, and each check box can be linked to a cell. If the box is checked, the linked cell shows TRUE. You can manually link each check box to a cell, or use a macro, if there are several to set up.
Click here to see the details: Link Check Boxes to Cells With a Macro
Excel Dashboard Mistakes
A dashboard can be a powerful tool for summarizing data in Excel, and showing a snapshot of key performance indicators. However, I've seen some pretty bad dashboards in Excel, and created a slide show to highlight 5 of the worst mistakes.
If you'd like to improve your dashboard skills, Mynda Treacy from My Online training Hub is opening her Excel Dashboard Course, and if you sign up by January 23rd, you can get the course for 20% off.
I've been through this course, and highly recommend it. 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.
Bonus: If you sign up for Mynda's course through one of my links, I'll send you a copy of my time-saving Contextures Excel Tools add-in. Just enter the Referral Code – DebraD – in the box just below the Buy Now button.
Pivot Table Shows Customers With No Purchases
A pivot table is a great way to see a summary of sales to your customers, and see how much each customer spent on each product.
With a few adjustments, a pivot table can also show you which customers have not purchased a specific product. Create a short list of those customers, to focus your sales efforts.
Click here to see the details, and download the sample file: Pivot Table Shows Customers With No Purchases
Click a Check Box to Run a Macro
When you click a check box, it will automaticlly change the value in its linked cell to TRUE or FALSE. You can also assign a macro to a check box, and that macro will run when you click it. In this example, click the box to mark an item as completed, and the current date is added to the date column
Click here to see the details: Click a Check Box to Run a Macro
More Excel Tips
Here are a few of the Excel articles that I read last week, that you might find useful:
- On the Digital Forensics Stream blog, Jason Hale shows how to find the last saved location of an Excel 2013 file.
- At the Daily Dose of Excel blog, Jeff Weir makes a case for investing in corporate Excel training, and you can add your opinion in the comments.
- Alex Roe, in the Italy Chronicles blog, wonders if Excel can save Italy, as one of their political leaders suggested.
- Instead of creating a long concatenation formula, Chandoo shares a quick trick for combining the values in multiple cells.
- And finally, for a humorous peek at what other people are saying about Excel, read the weekly collection of Excel tweets, on my Excel Theatre blog.
Video: Use a Macro to Show a Warning Message
Show a warning message in your Excel workbook by using a macro. Add a red warning icon to add visual impact to the warning message.
Seagull and Sunshine
There have been some rather cold days this winter, but it's good to get outside for a little while every day. On a recent chilly morning, the sun was out, doing its best to warm things up. It wasn't too successful, but I did get a nice shot of this seagull, out enjoying the cool air.
Recommended Excel Tools
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.
- Contextures Excel Tools Add-in
- 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 some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.