1-01
2-01
3-01
4-01
5-01
6-01
7-01
8-01
9-01
10-01

Microsoft Excel Training Program

Institute of Career Development, Bangladesh – ICDB is one of the leading training center for Microsoft Excel in Bangladesh. Till now, more than 1200 participants in different professions got trained from ICDB. 

 ICDB developed two specialized courses in MS Excel. 

  • Certified Master Course on MS Excel (Level – Fundamental to Intermediate) 
  • Advanced MS Excel for Professionals (Level – Advanced)
The course content are developed purely practical studies and case based. As per participants of these course, the materials and training methodologies are up to the mark which represents on the review of our participants. 
 
Review 1
Review 2
Review 3
Review 4
Review 5
Review 6
Review 7
Review 8

Course Content

Certified Master Course on MS Excel
  • Duration: 6 Weeks (Total 6 Classes)
  • Course fee: Tk. 2500
  • Number of Students in a batch: 8
THE EXCEL SCREEN

• Quick Access Toolbar
• Tabs
• Ribbion
• Name Box
• Formula Bar
• Rows, Columns, Cells
• Sheets
• Zoom
• Word book VS Word Sheet
• Cell VS Range
• Simple Data Entry
• Selecting Ranges
• Saving workbook formats
• Find & Replace

TEXT TO COLUMNS

• Separator is Space
• Separator is &
• Separator is @

VIEWING WORKSHEETS

• Hiding/ Unhiding Columns/Rows
• Freezing Panes
• Splitting windows

CUSTOM VIEWS

• Creating Custom Views
• Displaying Custom Views
• Deleting Custom Views

BASIC FORMULA -2

• Sum
• Average
• Max
• Min
• Sumif
• Sumif
• Countif
• Chart Management
• Data Sorting
• Conditional Formatting

VLOOKUP & H-LOOKUP

• VLOOKUP with Exact Match
• VLOOKUP Approximate Match
• VLOOKUP Rules
• VLOOKUP with Trim
• H-Lookup

REFERENCE

• Relative Reference
• Absolute Reference
• Mixed Reference

TEXT FORMATTING

• Left
• Right
• Mid
• Concatenate
• TRIM
• PROPER
• UPPER
• LOWER
• LEN

COPYING AND PASTING

• Copy
• Paste
• Paste Special
• Copying Cell(s) to One / Many Cells
• Copying to different Worksheets
• Using fill for quick copying

BASIC FORMULA

• Add/Subtract/Multiphy/Divide
• BODMAS
• Count Formula
• Counta Formula
• Countblank
• Countif

LOGICAL TEST

• If Functions
• Nested IF

FILTER & TABLE

• Advanced Filters
• Advanced Table
• Pivot Table

Advanced MS Excel for Professionals
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