Enter Data Using Autofill And Other Techniques In Excel For Mac


show more Entering data using AutoFill and other techniques provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Entering data using AutoFill and other techniques

Excel 2011 makes it easy for you to enter your data. In most cases, you can click a cell, type the value you want, and press Return. There will be times, however, when you need to enter a lot of data by hand. For example, if you track sales by month, you might need to enter a long string of month names by hand. In Excel you can streamline that process by using Auto Fill. In this movie I'll show you how to enter data quickly and efficiently using several methods. The most basic way to enter data into a worksheet is to click the cell and start typing. So let's say in cell A1 I want to type the value Monthly Sales.

Type in Monthly space Sales, press Return, and there is the value. But let's suppose that I am entering a value or editing a cell and I decide that I don't want to keep my edits. For example, if I click cell A6 and I want to type in February, but instead I start typing January and I see that it's there, I can press the Escape key, and that removes my edits from ...

Entering data using AutoFill and other techniques
Video duration: 4m 32s 6h 32m Beginner

Viewers:

Entering data using AutoFill and other techniques provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...