Week 1 : Getting Started with excel​

1. Introduction to Excel worksheet.

2.Excel essentials.

3.Setting print area.

4. Paste special

5.Filter and sort

6.Custom Formatting

7. Filter and sort

8.cusrtom Formatting 

9. Conditional Formating.

​

Week 3 Important Concepts

 22. Vlookup-Hlookup

23. Match

24. Lookups with Match

25. Data Validation

26. Lookups continued

27. Index

28. Index and March

29. Text function

30. Choose function

31. Developer Tab

32. Grouping and Ungrouping 

33. Text to Columns

34. Date functions part1 

35. Date functions part 2

36. Area and line charts

37. Doughnut and pie chart

38. Pivot Table

39. Protection

40. Formula Auditing