In this video, you'll learn to create an advanced automated data entry form in Excel. The tutorial covers input areas, dependent dropdowns, and automated error messages. When a user submits the form, ...

Use implicit And and Or operators with Excel’s Advanced Filter feature to create complex, but powerful, filtering combos. Editor’s Note: This article was originally published in July 2010 and the ...