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)
- 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
MIS Reports
-
-
- Types of Reports: Operational, tactical, strategic
- Creating Reports: Templates, data collection, presentation
- Automating Reports: Macros, scheduled reports
- Project Work
- and many more….
-
Pivot Tables
-
-
- Basics: Creating, designing pivot tables
- Advanced Techniques: Grouping, calculated fields, charts
- Insights: Analyzing data, using slicers, timelines
- Project Work
- and many more….
-
Dashboard Creation
-
-
- Introduction: Purpose, types of dashboards (Operational, Analytical, Strategic)
- Excel Dashboards: Data prep, chart selection, using slicers
- Advanced Excel: Pivot tables/charts, Power Pivot, dynamic dashboards
- Design Principles: Layout, color usage, readability
- SQL Integration: Pulling live data, combining with Excel for dashboards
- Advanced Features: Real-time dashboards, automation, sharing/collaboration
- Project Work
- and many more….
-
Module 3 SQL
-
-
- Create, Manage Databases and Tables
- Insert, Update, and Delete Data in tables
- Select with filters(where) and Sorting(Order By)
- Use join to combine data from multiple tables
- Use functions like Sum,Avg, Count, MIN, and MAX
- Create table relationships with foreign key
- And Many More…
-
Module 4
-
-
- Personality Development
- Interview Preparation
- Job Skill Training
-