BECOME a Advanced Excel EXPERT

6. Understanding a Formula
7. Rules of the Formula
8. Understanding the Syntax
9. Different Categories of Functions
10. Characteristics of Arguments
11. Types of Cell References
12. Define Names

13. 70+ Excel Functions includes
    i) Mathematical Functions (SUM, SUMIF, SUMIFS, AGGREGATE, SUBTOTAL, SUMPRODUCT etc.,)
    ii) Text Functions (LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE etc.,)
    iii) Logical Functions (IF, IFERROR, AND, OR etc.,)
    iv) Lookup Functions (VLOOKUP, HLOOKUP, CHOOSE, INDEX, MATCH, INDIRECT, OFFSET etc.,)
    v) Financial Functions (FV, PV, NPV, IRR, RATE etc.,)
    ​vi) Statistical Functions (AVERAGE, MAX, MIN, COUNT, RANK etc.,)
    vii) Date & Time Functions (DATE, MONTH, YEAR, DATE, WEEKDAY, DATEDIF etc.,)

14. Writing Nested Formula
15. Array Functions
16. Re-Engineering of Formula
17. Formula Auditing
18. Watch Window

19. Text to Columns
20. Sorting includes Custom Sorting
21. Filtering includes Advanced Filtering
22. Consolidation of more Datasets
23. Using Subtotals
24. Pivot Tables for
i) Range
ii) Tables
iii) External Data
25. Charts
26. Data Validation

27. Recording a Macro
28. Editing the Recorded Macro VBA Code
29. Saving the Macro for all workbooks
30. Assigning a Shortcut or Button to Macro

31. Comparison of Version 2007 Vs Version 2010 Vs Version 2013 Vs 2016
i) Spark-lines
ii) Slicers
iii) Timeline
iv) Falsh Fill
v) Recommended Charts / Pivot Tables
vi) Relationships under Pivot Table