Use Excel's built-in data entry form to add, delete, search and edit records.Keyboard shortcut to open Excel data form. Data form tips and quirks. Video, sample file

How to count unique items (count distinct) in Excel pivot table. For Excel 2010 or earlier versions, without Excel data model

Insert multiple rows or cells quickly, using Excel shortcuts or commands. Insert one or more rows, delete rows, insert or delete cells Sheet cells or named table.