Excel Weekly News from Contextures September 16, 2014
Clear cells + more Excel tips
In this week's Excel news, you'll see how to automatically clear a cell, 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 - email@example.com
To help people enter data in a worksheet, you can set up drop down lists, where they can select items, instead of typing. It's also possible to make one drop down list dependent on what was selected in another drop down.
To prevent mismatched selections, you can use a macro to clear the dependent cell, when a new selection is made in the first cell.
Click here to see the details: Macro Clears Dependent Cell
I'd never thought about using Slicers to control conditional formatting, until I watched a short video by John Michaloudis, from My Excel Online. Instead of fussing with the settings, just click a Slicer button, to change the values.
John uses the technique with a pivot table, but you could also do this with regular cells on a dashboard. You could even use a Slicer to change values for a formula, for something like a budget or forecast.
Click here to watch the video, and download the sample file (scroll down to find the videos): 10.13 Control Conditional Formatting with Slicers
The video is from John's Xtreme Pivot Table course, which has more than 200 videos, along with practice workbooks, finance business cases, and 12 months of personal support. You can use the coupon code CONTEXTURES for a 10% discount.
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:
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 use Excel count functions to count cells with numbers only, count cells with any type of data or count blank cells. The video shows the COUNT function, COUNTA function, COUNTBLANK function
Even if you don't drink wine, you might like the label, "The Formula", on this bottle -- it seems perfect for Excel fans.
I tested it last week, just for scientific purposes, and would definitely have it again.
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.