Excel 2003 - Using Advanced Functions, Absolute References and Named Ranges
      The "Excel 2003 - Using Advanced Functions, Absolute References and Named Ranges" lesson covers the following topics:
  • Relative and Absolute Referencing
  • Inserting Functions
  • Working with Named Ranges
  • Vlookup and Hlookup
     
      Relative and Absolute Referencing      
      Upon successful completion you will be able to:

1. Copy cells using Relative Referencing;
2. Identify use of Absolute References;
3. Apply an Absolute Reference;
4. Copy Absolute Reference Formulas.
      
      Inserting Functions      
      Upon successful completion you will be able to:

1. Identify Function Components;
2. Use the NOW Function;
3. Apply the IF Function;
4. Work with the PMT Function;
5. Use Logical Operators;
6. Edit Functions.
      
      Working with Named Ranges      
      Upon successful completion you will be able to:

1. Use Menu Bar to Automatically Name Cells;
2. Navigate using Name Cells;
3. Apply Shortcut Keys to Name Cells;
4. Use Range Names in Formulas;
5. Delete a Named Range.
      
      Vlookup and Hlookup Functions      
      Upon successful completion you will be able to:

1. Identify the Function of Vertical Lookup;
2. Create a Lookup Table.
3. Activate the VLOOKUP function;
4. Input VLOOKUPs main arguments;
5. Manually enter the VLOOKUP function;
6. Differentiate between VLOOKUP & HLOOKUP.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2003 - Using Advanced Functions, Absolute References and Named Ranges :
Program Training Courses - Microsoft Excel 2003 :
Office Suite Training Courses - Microsoft Office 2003 :
© 2017 Online Training Masters