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