Bandhan Tola, Nawada, Ara (Bhojpur), Biharcareeropticsconsultancy@gmail.com8252532179
JOB ORIENTED PRACTICAL TRAINING CERTIFICATION

DCA With AI

DCA with AI (Diploma in Computer Application + Artificial Intelligence) ek modern computer course hai jisme traditional computer skills ke sath generative AI aur smart tools sikhaye jaate hain & Master Microsoft Office from basic to advanced level. Learn MS Word, Excel, PowerPoint, Outlook, Access, professional documentation, data management, MIS reporting and practical office work.

★★★★★ 4.9 Student Rating
|💻 Practical Training🏆 Certificate
📝

MS Word

Basic to Advanced

📊

MS Excel

Formula & MIS

📽️

PowerPoint

Professional PPT

🗄️

MS Access

Database Basics

Course Fee
₹3,500 ₹6,000
SPECIAL ADMISSION OFFER
Duration 6 Months
Level Basic → Advanced
Mode Practical
Modules 12
Certificate Yes
Enroll Now → View Full Syllabus

No technical background required

Course Overview

Complete MS Office Package Course

This course is designed for students, beginners, job seekers, office employees and anyone who wants to become confident in professional Microsoft Office applications. You will learn how to create professional documents, manage data in Excel, prepare MIS reports, design presentations, manage emails, create databases and perform everyday digital office tasks.

📝

Professional Documentation

Create letters, resumes, reports, notices, certificates, forms and office documents using MS Word.

📊

Data & MIS Management

Use Excel formulas, functions, charts, PivotTables and reports for professional data management.

💼

Office Productivity

Build practical workplace skills using Word, Excel, PowerPoint, Outlook, Access and cloud tools.

Why Learn MS Office?

Skills You Will Build

📝

Word Skills

Create professional office documents and reports.

📊

Excel Skills

Manage data, formulas, reports and MIS.

📽️

Presentation Skills

Design professional PowerPoint presentations.

📧

Email Skills

Handle professional email, calendar and communication.

Course Content

MS Office Package Syllabus

12 Modules • Detailed Practical Training

✓ Introduction to Computer
✓ Types of Computers
✓ Hardware & Software
✓ Input & Output Devices
✓ CPU, RAM & ROM
✓ Storage Devices
✓ Windows Desktop
✓ Start Menu & Taskbar
✓ File Explorer
✓ Files & Folders
✓ Copy / Cut / Paste
✓ Software Installation
✓ Basic Troubleshooting
✓ Computer Security Basics
✓ MS Word Interface
✓ Create New Document
✓ Save & Open Documents
✓ Text Selection
✓ Font Formatting
✓ Font Size & Color
✓ Bold / Italic / Underline
✓ Paragraph Formatting
✓ Alignment
✓ Line Spacing
✓ Bullets & Numbering
✓ Find & Replace
✓ Page Setup
✓ Print Documents
✓ Tables
✓ Images
✓ Shapes
✓ Icons
✓ SmartArt
✓ Text Boxes
✓ Header & Footer
✓ Page Numbers
✓ Watermark
✓ Page Borders
✓ Styles
✓ Themes
✓ Table of Contents
✓ Mail Merge
✓ Resume Making
✓ Official Letter
✓ Notice Design
✓ Certificate Design
✓ PDF Export
✓ Document Protection
✓ Excel Interface
✓ Workbook & Worksheet
✓ Rows & Columns
✓ Cells & Ranges
✓ Data Entry
✓ Number Formatting
✓ Cell Formatting
✓ Row & Column Management
✓ Insert & Delete Cells
✓ AutoFill
✓ Basic Calculations
✓ Find & Replace
✓ Print Settings
✓ Page Setup
✓ Formula Basics
✓ SUM
✓ AVERAGE
✓ MIN & MAX
✓ COUNT
✓ COUNTA
✓ COUNTIF
✓ SUMIF
✓ IF Function
✓ AND / OR
✓ Percentage Calculation
✓ Date & Time
✓ Relative Reference
✓ Absolute Reference
✓ Basic Lookup
✓ Formula Error Handling
✓ Sort & Filter
✓ Advanced Filter
✓ Data Validation
✓ Conditional Formatting
✓ Excel Tables
✓ PivotTable
✓ PivotChart
✓ Charts & Graphs
✓ Dashboard Basics
✓ MIS Report
✓ Sales Report
✓ Attendance Report
✓ Employee Report
✓ Stock Report
✓ Data Protection
✓ Workbook Protection
✓ Print Area
✓ Professional Reporting
✓ PowerPoint Interface
✓ Create Presentation
✓ Slide Layout
✓ Themes
✓ Text Formatting
✓ Images
✓ Shapes
✓ Icons
✓ Tables
✓ Charts
✓ SmartArt
✓ Slide Show
✓ Notes
✓ Presentation Views
✓ Slide Master
✓ Custom Themes
✓ Background Design
✓ Transitions
✓ Animations
✓ Animation Pane
✓ Audio & Video
✓ Screen Recording
✓ Presenter View
✓ Speaker Notes
✓ Business Presentation
✓ Corporate Presentation
✓ Project Presentation
✓ PDF Export
✓ Outlook Interface
✓ Email Account Setup
✓ Compose Email
✓ Reply & Forward
✓ CC & BCC
✓ Email Attachments
✓ Email Folders
✓ Search Email
✓ Email Signature
✓ Contacts
✓ Calendar
✓ Appointments
✓ Meetings
✓ Tasks & Reminders
✓ Professional Email Writing
✓ Email Etiquette
✓ Database Introduction
✓ Access Interface
✓ Create Database
✓ Tables
✓ Fields & Records
✓ Data Types
✓ Primary Key
✓ Relationships
✓ Queries
✓ Forms
✓ Reports
✓ Sorting & Filtering
✓ Import Excel Data
✓ Export Data
✓ Database Project
✓ Internet Basics
✓ Web Browser
✓ Search Techniques
✓ Download & Upload
✓ PDF Management
✓ Google Drive
✓ Cloud Storage
✓ File Sharing
✓ Online Forms
✓ Digital Documents
✓ Scan & Print Workflow
✓ Online Meetings
✓ Digital Security
✓ Password Safety
✓ Backup & Recovery
✓ Word Professional Document
✓ Resume Preparation
✓ Official Letter
✓ Excel Data Entry Project
✓ Excel MIS Report
✓ Excel Dashboard
✓ PowerPoint Presentation
✓ Professional Email Task
✓ Access Database Project
✓ Office Documentation
✓ PDF Management Task
✓ Practical Examination
✓ Viva / Interview
✓ Final Skill Assessment
✓ Course Certification
Course Outcome

What You Will Be Able To Do

📝

Create Documents

Create professional letters, reports, resumes, forms and notices.

📊

Manage Data

Perform data entry, calculations, sorting, filtering and reporting.

📈

Prepare MIS

Prepare Excel-based MIS reports, charts and basic dashboards.

💼

Work Professionally

Use Office tools confidently for everyday workplace tasks.

Practical Training

Complete Office Practical Project

Students practice real-world office tasks instead of only learning theoretical concepts.

Join Practical Training
📝
Word Project Professional document
📊
Excel MIS Report & dashboard
📽️
PPT Project Presentation design
📧
Email Task Professional communication
Career Opportunities

Jobs You Can Prepare For

MS Office skills are useful across many entry-level office and administrative roles.

💻

Computer Operator

Computer operation, documentation and office tasks.

⌨️

Data Entry Operator

Data entry, Excel work, verification and records.

📊

MIS Executive

Excel reports, data analysis and MIS preparation.

📁

Office Assistant

Documentation, email, records and office support.

🏆

Career Optics Computer Academy Course Certificate

After successful completion of the required training, practical assignments and assessment, students can receive a Career Optics Computer Academy course completion certificate.

✓ Practical Assessment ✓ Final Project ✓ Skill Evaluation ✓ Course Certificate

Need Help?

Our team is ready to help
📞 7519884465
Call Now