Excel Keyboard Shortcuts: Entering Data in Excel

Learn to Be More Efficient in Microsoft Excel (Part 11 of a 20-Part Excel Course Series)
4.3 (46 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
6,059 students enrolled
Free
Start Learning Now
  • Lectures 19
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

Course Description

Most Recent Course Update:

December 2015

Course Description


Are you a Microsoft Excel user? How well do you know the program? Can you do most actions in Excel without using your mouse?

If not: Stop wasting time.

Learn to save several minutes each day by slightly tweaking your workflow. Discover 14 ways to work more efficiently when Entering Data in Microsoft Excel.

So…

  • Become the go-to keyboard savant in your office.
  • Impress your boss.
  • Get more done each day.
  • Use the hours you save to make more money or just have some fun!

The choice is yours.

Click “Take This Course" now, and become MORE PRODUCTIVE today!

See you in on the other side.

Cheers,

Tolan
Co-Founder of ProductivityMe

What are the requirements?

  • Windows PC or laptop

What am I going to get from this course?

  • Become MORE PRODUCTIVE in Microsoft Excel
  • Save minutes each day
  • Show off your cool new skills: impress others with 14 awesome tips, tricks, and keyboard shortcuts

What is the target audience?

  • Course is for PC-users of Microsoft Excel 2007, 2010, 2013, and 2016
  • Excel for Mac uses a different set of keyboard shortcuts; this course is not recommended for Excel 2011 Mac or Excel 2016 for Mac (unless user is running Windows on Boot Camp or Parallels)

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started in the Course
Introduction to the Course
01:06
DOWNLOADS: Guide to Other Mini-Courses in Series & Guide to Keyboard Shortcuts
Article
Overview of Specific Keyboard Shortcuts Covered in Course
05:09
Section 2: Keyboard Shortcuts
11.01 - (Enter) - Entering Data and Moving Down
03:30
11.02 - (Shift + Enter) - Entering Data and Moving Up
02:45
11.03 - (Tab) - Entering Data and Moving Right
05:00
11.04 - (Shift + Tab) - Entering Data and Moving Left
05:45
11.05 - (Ctrl + Enter) - Completing an Entry and Staying in Current Cell
03:45
11.06 - (Ctrl + Enter) - Entering the Same Data in Multiple Cells
03:00
11.07 - (Ctrl + ;) - Inserting Current Date
04:15
11.08 - (Ctrl + Shift + :) - Inserting Current Time
03:45
11.09 - (Ctrl + D) - Filling Down from Cell Above
02:30
11.10 - (Ctrl + R) - Filling Right from Cell Left
03:00
11.11 - (Ctrl + ' ) - Copying a Formula from Cell Above
04:00
11.12 - (Ctrl + Shift + ") - Copying a Value from Cell Above
02:45
11.13 - (Ctrl + K) - Adding a Hyperlink
06:00
11.14 - (Alt + ↓) - Displaying the Autocomplete List
03:40
Section 3: Course Wrap-Up
Final Thoughts & Next Steps
01:07
DOWNLOAD: Guide to Other Mini-Courses in Series (As Shown Above)
2 pages

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

The ProductivityMe Company, Excel Tips, Tricks, & Tutorials, One Lesson at a Time.

ProductivityMe

Try. Learn. Conquer. Excel.

We create short, engaging videos that help people Master Excel.

We offer simple and easy-to-follow courses, and like our thousands of students, we’re always excited to learn cool new things.

This is ProductivityMe.

Udemy Course Instructors

Tolan Thornton
ProductivityMe Co-founder & Lead Udemy Instructor

Tolan went to the University of Arizona. He graduated summa cuma laude in the top 1% of his class with a Bachelor’s of Science Administration in Finance & Entrepreneurship and a Bachelor’s of Arts in French & East Asian Studies.

Tolan has worked at a top-tier economic consulting firm, specializing in Energy Deals and Financial Litigation.

Fun Facts about Tolan:

Tolan is the oldest of 3 children. He loves to travel.

Tolan has lived in Paris, New York, London, Beijing, Hangzhou, and Casablanca.

Odd fact? Tolan’s left leg is 5mm shorter than his right.

If Tolan had a year off, he’d learn a fourth language- maybe Portuguese, Spanish, or Hindi.

Ryan FitzPatrick
ProductivityMe Co-founder & Udemy Instructor

Ryan graduated summa cuma laude in the top 3% of his class with a Bachelor’s of Science Administration in Management Information Systems & Entrepreneurship.

Ryan has worked in non-profits as well as in Enterprise Management Software. He has worked as a consultant, as a tutor, even a bit in retail!

Fun Facts about Ryan:

Ryan is the younger of 2 children. Though he travels a lot for work, Ryan thinks of Tucson as home.

Ryan loves to write. Short-stories and essays are mostly his passion, but Ryan has even started screenplays, just for kicks!

If Ryan had a year off, he’d probably learn to code. That or start (another) company. Who knows, maybe he’d even do both!

Ready to start learning?
Start Learning Now