Excel 2003 - Conditional Formatting, Validating Data, XML Queries & Importing and Exporting
      The "Excel 2003 - Conditional Formatting, Validating Data, XML Queries & Importing and Exporting" lesson covers the following topics:
  • Importing and Exporting Files
  • Custom and Conditional Formats
  • Validating Data
  • XML and
      
      Importing and Exporting Files      
      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. Drag and Drop Imported Files;
5. Use the Import External Data feature;
6. Import a Table from a HTML Page;
7. Export an Excel File.
     
      Custom and Conditional Formats      
      Upon successful completion you will be able to:

1. Apply Built-in Numeric Formats;
2. Identify Built-in Numeric Formats;
3. Create a Custom Numeric Format;
4. Use Conditional Formatting.
      
      Validating Data      
      Upon successful completion you will be able to:

1. Use the Data Validation feature;
2. Set Validation Criteria;
3. Display Input Messages;
4. Show an Error Alert Message;
5. Work with Error Messages.
      
      XML and Web Queries      
      Upon successful completion you will be able to:

1. Save files as XML;
2. View XML code;
3. Post XML files;
4. Create Web Queries.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2003 - Conditional Formatting, Validating Data, XML Queries & Importing and Exporting :
Program Training Courses - Microsoft Excel 2003 :
Office Suite Training Courses - Microsoft Office 2003 :
© 2017 Online Training Masters