Syllabus
Course: DCA
Duration: 6 Month
✅Basic
1. Basic
Fundamental
2. About
Folder with Shortcut keys
3. MS Paint
(File Menu)
4. MS Paint
(Edit Menu & View Menu)
5. Notepad
(File Menu)
6. Notepad (Edit
Menu & View Menu)
✅MS Word
1. MS Word
(File Menu)
2. MS Word
(Home Menu)
3. Clipboard
& Font Group
4. Paragraph,
Styles, Editing Group
5. MS Word
(Insert Menu)
6. Pages &
Tables Group
7. Picture
& Clipart
8. Shapes
& SmartArt
9. Chart &
Screenshot
10. Hyperlink,
Bookmark & Cross Reference
11. Header,
Footer, Page Number
12. Text Box,
Quick Part, Word Art, Drop Cap
13. Signature
Line
14. Date &
Time, Object, Equation, Symbol
15. Themes
& Page Setup Group
16. Watermark,
Page Color, Page Border
17. Table of
Contents, Endnote & Footnote
18. Citation
& Bibliography, Caption
19. Index &
Table of Authorities
20. Mailing
21. Review Menu
22. View Menu
✅MS Excel
1. Excel
Introduction & File Menu
2. Clipboard,
Font & Alignment Group
3. Number
Group
4. Conditional
Formatting
5. Format as
Table & Cell Styles
6. Insert,
Delete & Format
7. Auto Sum,
Fill, Clear, Sort & Filter
8. Find &
Select
9. Table &
Pivot Table
10. Picture,
Clipart, Shape, SmartArt, Screenshot
11. About
Charts
12. Sparkline,
Slicer, Hyperlink
13. Text box,
Header & Footer, WordArt
14. Signature,
Object, Equation & Symbol
15. Page Setup
16. Formula
Auditing, Watch Window, Calculation
17. Get
External Data, Sort & Filter
18. Text to
Columns, Remove Duplicates, Data Validation
19. Consolidate
& What if Analysis
20. Group,
Ungroup & Subtotal
21. Review Menu
22. View Menu
✅Formula Syllabus
Maths Formula
1. Sum
2. Product
3. Count
4. Min
5. Max
6. Average
7. Abs
8. Fact
9. Factdouble
10. SQRT
11. LCM
12. GCD
13. Power
14. Mod
15. Quotient
16. Sumproduct
17. Counta
18. Countblank
19. Roman
20. Round
21. Roundup
22. Rounddown
23. Odd
24. Even
25. Pi
26. Subtotal
✅Text Formula
1. Lower
2. Upper
3. Proper
4. Left
5. Right
6. Mid
7. Trim
8. Rept
9. Search
10. Find
11. Replace
12. Substitute
13. Char
14. Code
15. Concatenate
✅Date & Time
1. Date
2. Day
3. Month
4. Year
5. Hour
6. Minute
7. Second
8. Today
9. Now
10. Edate
11. Eomonth
12. Weekday
13. Weeknum
14. Workday
15. Datevalue
16. Timevalue
17. Datedif
✅Logical Function
1. If
2. Countif
3. Sumif
4. Countifs
5. Sumifs
6. And
7. Or
8. Not
9. If with And
10. I with Or
11. If with Not
12. Ifferor
13. Iserror
✅Lookup & Reference
1. Lookup
2. Vlookup
3. Vlookup with multiple sheets
4. Double Vlookup
5. Reverse Vlookup
6. Image Vlookup
7. Vlookup with Match
8. Vlookup with Column
9. Vlookup with Columns
10. Vlookup with Row
11. Vlookup with Rows
12. Vlookup with Sum
13. Vlookup with Min
14. Vlookup with Max
15. Vlookup with If
16. Vlookup with Iferror
17. Vlookup with subtotal
18. Vlookup with Choose
19. Vlookup an empty cell, If
lookup is blank
20. Vlookup with two lookup
value
21. Vlookup with Sumproduct
22. Vlookup with Indirect
23. Vlookup apply in large data
24. Vlookup dynamically update
25. Hlookup
26. Vlookup with Hlookup
27. Index with Match
28. Offset with Match
✅Financial Function
1. PMT
2. IPMT
3. PPMT
4. PV
5. FV
✅PowerPoint
1. Home Menu
2. Insert menu
3. Design Menu
4. Transition Menu
5. Animation Menu
6. Slide Show Menu
7. Review Menu
8. View Menu
✅Internet
✅ Google Sheet
✅ Basic Website Design
✅ Basic Digital Marketing
✅ Online Earning Tips
Facilities for Students ✅ Free 100+ PDF Notes ✅ Free 500+ Practical Assignment ✅ Recorded Videos ✅ Downloadable Videos ✅Official Job Training ✅ Life Time Support ✅Online Test : Every Monday ✅ Final Exam : After Course Completion ✅ Certificate: Deliver By Mail or By Post
){kind=link}
0 Comments