Excel Skills


When we talk about Excel skills, we can further categorize them in 3 levels:

  • Basic Excel Skills
  • Intermediate Excel Skills
  • Advanced Excel Skills

Basic Excel Skills

1. Saving and Opening a Workbook
2. Managing Worksheets
3. Formatting Cells

4. Printing

5. Excel Functions (Basic)

6. Charts

7. Sorting Data

8. Find and Replace Option

9. Paste Special Option

10. Keyboard Shortcuts



Intermediate Excel Skills

11. Go To Special

12. Pivot Table

13. Named Range

14. Drop Down Lists

15. Conditional Formatting

16. Excel Table

17. Idea Button

18. Using Sparklines

19. Text to Column

20. Quick Analysis Tool


Advanced Excel Skills

21. Advanced Excel Formulas

22. Advanced Excel Charts

23. Visual Basic for Applications