Excel 2007 - Working with Cells, Search Tools and Sorting Data
      The "Excel 2007 - Working with Cells, Search Tools and Sorting Data" lesson covers the following topics:
  • Selection Techniques
  • Moving and Copying Data
  • Adding and Removing Cells
  • Searching and Sorting
      
      Selection Techniques      
      Upon successful completion you will be able to:

1. Select a Single Cell;
2. Select a Range of Cells;
3. Select Columns;
4. Select Rows;
5. De-select Cells;
6. Select Data Ranges;
7. Select the Entire Worksheet.
      
      Moving and Copying Data      
      Upon successful completion you will be able to:

1. Differentiate Cut and Copy;
2. Move Data in Worksheets;
3. Move Data Between Worksheets;
4. Move Data Between Workbooks;
5. Use the Paste Options Smart Tag;
6. Copy Data in Worksheets;
7. Copy Data Between Worksheets;
8. Copy Data Between Workbooks;
9. Use the Office Clipboard.
      
      Adding and Removing Cells      
      Upon successful completion you will be able to:

1. Insert Columns and Rows;
2. Delete Columns and Rows;
3. Insert Cells;
4. Delete Cells;
5. Adjust Column Widths;
6. Change Row Heights;
7. Use Undo;
8. Use Redo;
9. Delete Cell Contents.		      
      Searching and Sorting      
      Upon successful completion you will be able to;

1. Use Find and Replace;
2. Search for Words;
3. Identify Search Options;
4. Use Find Next;
5. Replace Single Occurrences of Text;
6. Use Replace All;
7. Sort Data in Single Columns;
8. Sort Multiple Columns of Data.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2007 - Working with Cells, Search Tools and Sorting Data :
Program Training Courses - Microsoft Excel 2007 :
Office Suite Training Courses - Microsoft Office 2007 :
© 2017 Online Training Masters