Overview:

The Certificate in MS-Word, MS-Excel, MS-PowerPoint (CMS) is a 6-month professional training course offered by the National Council of Training Academy (NCTA). This programme is designed to equip learners with essential computer application skills in documentation, data management, and presentations. It is ideal for beginners, students, job seekers, office professionals, and anyone looking to enhance their digital productivity and employability.

The course provides a balanced mix of theory and practical training covering MS-Word, MS-Excel, and MS-PowerPoint in depth. Learners will gain expertise in creating professional documents, managing and analysing data, and designing impactful presentations.

Course Curriculum:

The CMS course emphasises hands-on training and practical application for personal, academic, and professional use. The curriculum includes:

1. MS-Word
   1. Introduction to Word Processing
   2. Creating, Editing & Formatting Documents
   3. Page Layout, Margins, and Styles
   4. Inserting Tables, Images, Charts & SmartArt
   5. Mail Merge & Labels
   6. Proofing Tools (Spelling, Grammar, Track Changes)
   7. Document Security & Printing Options
       
2. MS-Excel
   1. Basics of Spreadsheets & Data Entry
   2. Formatting Cells, Rows & Columns
   3. Formulas & Functions (SUM, IF, VLOOKUP, HLOOKUP, etc.)
   4. Data Sorting, Filtering & Validation
   5. Charts, Graphs & PivotTables
   6. Conditional Formatting
   7. Basic Data Analysis & Reporting
       
3. MS-PowerPoint
   1. Introduction to Presentation Tools
   2. Creating & Designing Slides
   3. Slide Layouts, Themes & Templates
   4. Inserting Multimedia (Images, Audio, Video)
   5. Animations & Slide Transitions
   6. Using Charts & SmartArt in Presentations
   7. Delivering & Printing Presentations
       
4. Practical Sessions & Projects
   1. Designing a Professional Resume in MS-Word
   2. Creating Budget & Sales Reports in MS-Excel
   3. Designing Business Presentations in MS-PowerPoint
   4. Integrated Project combining Word, Excel & PowerPoint
       

Learning Outcomes:

After completing the CMS course, learners will be able to:

1. Create, edit, and format professional documents in MS-Word.
2. Use MS-Excel for data entry, analysis, and reporting with formulas and functions.
3. Design engaging and professional presentations in MS-PowerPoint.
4. Apply productivity tools for office, academic, and personal use.
5. Integrate Word, Excel, and PowerPoint for business and professional tasks.
6. Improve digital literacy and workplace efficiency.
    

Career Opportunities:

Successful graduates can pursue roles such as:

1. Office Assistant
2. Data Entry Operator
3. Documentation Executive
4. Administrative Support Staff
5. Presentation Designer
6. Back Office Executive
    

Salary Expectations:

Entry-level salaries for candidates skilled in MS-Word, MS-Excel, and MS-PowerPoint typically range from ₹8,000 – ₹15,000 per month, depending on the role, organisation, and location. Professionals with strong expertise in Excel (data analysis, reporting, MIS) can earn higher salaries. With experience and advanced certifications (like MS Office Specialist, Advanced Excel), career growth and better earnings are achievable.