Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Then you should take a look at the Excel Expert course by Mynda Treach:
Go to this link – http://www.launchexcel.com/moth-excel-expert
Here are 10 top tips to make Data Entry faster and more accurate in Excel. Read the accompanying article on www.launchexcel.com:
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)