-
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.
Overview
Syllabus
-
Introduction
- Welcome
- What you should know before watching this course
- Typing ergonomics
- Using the exercise files
- 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
- Navigating within spreadsheets
- Entering formulas and performing calculations
- Next steps