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.

This online course forms part of the SkillsNet short course suite.

Learning objectives

  • Copy and move data
  • Use paste options to preview and control how data displays
  • Insert and delete rows and columns
  • Insert and delete worksheets

Audience

Individuals and business users with basic computer literacy

60 Minutes

365 Days

loading...