93 Excel Formulas ( Made Easy )

This Book will understand you following formulas with proper examples; 1. SUM of Digits when cell Contains all Numbers 2. SUM of Digits when cell Contains Numbers and non Numbers both 3. A List is Unique or Not (Whether it has duplicates) 4. Count No. of Unique Values 5. Count No. of Unique Values Conditionally 6. Add Month to or Subtract Month from a Given Date 7. Add Year to or Subtract Year from a Given Date 8. Convert a Number to a Month Name 9. Converting Date to a Calendar Quarter 10. Converting Date to a Indian Financial Year Quarter 11. Calculate Age from Given Birthday 12. Number to Date Format Conversion 13. Number to Time Format Conversion 14. Count Cells Starting (or Ending) with a particular String 15. Count No. of Cells Having Numbers Only 16. Count No. of Cells which are containing only Characters 17. Number of Characters in a String without considering blanks 18. Number of times a character appears in a string 19. Count Non Numbers in a String 20. Count Numbers in a String 21. Count only Alphabets in a String 22. Most Frequently Occurring Value in a Range 23. COUNTIF on Filtered List 24. SUMIF on Filtered List 25. Extract First Name from Full Name 26. Extract Last Name from Full Name 27. Extract the Initial of Middle Name 28. Extract Middle Name from Full Name 29. Remove Middle Name in Full Name 30. Extract Integer and Decimal Portion of a Number 31. First Day of the Month for a Given Date 32. How Many Mondays or any other Day of the Week between 2 Dates 33. Maximum Times a Particular Entry Appears Consecutively 34. Find the Next Week of the Day 35. Find the Previous Week of the Day 36. Get File Name through Formula 37. Get Workbook Name through Formula 38. Get Sheet Name through Formula 39. Get Workbook's Directory from Formula 40. Last Day of the Month for a Given Date 41. Perform Multi Column VLOOKUP 42. VLOOKUP from Right to Left 43. Case Sensitive VLOOKUP 44. Rank within the Groups 45. Remove Alphabets from a String 46. Remove numbers from string 47. Roman Representation of Numbers 48. Sum Bottom N Values in a Range 49. Sum Every Nth Row 50. We have AVERAGEIF. What about MEDIANIF and MODEIF? 51. Number of Days in a Month 52. How to Know if a Year is a Leap Year 53. Last Working Day of the Month If a Date is Given 54. First Working Day of the Month if a Date is Given 55. Date for Nth Day of the Year and many others..