itdlh Excel workshop agenda


Advance Excel Workshop

Excel Functions

1.Conditional Function B. CONDITIONAL FUNCTIONS 13. AVERAGEIF 14. SUMIF 15. COUNTIF 16. AVERAGEIFS 17. SUMIFS 18. COUNTIFS 19. IF 20. IFERROR 21. IFNA

2.Mathamatical Functions 22. SUM 23. AVERAGE 24. AVERAGEA 25. COUNT 26. COUNTA 27. MEDIAN 28. SUMPRODUCT 29. SUMSQ 30. COUNTBLANK 31. EVEN 32. ODD 33. INT 34. LARGE 35. SMALL 36. MAX & MAXA 37. MIN & MINA 38. MOD 39. RAND 40. RANDBETWEEN 41. SQRT 42. SUBTOTAL D. FIND & SEARCH FUNCTIONS 43. FIND 44. SEARCH 45. SUBSTITUTE 46. REPLACE

E. LOOKUP FUNCTIONS 47. MATCH 48. LOOKUP 49. HLOOKUP 50. VLOOKUP F. REFERENCE FUNCTIONS 51. ADDRESS 52. CHOOSE 53. INDEX 54. INDIRECT 55. OFFSET G. DATE & TIME FUNCTIONS 56. DATE 57. DATEVALUE 58. TIME 59. TIMEVALUE 60. NOW 61. TODAY 62. YEAR(), MONTH(), DAY(), HOUR(), MINUTE(), SECOND() 63. WEEKDAY 64. DAYS 65. NETWORKDAYS 66. WORKDAY H. MISCELLANEOUS FUNCTIONS 67. AREAS 68. CHAR 69. CODE 70. CLEAN 71. TRIM 72. LEN 73. COLUMN() & ROW() Functions 74. EXACT 75. FORMULATEXT 76. LEFT(), RIGHT(), and MID() Functions 77. LOWER(), PROPER(), and UPPER() Functions 78. REPT 79. SHEET 80. SHEETS 81. TRANSPOSE 82. TYPE 83. VALUE

I. RANK FUNCTIONS 84. RANK 85. RANK.AVG 86. RANK.EQ J. LOGICAL FUNCTIONS 87. AND 88. NOT 89. OR 90. XOR Further Readings

B. CONDITIONAL FUNCTIONS

13. AVERAGEIF

=AVERAGEIF(range, criteria, [average_range])

Finds average (arithmetic mean) for the cells specified by a given condition or criteria