All articles with 'data validation' Tag

31 Excel Tutorials – Learn and Be Awesome in Excel

Published on Mar 11, 2010 { 10 Comments }
31 Excel Tutorials – Learn and Be Awesome in Excel
Continue »

Data Validation using an Unsorted column with Duplicate Entries as a Source List

Published on Feb 2, 2010 { 7 Comments }
Data Validation using an Unsorted column with Duplicate Entries as a Source List
Continue »

Flu Trends Chart in Excel [Yes, we can edition]

Published on Jan 22, 2010 { 11 Comments }
Flu Trends Chart in Excel [Yes, we can edition]
Continue »

10 Tips to Make Better and Boss-proof Excel Spreadsheets

Published on Nov 3, 2009 { 26 Comments }
10 Tips to Make Better and Boss-proof Excel Spreadsheets
Continue »

Copy Data Validations from one cell to another [quick tip]

Published on Oct 28, 2009 { 6 Comments }
Copy Data Validations from one cell to another [quick tip]
Continue »

Prevent Duplicate Data Entry using Cell Validations

Published on Oct 26, 2009 { 13 Comments }
Prevent Duplicate Data Entry using Cell Validations
Continue »

Excel Links of the Week – Free E-Book Edition

Published on Mar 9, 2009 { 5 Comments }
Excel Links of the Week – Free E-Book Edition
Continue »

Weekly Excel Links – After a Long Time Edition

Published on Mar 2, 2009 { 3 Comments }
Weekly Excel Links – After a Long Time Edition
Continue »

Google Spreadsheets Introduces Data Validation, Sweet!

Published on Feb 18, 2009 { 4 Comments }
Google Spreadsheets Introduces Data Validation, Sweet!
Continue »

Advanced Data Validation Techniques in Excel [spreadcheats]

Published on Nov 25, 2008 { 21 Comments }
Advanced Data Validation Techniques in Excel [spreadcheats]
Continue »

Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]

Published on Nov 6, 2008 { 2 Comments }
Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
Continue »

Handling spelling mistakes while searching your data using excel

Published on Sep 25, 2008 { 8 Comments }
Handling spelling mistakes while searching your data using excel
Continue »

Excel Basics: How to add drop down list to validate data

Published on Aug 7, 2008 { 14 Comments }
Excel Basics: How to add drop down list to validate data
Continue »