Learning Numeric Data Entry

Learn how to quickly and effectively enter numeric data and formulas into a spreadsheet application like Excel using the 10-key numeric keypad.

Learn how to quickly and effectively enter numeric data and formulas using the 10-key numeric keypad. This course explores ergonomics, proper finger positions, and formula-entry shortcuts so you can quickly do things like enter large amounts of data into spreadsheet applications like Excel. Author Anson Alexander introduces the lessons using lynda.com's innovative and interactive typing tool, which you can use to practice on your own.

Introduction

• Welcome
• What you should know before watching this course
• Typing ergonomics
• Using the exercise files

1. Exploring Which Fingers are Used for Different Keys

• The numeric-keypad home row (the 4, 5, 6, and the plus keys)
• The 1, 2, 3, and Enter keys
• The 0 and period keys
• The 7, 8, and 9 keys
• The equals, forward slash, asterisk, and minus keys

2. Working in Spreadsheet Applications

• Navigating within spreadsheets
• Entering formulas and performing calculations

Conclusion

• Next steps