Validity : 90 Days
 
2500     1500   Rs.1000/- OFF  
 


Basic To Advance Excel (Recorded)

Basic To Advance Excel (Recorded)
Buy Now

In this course, we shall provide to you the followings contents :-
  1. Basics formatting
  2. Basic Maths
  3. Copy and Paste/ Paste Special
  4. Absolute reference and Relative reference
  5. Basic 30 Functions
    1. SUM
    2. COUNT
    3. COUNTA
    4. COUNTBLANK
    5. LEFT
    6. RIGHT
    7. MID
    8. UPPER
    9. LOWER
    10. PROPER
    11. DAY
    12. YEAR
    13. MONTH
    14. DATEDIF
    15. NOW
    16. TODAY
    17. VLOOKUP
    18. HLOOKUP
    19. IF
    20. COUNTIF
    21. SUMIF
    22. RANDBETWEEN
    23. ISERROR
    24. DATE
    25. CONCATENATE
    26. FIND
    27. AVERAGE
    28. MIN
    29. MAX
    30. IFERROR
  6. Sorting,
  7. Filtering,
  8. Name range,
  9. Conditional Formatting
  10. PIVOT table
  11. Macro the beginning
One EBOOKLET and TWO Assignments are attached. The course validity is 30 days.



© Copyright VIKOM INSTITUTE & CONSULTANTS PRIVATE LIMITED 2024 . All rights reserved. Technology Partner - TutorArc