Excel 2003 - Working with Database and Analysis Tools
      The "Excel 2003 - Working with Database and Analysis Tools" lesson covers the following topics:
  • Working with Databases
  • Filtering Data
  • Sorting and Subtotalling
  • Goal Seeker and Solver
      
      Working with Databases      
      Upon successful completion you will be able to:

1. Activate a Form;
2. Navigate Form Records;
3. Delete a Record;
4. Add a Record;
5. Search Form Records;
6. Close a Form.
      
      Filtering Data      
      Upon successful completion you will be able to:

1. Filter Data;
2. Apply Multiple Search Criteria;
3. Customise Filters;
4. Sorting with AutoFilter;
5. Remove Filters.
      
      Sorting and Subtotalling      
      Upon successful completion you will be able to:

1. Sort Data;
2. Use Multiple Columns to Sort Data;
3. Apply the SubTotals Feature;
4. Work with Subtotal Outlines;
5. Remove the Subtotals Feature.
      
      Goal Seeker and Solver      
      Upon successful completion you will be able to:

1. Use the Goal Seek Feature;
2. Work with Goal Solver;
3. Select Adjustable Cells;
4. Apply Solver Constraints;
5. Interpret Solver Results.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2003 - Working with Database and Analysis Tools :
Program Training Courses - Microsoft Excel 2003 :
Office Suite Training Courses - Microsoft Office 2003 :
© 2017 Online Training Masters