1. Basic Concept of Computer
2. English Typing
3. 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 Marge
- Document Views & Macros
- Saving & Protecting Sheets Documents
- Project Work
-
4. Adv. 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
- and many more…
-
5. MS PowerPoint
-
-
- Creating & Printing Slides
- Adding Custom Animation
- Using Slide Transitions
- Using Charts, Graphs & Photo Album
- Creating Professional Presentation
- Project Work
-
6. Internet
-
-
- Introduction to Internet
- Browser Basics
- Downloading, Searching, Surfing and Storing Data
- Online Forms Submission
- Online Bill Payment
- Online Ticket Booking
-
and many more..
