Excel 2007 - Logical Functions, Text Functions and Database Functions
      The "Excel 2007 - Logical Functions, Text Functions and Database Functions" lesson covers the following topics:
  • Logical and Informational Functions
  • Text Functions
  • Database Functions
      
      Logical and Informational Functions      
      Upon successful completion you will be able to:

1. Use the IF Function;
2. Use the OR Function;
3. Use the AND Function;
4. Use Help for Error Messages;
5. Use Nested IF Functions;
6. Understand IS Functions;
7. Use the ISERROR Function.		      
      Text Functions      
      Upon successful completion you will be able to:

1. Understand Text Functions;
2. Use the CONCATENATE Function;
3. Use the LOWER Function;
4. Use the LEFT Function;
5. Add Function Arguments;
6. Use the PROPER Function;
7. Use the UPPER Function.		      
      Database Functions      
      Upon successful completion you will be able to:

1. Understand Database Functions;
2. Understand Database Arguments;
3. Use the DSUM Function;
4. Use the DCOUNT Function;
5. Use the DMIN Function;
6. Use the DMAX Function.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2007 - Logical Functions, Text Functions and Database Functions :
Program Training Courses - Microsoft Excel 2007 :
Office Suite Training Courses - Microsoft Office 2007 :
© 2017 Online Training Masters