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 email@example.com
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
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.
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
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
Here are a few of the Excel articles that I read last week, that you might find useful:
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.
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.
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.