Module 1 Basic Computer
-
-
- Basic Concept of Computer
- English Typing
- Hindi Typing
- Data Entry
-
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
-
Advanced 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, XLOOKUP, 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…
-
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..
-
Module 2 DTP (Desktop Publishing)
CorelDraw
-
-
- Introduction to CorelDraw tools
- Set Bar’s
- PowerClip
- Logo Design, Book Cover page design, Pamphlet, Brochures, Banner etc.
- Tracing ( Logo, Cartoon’s )
- Text Effect
- Bevel Effect
- Transforming Objects
- Outlining & Filing Objects
- Working with Bitmaps
- Project Work
- and many more….
-
Adobe Photoshop
-
-
- Introduction to Adobe Photoshop tools
- Adjustments
- Layers, Channels, Paths
- Layer Mask, Vector Mask, Clipping Mask, Quick Mask
- Retouching Image
- Color Correction
- Background
- Typography
- Project Work
- and many more….
-
Module 3 Tally (Prime) with GST
-
-
- Basic Concept of Accounting
- Computerized Accounting
- Ledger Posting
- Multiple Ledger
- All Voucher Entries
- Accounting Features
- Inventory Features
- Balance Sheet
- P & L Account
- Multiple Price Level
- Bank Reconciliation
- Interest Calculation
- Stock Summary
- Post Dated Voucher
- GST (IGST, CGST, SGST)
- Knowledge of Taxation
- Project Work
- Interview Preparation
- Job Skill Concepts
- And Many More…
-
Module 4
-
-
- Personality Development
- Interview Preparation
- Job Skill Training
- Basic concept of Hardware
-
