1. ENTERING DATA 
  2. UNDERSTANDING AND APPLYING FORMULAS 
  3. USING SUM, SUMIF,SUMIFS
  4. USING AVERAGE,AVERAGEIFS
  5. USING COUNT, COUNTIFS,
  6. FINDING MAX AND MINIMUM VALUE
  7. APPLYING CEIL, FLOOR, EVEN, ODD
  8. SORTING A TO Z AND VICE VERSA
  9. UNDERSTANDING THE MEANING AND IMPACT OF CELL REFERENCING
  10. MODIFYING 
  11. COPYING AND PASTING 
  12. REFERENCING FROM ONE SHEET TO ANOTHER
  13. FORMATTING AND SPECIAL PASTING FUNCTION
  14. USING FUNCTIONS LIKE IF, ELSE, OR , AND 
  15. OTHER NECESSARY FUNCTION
  16. FILTER
  17. TEXT TO COLUMNS
  18. REMOVE DUPLICATES
  19. DATA VALIDATION
  20. BASIC CHARTS AND GRAPHS
  21. ADVANCED FUNCTIONS
  22. VLOOKUP
  23. HLOOKUP
  24. INDEX
  25. MATCH
  26. PIVOT TABLES AND THEIR BASIC OPERATIONS
  27. VBA TOOLS AND MACROS (  ADVANCED EXCEL GIVES U AN EDGE)

LINKS:

  1. https://trumpexcel.com/learn-excel/#tab-con-11
  2. https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond

NOTE: EXCEL NEEDS PRACTICE. LEARNING THE FORMULAS WON’T HELP UNTIL YOU KNOW THEIR APPLICATION


Comments (2)

  1. Reply

    Youre so cool! I dont suppose Ive learn anything like this before. So good to find anyone with some authentic thoughts on this subject. realy thanks for beginning this up. this web site is one thing that is wanted on the internet, someone with just a little originality. helpful job for bringing one thing new to the web!

  2. Reply

    I抦 impressed, I must say. Really rarely do I encounter a weblog that抯 both educative and entertaining, and let me inform you, you’ve hit the nail on the head. Your idea is excellent; the difficulty is one thing that not sufficient persons are speaking intelligently about. I’m very completely happy that I stumbled throughout this in my search for something relating to this.

Leave a comment

Your email address will not be published. Required fields are marked *