Best Seller Icon Bestseller

Certificate In Advance MS Excel & MS Word(M-CAME&MW-1363)

  • Last updated May, 2026
  • Certified Course
Video Images
Preview this course
₹4,500 ₹5,000

Course Includes

  • Duration2 Months
  • Enrolled1
  • Lectures45
  • Videos1
  • Notes6
  • CertificateYes

What you'll learn

Learn Advanced Microsoft Excel and MS Word from Beginner to Professional Level in Hindi. This complete computer course is specially designed for students, office workers, job seekers, business owners, and anyone who wants to improve office productivity skills.

In this course, you will learn Advanced Excel formulas, VLOOKUP, XLOOKUP, Pivot Tables, Dashboard Creation, Conditional Formatting, Data Validation, Power Query, MIS Reports, Macros & VBA Basics, and many real office projects.

You will also master MS Word professional document formatting, resume design, mail merge, table of contents, headers & footers, page layout, templates, forms, PDF export, and official office documents.

This practical training course helps you become job-ready and improve your computer skills for office work, freelancing, business tasks, and professional reporting.

What You Will Learn:

  • Advanced Excel Formulas
  • VLOOKUP & XLOOKUP
  • Pivot Tables & Charts
  • Dashboard Creation
  • MIS Reports
  • Power Query
  • Macros & VBA Basics
  • Professional MS Word Formatting
  • Resume & Cover Letter Design
  • Mail Merge
  • Templates & Forms
  • PDF Export
  • Real Office Projects

This course is perfect for:

  • Students
  • Computer Learners
  • Office Employees
  • Data Entry Operators
  • MIS Executives
  • Freelancers
  • Business Users

Learn step by step with practical examples and improve your office computer skills professionally.


Show More

Course Syllabus

Advanced Excel & MS Word Complete Course Syllabus

Module 1: Computer & MS Office Introduction

  • Introduction to MS Office
  • Understanding Office Applications
  • File Management Basics
  • Keyboard Shortcuts
  • Office Productivity Tips

Advanced Excel Syllabus

Module 2: Excel Basics

  • Introduction to Excel Interface
  • Workbook & Worksheet
  • Rows, Columns & Cells
  • Data Entry Methods
  • Formatting Basics
  • Save & Print Workbook

Module 3: Excel Formatting

  • Cell Formatting
  • Font & Alignment
  • Borders & Colors
  • Number Formatting
  • Conditional Formatting
  • Format Painter

Module 4: Basic Formulas & Functions

  • SUM
  • AVERAGE
  • MIN & MAX
  • COUNT & COUNTA
  • Basic Percentage Formula
  • AutoSum

Module 5: Advanced Formulas

  • IF Function
  • Nested IF
  • SUMIF & COUNTIF
  • VLOOKUP
  • XLOOKUP
  • HLOOKUP
  • INDEX & MATCH
  • TEXT Functions
  • DATE & TIME Functions
  • Logical Functions

Module 6: Data Management

  • Sorting Data
  • Filtering Data
  • Remove Duplicates
  • Data Validation
  • Text to Columns
  • Flash Fill

Module 7: Charts & Visualization

  • Column Chart
  • Pie Chart
  • Line Chart
  • Bar Chart
  • Combo Chart
  • Sparklines

Module 8: Pivot Table & Dashboard

  • Pivot Table Basics
  • Pivot Chart
  • Slicers
  • Dashboard Design
  • Interactive Reports

Module 9: Professional Excel Projects

  • Salary Sheet
  • Attendance Sheet
  • Invoice Design
  • Sales Report
  • Stock Management
  • MIS Report

Module 10: Excel Automation

  • Macros Recording
  • VBA Basics
  • Buttons & Forms
  • Report Automation

MS Word Syllabus

Module 11: MS Word Basics

  • Introduction to MS Word
  • Typing & Editing
  • Font Formatting
  • Paragraph Formatting
  • Bullets & Numbering

Module 12: Professional Document Design

  • Resume Design
  • Cover Letter
  • Letterhead Design
  • Page Borders
  • Watermark
  • Cover Page

Module 13: Page Layout & Printing

  • Margins & Orientation
  • Columns
  • Page Breaks
  • Headers & Footers
  • Page Numbering
  • Print Settings

Module 14: Tables & Objects

  • Insert Tables
  • Table Formatting
  • Shapes & Icons
  • Pictures & SmartArt
  • Charts in Word

Module 15: Advanced MS Word Features

  • Mail Merge
  • Table of Contents
  • Hyperlinks
  • Bookmarks
  • Track Changes
  • Comments & Review

Module 16: Forms & Templates

  • Create Forms
  • Templates Design
  • Certificates
  • Official Documents

Module 17: PDF & Sharing

  • PDF Export
  • Document Protection
  • Sharing & Collaboration
  • Final Project Work

Bonus Topics

  • Office Productivity Tips
  • Real Office Practice
  • Shortcut Keys
  • Interview Preparation
  • Job-Oriented Assignments
  • Practice Files & Projects


Course Fees

Course Fees
:
₹5000/-
Discounted Fees
:
₹ 4500/-
Course Duration
:
2 Months

Review

0.0
Course Rating (0 reviews)
0%
0%
0%
0%
0%



Call
Text Message
Review
Email
CHAT