Excel On Steroids Tips And Tricks Vol 5

  1. USING FILTERING OPTIONS
  2. USING THE DATEIF FUNCTION
  3. THE RIGHT FUNCTION
  4. PUBLISHING AN EXCEL WORKBOOK TO AN INTRANET/INTERNET LOCATION
  5. SPLITTING OF WINDOWS
  6. MULTIPLE DATA CONSOLIDATIONS FOR PIVOT TABLES
  7. TEXT CONVERSIONS
  8. TEXT LENGTHS IN EXCEL
  9. EXCEL TIP ERROR TRAPPING
  10. CUSTOMIZING RIBBONS
  11. PERSONAL MACRO CUSTOM FORMAT
  12. TEXT FUNCTION IN EXCEL
  13. MAIL MERGE