Most commonly used functions:

1. Vlookup
2. Index & Match
3. Rows
4. IF and Nested IFs
5. Sumproduct
6. Sum
7. Choose
8. Date
9. Days
10. Trim
11. Right, Left, Mid, Upper, Lower
12. Concatenate
13. Substitute
14. Randbetween
15. ISERROR
16. ISNUMBER
17. ISTEXT
18. COUNT, COUNTA
19. COUNTIF, COUNTIFS
20. ISEVEN, ISODD

Below is the list of some important Excel features or tools one should learn:

1. Interactive dashboards
2. Slicers and Timelines
3. 400+ functions (not all you will need to use. Shortlist as per your need)
4. Charts & Graphs
5. VBA for Excel
6. Power Pivot, Power View, Power Map and Power Query
7. Data cleaning techniques
8. Data analysis
9. Data science
10. Microsoft BI
11. Conditional formatting
12. Data validation
13. Paste special
14. Go to special
15. Excel table
16. OLAP pivot table
17. Excel shortcut keys
18. Excel tips & tricks

Also visit
​Homepage​​​
​MS EXCEL TRAINING​​​