Schedule a Conversation | Contact Us

Excel On Steroids Tips And Tricks Vol 4

  1. Home /
  2. Excel On Steroids Tips And Tricks Vol 4
  1. USING THE TAB KEY TO MOVE TO THE NEXT  INPUT CELL
  2. TRAPPING ERROR MESSAGES
  3. DATE CALCULATIONS & FORMULAS
  4. CUSTOMIZING VALIDATION LISTS
  5. AVERAGING A NON-CONTIGUOUS RANGE
  6. FORMATTING  YEAR  VALUES REPRESENTED  AS DECIMALS TO SHOW YEARS & MONTHS
  7. DATE VALIDATION
  8. QUICK WAY OF CREATING A CHART
  9. EDITING SELECTED CELLS ON A PROTECTED WORKSHEET
  10. FORMULA TO FIND DUPLICATE VALUES IN A DATA RANGE
  11. SWITCHING BETWEEN RELATIVE, ABSOLUTE, AND MIXED REFERENCES
  12. GENERATING OF RANDOM NUMBERS FOR TESTING OF FORMULAS