Excel 2007 - Using Auditing Tools, the Scenario Manager and Macros
      The "Excel 2007 - Using Auditing Tools, the Scenario Manager and Macros" lesson covers the following topics:
  • Auditing Tools
  • Scenario Manager
  • Using Macros
      
      Auditing Tools      
      Upon successful completion you will be able to:

1. Trace Precedents;
2. Trace Dependents;
3. Remove Tracer Arrows;
4. Trace Errors in Formulae;
5. Correct Formula Errors.
6. Display Formula Locations;
7. Show Formulas in Worksheets.
      
      Scenario Manager      
      Upon successful completion you will be able to:

1. Name Scenario and Variable Cells;
2. Create Scenarios;
3. Select Scenario Variables;
4. Delete a Scenario;
5. Edit a Scenario;
6. Create Summary Reports.
      
      Using Macros      
      Upon successful completion you will be able to:

1. Identify a Macros Function;
2. Record Macros;
3. Assign Shortcut Keys to a Macro;
4. Run Macros;
5. Assign a Macro to the Quick Access Toolbar.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2007 - Using Auditing Tools, the Scenario Manager and Macros :
Program Training Courses - Microsoft Excel 2007 :
Office Suite Training Courses - Microsoft Office 2007 :
© 2017 Online Training Masters