Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Learning Numeric Data Entry

via LinkedIn Learning

Overview

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.

Syllabus

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

Taught by

Anson Alexander

Reviews

Start your review of Learning Numeric Data Entry

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.