6 Class Advance Microsoft Office Excel Course

MS Excel

1. Introduction of MS Excel
2. Creating new workbook
3. How to cut, copy, paste and save
4. How to change font , text editing
5. How to use orientation option
6. Conditional formatting
7. Tables & cell styles and set row and columns
8. Hide & unhide row & columns
9. Use toolbar & shortcut
10. How to use quick access toolbar
11. Using status bar to find sum, average etc.
12. Remove formatting
13. Addition, subtraction, division
14. How to use clipboard to copy & paste
15. Data validation
16. How to create drop down value
17. How to set limit for data & time using data validation
18. Preventing duplicate entries & all text/number
19. Consolidate
20. Lookup formula
21. Change background
22. Vlookup
23. Hlookup
24. How to freeze and unfreeze multiple row & column
25. Rand & rand between formula
26. PMT formula
27. Goal seek formula
28.  Insert chart
29. How to calculate insert & principal amount
30. Averageif & averageifs formula
31. Create template
32. Count formula
33. Concatenate formula
34. FV formula
35. Set password
36. Dsum formula
37. DGET, Daverage , sum product formula
38. Ceiling , and floor formula
39. Fore cast formula
40. LCM , ratio
41. How to calculate overtime hours
42. Interest
43. Sumifs frequency rank formula
44. Pivot table
45. Merge data
46. Hyperlink create
47. Overview of dashboards
48. Business dashboard creation
49. RDBMS & SQL (basic)
50. Data analysis and reporting
51. Data manipulation using fuctions
52. Data visualization excel
53. Introduction to analytics & data science
54. Create dashboard in excel – using pivot controls
55. Data manipulation using functions
56. Data analysis and reporting
57. Data visualization excel