Class Start: ……
Seats Available: 10 only (First come first serve)
Admission Deadline:
Duration: 8 Weeks
Class Time:
Course Fees – 6,000/- Tk.
PURE ADVANCED COURSE ON MICROSOFT EXCEL
Microsoft Excel has proven to be one of the most important applications for businesses around the world. Yet most of its powerful features are underutilized. Boost your productivity with an Excel training course and learn to utilize them to the full.
Methodology
Hands on training with practice sessions.
Course Content
1. SUM
2. AVERAGE
3. MIN
4. MAX
5. COUNT
6. Sumif
7. Sumif with Numeric Criteria
8. Sumif with Text Criteria
9. Sumif with Date Criteria
10. Case – 1
11. Case – 2
12. Sumifs
13. Countif
14. Countifs
15. AVERAGEIF
16. AVERAGEIFS
17. Minifs
18. Maxifs
19. Reference
20. Relative Reference
21. Absolute Reference
22. Mixed Reference
23. Large
24. Small
25. 12 Important Shortcuts
26. Consolidation
27. 3d sum
28. Consolidation Static All Same
29. Consolidation Linked All Same
30. Data Validation
31. Whole Numbers
32. Text Length
33. Date
34. Drop Down List
35. Input Messages
36. Error Messages
37. Stop
38. Warning
39. Information
40. VLOOKUP
41. VLOOKUP ( EM)
42. VLOOKUP (AM)
43. Quiz
44. Vlookup Advanced – 1
45. Vlookup Advanced – 2
46. Vlookup Advanced – 3
47. Match
48. Vlookup + Match
49. Vlookup + Match Advanced
50. Vlookup + Match Advanced 2
51. Hlookup + Match Advanced 1
52. Nested Vlookup
53. Nested Vlookup Advanced
54. Index Function
55. Index Function 2
56. Index Function 3
57. Paste Special
58. Values
59. Values 123 + Number formatting
60. Picture
61. Picture linked
62. Linked source
63. Transpose
64. Formatting
65. Conditional Formatting
66. Advanced Conditional
67. IF
68. If Case
69. If and
70. If or
71. Nested IF
72. Case – 1
73. Case – 2
74. Date
75. Today
76. Now
77. Day
78. Month
79. Year
80. Date
81. Edate
82. Network Days
83. Network Days.intl
84. Time
85. Case – 3
86. Project – 1 (Membership)
87. Protection
88. File
89. Cell
90. Sheet
91. Range
92. Name Range
93. Whatif
94. Scenarios
95. Goal Seek
96. Whatif Table
97. Text to Column
98. Data Input
99. Fundamental Financial Formulas
100. PMT
101. IMPT
102. PPMT
103. PV
104. FV
105. Isnumber
106. Istext
107. Iserror
108. Isformula
109. Offset Function
110. Chart
111. Pie
112. Bar
113. Column
114. Line Chart
115. Map
116. XY Scatter Chart
117. Spark Line Chart
118. Treemap
119. Combo
120. Dashboard
121. Flash Fill
122. Advanced Table
123. Pivot Table
124. Pivot Chart
125. Slicer
126. Group Slicer
127. Dashboard
128. Power Pivot
129. Fundamental MACROS
130. Print section
131. Page Layout
132. Tips and Tricks
Case Studies
- Big Data Analysis
- Report Management
- Payroll / Salary Sheet
- Sales and Bonus System
- Grading System
- Dashboard
- Sales Report
- Pivot Dashboard
- Multiple Pivot Tables