Excel 2007 - Importing, Exporting Data and Working with Pivot Tables

      The "Excel 2007 - Importing, Exporting Data and Working with Pivot Tables" lesson covers the following topics:
  • Importing, Exporting and Queries
  • Working with PivotTables
     
      Importing, Exporting and Queries      
      Upon successful completion you will be able to:

1. Import Files into Excel;
2. Use the Text Import Wizard;
3. Save Imported Files in Excel Format;
4. Import Files Using Drag and Drop;
5. Use and Navigate Forms;
6. Delete Form Records;
7. Add New Records;
8. Search Form Records;
9. Export Files in Other Formats.
     
      Working with PivotTables      
      Upon successful completion you will be able to:

1. Create a PivotTable Report;
2. Lay Out a PivotTable Report;
3. Rearrange a PivotTable;
4. Update PivotTable Data;
5. Show Report Filter Pages;
6. Tailor Fields in a Report;
7. Format a PivotTable.
     
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2007 - Importing, Exporting Data and Working with Pivot Tables :
Program Training Courses - Microsoft Excel 2007 :
Office Suite Training Courses - Microsoft Office 2007 :
© 2017 Online Training Masters