Search Contextures Sites


Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days



Contextures News

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

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:

  • Alex Roe, in the Italy Chronicles blog, wonders if Excel can save Italy, as one of their political leaders suggested.
  • 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.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.


Learn how to create Excel dashboards.


Privacy Policy


Contextures Inc., Copyright ©2014
All rights reserved.