Excel Power Tips: 10 Ways to make Data Entry Faster and More Accurate

Excel Power Tips: 10 Ways to make Data Entry Faster and More Accurate

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)

Leave a Reply

Close Menu