Microsoft Excel

40 videos from scratch to advanced level with certification

Week 1 : 

 

Understanding the basics of Excel

Week 2 : 

 

Understanding important functions in Excel

Week 3 : 

 

Understanding advanced excel functions.

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 2 : Important functions in Excel

10. Sum-Sumif-Sumifs

11. Count-Countif-Countifs

12.Average-Average if

13. Max-Min

14. Large-Small

15.Round

16. If or And

17. If-Error

18.Sum product

19. Sub Total

20. CAGR

21. Freezing

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 

 

7006559176, 9650746842

©2019 by FinLadder.