From the course: Excel 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Exploring data entry, editing, and AutoFill
From the course: Excel 2019 Essential Training
Exploring data entry, editing, and AutoFill
- [Instructor] Data entry is one of the most basic things we do in Excel and yet there are some concepts and some techniques, like AutoFill, that are gonna make this process a lot simpler and faster. We're using the worksheet DataEntry in our workbook 02 - Entering Data. I'm going to zoom in on this worksheet because I'm gonna putting in some data set for a six-month period. We'll need six or seven columns. In the lower right-hand corner is what we call the zoom slider bar. You'll see a black rectangle. I'm gonna drag this to the right and you should watch the columns there. There we go, that's good enough. All right, I'm gonna put the word Sales here in cell A2. Before putting data into a cell, of course you have to go there with either the arrow keys on your keyboard or just point with the mouse and click. The word Sales. Notice, as I type it, it's automatically left-aligned. That's what Excel does with text entries. When we complete an entry, you can either press Enter to move…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.