Basic Excel Training

Tanvi Thukral

profile
Best Seller
Basic Excel Training
profile
Courses

If you use excel daily but are not using the basic formulaes, then you are taking twice the time you should, and a colleague who knows excel better will take away the promotion. so subscribe today to course . I will teach you :

  1. SUM – Add numbers
  2. AVERAGE – Calculate average
  3. COUNT – Count cells containing numbers
  4. COUNTA – Count non-empty cells
  5. MIN – Find smallest value
  6. MAX – Find largest value
  7. IF – Apply logical conditions
  8. AND – Check if multiple conditions are true
  9. OR – Check if any condition is true
  10. IFERROR – Handle errors gracefully
  11. SUMIF – Sum values based on one condition
  12. SUMIFS – Sum values based on multiple conditions
  13. COUNTIF – Count cells matching a condition
  14. COUNTIFS – Count cells matching multiple conditions
  15. AVERAGEIF – Average values based on a condition
  16. VLOOKUP – Vertical lookup
  17. HLOOKUP – Horizontal lookup
  18. XLOOKUP – Modern lookup function
  19. INDEX – Return value from a specified position
  20. MATCH – Find position of a value
  21. INDEX + MATCH – Advanced alternative to VLOOKUP
  22. CONCAT / CONCATENATE – Join text strings
  23. TEXTJOIN – Combine text with a delimiter
  24. LEFT – Extract characters from the left
  25. RIGHT – Extract characters from the right
  26. MID – Extract characters from the middle
  27. LEN – Count characters in a cell
  28. TRIM – Remove extra spaces
  29. UPPER – Convert text to uppercase
  30. LOWER – Convert text to lowercase
  31. PROPER – Capitalize first letter of each word
  32. FIND – Find position of text
  33. SUBSTITUTE – Replace specific text
  34. TODAY – Return current date
  35. NOW – Return current date and time
  36. DATEDIF – Calculate difference between dates
  37. YEAR – Extract year
  38. MONTH – Extract month
  39. DAY – Extract day
  40. TEXT – Format values as text

Other Important Excel Features Often Asked in Interviews

  1. Pivot Tables
  2. Pivot Charts
  3. Conditional Formatting
  4. Remove Duplicates
  5. Data Validation (Drop-down Lists)
  6. Filters & Advanced Filters
  7. Sort Data
  8. Freeze Panes
  9. Text to Columns
  10. Flash Fill

Terms | Privacy
₹499
Terms | Privacy