Contextures

Contextures News

Get Started With Excel Macros

October 18, 2016

Get started with Excel macros, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos -- let me know if you're looking for something and can't find it there.

Data Validation Error Warning

If you add a drop down list on a worksheet, or any other type of data validation, you can choose which type of Error Alert messages should be shown - Stop, Warning or Information. Or, turn off the alerts completely, like I do when allowing multiple selections from a drop down list.

However, in a named Excel table, invalid data might be flagged by Excel's Error Checking Rules, even if error alerts are turned off. If you want to hide those warnings, go into the Error Checking Options, and remove the check mark for “Data entered in a table is invalid”. You can read the details on my website.

ribbon shortcuts

Get Started With Excel Macros

Could you save time on your Excel projects if you knew a bit about macros? Jon Acampora, from Excel Campus, is hosting a free live webinar -- The 7 Steps to Getting Started with Macros & VBA.

The webinar is this Thursday, Oct. 20th, starting at 3 PM Eastern time. The training will last about an hour, and then you'll have a chance to ask questions.

To see the details, and to register for the webinar, go to the webinar signup page.

macro webinar

Excel Articles

Here are a couple of Excel articles I read recently, that you might find useful.

Power BI - If you aren't using any of the "Power" tools yet, Matt Allington takes a look a who needs Power Pivot/Query/BI. He gives a very brief description of each tool, and examples of how to use it. (Level - Intermediate)

Interactive Chart - Chandoo shows how to create an interactive decision tree in Excel. He uses the US election as an example, but you could adapt it for your own data. (Level - Intermediate)

Also, see all my Excel products on my Contextures website.

Fairy Houses

Last week, we took a short vacation, and went to Rochester, NY, to do some shopping and sightseeing. To get some fresh air, we walked the nature trails at Tinker Park, where there is a small collection of fairy houses. We found 24 of them, including this one, with the beautiful purple door, but I'm sure that we missed a few too.

weekly photo

That's it for this week! If there are topics that you'd like to see covered in future emails, please let me know.

Debra
ddalgleish @ contextures.com

P.S. You can choose to get the full Contextures news package (news and occasional special announcements), or the basic news package (news only). Click either link to change your news option.

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

 

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

Last updated: March 15, 2017 11:53 AM