- Basic Concept of Computer
- English Typing
- MS Word
- Font & Paragraph Formatting
- Editing, Saving & Printing Text Documents
- Inserting Table
- Header & Footer
- Smart Art
- Page Breaks
- Using List & Styles, Spelling & Grammar Check
- Understanding Document Properties & Tabs
- Mail Merge
- Document Views & Macros
- Saving & Protecting Sheets Documents
- Project Work
- MS Excel
- Introduction (Ms. Excel Window/Interface Parts, File Extension, How to Open/Exit.)
- All Definitions ( Excel, Workbook, Worksheet, Cell, Row ,Column)
- Entering and Editing Data.
- Inserting and Deleting Row or Column.
- Formatting Data
- Auto fill Lists ( Default lists & Creating new lists)
- Simple formulas (SUM, AVERAGE, PRODUCT, COUNT, QUOTIENT, MAX, MIN, ABS, ROUND, PERCENTAGE etc.)
- Sort, Filter, Adv. Filter, Subtotal, Macros, Protect Sheet, Protect Cell, Text to Columns, Name Manager, What if Analysis
- Charts (Working With Charts)
- Logical Functions (IF, AND, OR, NOT, IFERROR)
- Financial Functions (PMT, PV, RATE, FV, DB)
- Lookup Functions (CHOOSE, HLOOKUP, VLOOKUP, INDEX, MATCH, TRANSPOSE, HYPERLINK, ROW)
- Math & Trig Functions (SUM, SUMIF, SUMIFS, RANDBETWEEN,ROMAN)
- Text Functions (CHAR, CODE, CONCATENATE, UPPER, LOWER, PROPPER, LEN, MID, SEARCH, TRIM)
- MIS Report (PIVOT TABLE, PIVOT CHART, V LOOKUP, HLOOKUP, ADV. FILTER, SLICER, SPARKLINES, CONSOLIDATE, CONVERT, ABS, SUMPRODUCT, FIND DUPLICATE, TEXT)
- Project Work
- MS PowerPoint
- Creating & Printing Slides
- Adding Custom Animation
- Using Slide Transitions
- Using Charts, Graphs & Photo Album
- Creating Professional Presentation
- Project Work
- Internet
- Introduction to Internet
- Browser Basics
- Downloading, Searching, Surfing and Storing Data
- Online Forms Submission
- Online Bill Payment
- Online Ticket Booking
- and many more..
Requirements
- We expect some basic understanding of English.
- No age restriction.
- No academic requirement.
What is the target audience?
- This course is intended for anyone interested in learning computer.
- This course is aimed at beginners, so no previous experience with computer skills is necessary.
- The candidate planning for Government Job must have complete CCC course to prove he is computer literate.
- 8-10 Students per Batch
- Duration: 90 days
- Lectures: 60 (Mon- Fri)
- PDF Notes
- Certificate of Completion
