Excel 2007 - Consolidating Workbooks, Validating Data and Inserting Hyperlinks
      The "Excel 2007 - Consolidating Workbooks, Validating Data and Inserting Hyperlinks" lesson covers the following topics:
  • Consolidating Workbooks
  • Validating Data
  • Working with Hyperlinks
      
      Consolidating Workbooks      
      Upon successful completion you will be able to:

1. Consolidate Workbooks;
2. Select Destination Cells;
3. Add Source Data References;
4. Create Source Data Links;
5. Work with Consolidated File Outlines.
      
      Validating Data      
      Upon successful completion you will be able to:

1. Use the Data Validation feature;
2. Set Validation Criteria;
3. Create Input Messages;
4. Create Error Alert Messages;
5. Create Named Ranges;
6. Create Data Entry Lists;
7. Enter Data Using Lists.
      
      Working with Hyperlinks      
      Upon successful completion you will be able to:

1. Identify the Function of Hyperlinks;
2. Create a Hyperlink;
3. Activate a Hyperlink;
4. Edit Hyperlinks;
7. Create Web Hyperlinks.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2007 - Consolidating Workbooks, Validating Data and Inserting Hyperlinks :
Program Training Courses - Microsoft Excel 2007 :
Office Suite Training Courses - Microsoft Office 2007 :
© 2017 Online Training Masters