Results for:
data validation

• Free training: Take the next steps in growing your Excel skills

  28 Jun 2011

  In early May, we told you about the new video series Excel Skills Builder in our post " Take the first step in growing your Excel skills ." In that post, we announced the launch of lesson 1. Well, we've finally finished the rest of the lessons, and wanted to share this great resource with you! As a reminder...
• Pulling RSS data into Excel (or: Using Excel to Search Craigslist) - Part 1

  12 Oct 2010

  This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. OK, so I'm going to talk a bit about a relatively unknown feature in Excel: XML data import. It was introduced in Excel 2003, but we've done a pretty good job hiding it since Excel 2007 by putting it on the Developer...
• Creating Dynamic Validation Ranges

  5 Mar 2009

  Today’s author, Dany Hoter, a Product Planner for the Excel team, shares a neat trick he learned recently for creating dynamic data validation ranges. The sample file used for this blog post can be found in the attachments at the bottom of this post. The problem: Validating data entry based on hierarchical...
• Video Tip: Conditional Formatting and Data Validation

  5 Sep 2008

  Today's author: Sam Radakovitz, a Program Manager on the Excel team that enjoys creating VBA applications in Excel. A bit ago, Joseph had a blog post about community clips on OfficeLabs.com , so for this post, I wanted to take advantage of the video demonstration and do the post via community clips....
• Example file for PivotTable / Data Validation Trick

  4 Mar 2008

  Recently I posted an article discussing how PivotTables can be used on Excel Services to mimick the Data Validation feature . The author, Dany Hoter, sent me a copy of the file he used in the example screen shots and I never got around to posting it for our readers. Here's a short description of the...
• A PivotTable Trick That Brings Data Validation to Excel Services

  13 Feb 2008

  Today's author: Dany Hoter, a product planner who works on the Excel Services team. Excel has a feature called Data Validation that controls the possible values a user might enter into a cell or a range of cells. As you can see there are many options for validating data entry. The most popular is probably...