Moving Data and Modifying Worksheets in Excel 2010

Overview/Description
The ability to easily manipulate data is probably the biggest benefit of using productivity applications, such as Excel 2010. For instance, if you have to copy the same data multiple times or move large amounts of data from one place to another within a worksheet or between workbooks, you can see this is much more easily accomplished through software than through the use of pen and paper. For example, Excel 2010 features such as Live Preview let you see how copied data will look before you copy it, even if it's copied between Office applications, and the Paste Special option allows you to further define how your data is copied or moved. This course is designed to show you many of the ways that Excel 2010 allows you to manipulate data and the worksheets that contain them and describes features that let you do this quickly and efficiently.

Target Audience
Individuals and business users with basic computer literacy

Expected Duration (hours)
1.0

Lesson Objectives

Moving Data and Modifying Worksheets in Excel 2010

copy and move data

use paste options to preview and control how data displays

insert and delete rows and columns

format rows and columns

insert and delete worksheets

copy or move worksheets

copy and paste data

modify rows and columns

copy and modify worksheets