Excel 2010 - Using Named Ranges, Financial Functions and Data Tables
      The "Excel 2010 - Using Named Ranges, Financial Functions and Data Tables" lesson covers the following topics:
  • Logical and Informational Functions
  • Named Ranges
  • Financial Functions and Data Tables
      
      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.		      
      Named Ranges      
      Upon successful completion you will be able to:

1. Name Cells and Ranges;
2. Edit Named Ranges;
3. Change Range Names;
4. Navigate using Cell Names;
5. Use Range Names in Formulas;
6. Delete a Named Range.

      
      Financial Functions and Data Tables      
      Upon successful completion you will be able to:

1. Understand Financial Arguments;
2. Use the FV Function;
3. Use the PMT Function;
4. Use the NPV Function;
5. Use the PV Function;
6. Use the RATE Function;
7. Use Data Tables.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2010 - Using Named Ranges, Financial Functions and Data Tables :
Program Training Courses - Microsoft Excel 2010 :
Office Suite Training Courses - Microsoft Office 2010 :
© 2017 Online Training Masters