Microsoft Excel 2010: Modifying a Worksheet

This training course teaches users how to modify Microsoft Excel 2010 worksheets. Viewers learn such things as how to make changes to the data, modify elements, do a search, and change the height and width of rows and columns.

Using video tutorials, this course demonstrates how to find cells quickly, add and delete worksheets, insert or delete columns, rows, and cells and other topics. In the section on finding cells quickly, viewers learn Excel 2010 has over sixteen thousand columns and more than one million rows. This means users can create massive worksheets with a lot of cells. The trainer explains ways for finding cells faster than by tabbing through the cells or scrolling down the worksheet. One way is by typing the cell coordinates into the name box. Another way to get to a cell quickly is to name the cell, then type the cell name into the name box. Excel has a name manager that allows users to edit and delete cell names. This naming technique can also be applied to rows.

Improve your Excel expertise and make more professional spreadsheets with this course on modifying Excel 2010 worksheets.

   This course is in the Video On Demand format, to read about Video On Demand features click here.

Microsoft Excel 2010 users

• Modifying a Worksheet
• The Undo and Redo Commands
• Quick Access to Cells
• Find and Replace
• Adding and Deleting Worksheets
• Column Width and Row Height Alte
• Inserting/Deleting Columns, Rows, and Cells
• The Hide and Unhide Options

• Windows 8.1: Customizing the Windows 8.1 Environment
• Windows 8.1: Working with Desktop Applications
• Windows 8.1: Getting to Know PCs and the Windows 8.1 User Interface