194,142 views 137 on YTPak
494 20

Published on 30 Mar 2012 | over 4 years ago

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 - 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 :
www.launchexcel.com/excel-data-entry-power-tips

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)

Loading related videos...