Moving Data and Modifying Worksheets in Excel 2010

Course details

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.

• 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