Easily Create Data Entry forms for your Excel worksheets with 1 click. No VBA or macros required. Differences of a Table and Data Ranges.
View all the data of a record in a form making it easy to Add / Edit records. Find records using logic operators and even wildcards. How Data Validation and Conditional Formatting rules are respected.
0:00 Intro
0:52 Understanding the data i will be working on.
1:55 Adding the FORM Command to the Excel Interface
3:59 How does the Form Command in Excel identify a table
5:58 Using the Form with a Data Range and how Form deals with cells containing Calculations and Functions
7:09 Adding a NEW record
7:57 Things to be careful of when working with a Data Range
9:16 Using FORM with Tables
data validation rules respected
conditional formatting is applied to new records added
Errors which occur with data ranges are avoided when using Tables
Adding and Editing records
14:09 Searching for records that contain text, numbers or formulas, using text, logical operators and wild cards