Excel Power Tips: 10 Ways to make Data Entry Faster and More Accurate
// Recommended Excel Courses //
1. Launch Excel Macros & VBA School: https://go.launchexcel.com/macros-vba...
2. Excel Campus Elevate Program: https://go.launchexcel.com/excel-camp...
3. My Online Training Hub Dashboards: https://go.launchexcel.com/moth-dashb...
4. Coursera Excel Specialisation: https://go.launchexcel.com/coursera-e...
5. Coursera Everyday Excel: https://go.launchexcel.com/coursera-e...
6. Coursera Excel Data Visualisation: https://go.launchexcel.com/coursera-d...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
https://go.launchexcel.com/simple-she...
They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!
// Show Notes //
Here are 10 top tips to make Data Entry faster and more accurate in Excel. Read the accompanying article on www.launchexcel.com:
http://www.launchexcel.com/excel-data...
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)