Microsoft Excel: 10 Tips to make Data Entry faster

10 top tips to make Data Entry faster and more accurate in Excel.

Video Highlights:

--- Simple Data Entry ---
0:25 - Data Entry using Tab and Enter

1:00 - Fill down from above using CTRL + D
1:30 - Autocomplete using Tab key
2:10 - Show drop down list using ALT + Down arrow
4:15 - Enter values into multiiple cells using CTRL + Enter

--- Excel Can Speak ---
5:19 - Get Excel to speak to you when you enter data!

--- Data Entry Form ---
7:02 - Show the data entry form

--- Keep Headers Visible ---
9:20 - Freeze Panes (ALT ➜ W ➜ F ➜ F)
10:20 - Split Window (ALT ➜ W ➜ S)
11:14 - Use Excel Table (CTRL + T to add table)