🎓 Advance Professional Computer Office Management (APOM)

🎓 Advance Professional Computer Office Management (APOM)
৪ মাস মেয়াদী অফলাইন প্রফেশনাল কোর্স ( Total Class = 40 )
৪০টি ক্লাস করতে হবে, পরীক্ষার নম্বর = ৭০০

কোর্সের মূল লক্ষ্য:
শিক্ষার্থীদের আধুনিক অফিসে প্রয়োজনীয় Advanced Computer, MS Office, Data Management, Documentation, Communication ও Office Management-এ দক্ষ করে তোলা।

🟦 ১ম মাস — Advanced Computer & Office Fundamentals
Module 01: Advanced Computer Fundamentals
Computer Hardware & Software
Operating System-এর ধারণা
Windows Advanced Features
Control Panel / Settings
User Account Management
Software Installation & Uninstallation
File & Folder Management
File Extension ও File Types
Data Backup & Restore
Basic Computer Troubleshooting
Module 02: Professional Typing
English Typing
বাংলা টাইপিং
Typing Speed Development
অফিসিয়াল ডকুমেন্ট টাইপিং
Keyboard Shortcuts
Formatting Shortcuts
টাইপিং Accuracy বৃদ্ধি
Module 03: Office Productivity
Printer ব্যবহার
Scanner ব্যবহার
PDF তৈরি ও ব্যবস্থাপনা
PDF Merge / Split
Document Conversion
File Compression
Pen Drive & External Storage
Cloud Storage-এর ব্যবহার
Practical Project

একটি সম্পূর্ণ Digital Office Folder System তৈরি

🟩 ২য় মাস — Advanced MS Word & Professional Documentation
Module 04: MS Word Advanced
Advanced Text Formatting
Styles & Themes
Page Layout
Header & Footer
Section Break
Page Numbering
Table-এর Advanced ব্যবহার
ছবি, Shape ও SmartArt
Text Box
Columns
Watermark
Page Border
Find & Replace
Document Protection
Module 05: Professional Documentation
অফিসিয়াল Letter
Application
Notice
Memo
Office Order
Circular
Meeting Agenda
Meeting Minutes
Project Report
Business Proposal
Quotation
Invoice
Professional CV/Resume
Module 06: Advanced Word Tools
Mail Merge
Labels & Envelopes
Table of Contents
Footnote & Endnote
Hyperlink
Cross-reference
Document Templates
Practical Project

একটি Professional Office Documentation Package তৈরি

🟨 ৩য় মাস — Advanced MS Excel & PowerPoint
Module 07: MS Excel Advanced
Excel Fundamentals Review
Workbook & Worksheet
Data Entry
Formatting
Page Setup
Print Settings
Advanced Formulas & Functions
SUM
AVERAGE
COUNT
COUNTA
MAX / MIN
IF
AND / OR
SUMIF / SUMIFS
COUNTIF / COUNTIFS
IFERROR
VLOOKUP / XLOOKUP
CONCAT / TEXT Functions
Date & Time Functions
Data Management
Sort & Filter
Advanced Filter
Data Validation
Conditional Formatting
Remove Duplicates
Freeze Panes
Named Ranges
Professional Excel Projects
Salary Sheet
Attendance Sheet
Student Result Sheet
Sales Report
Expense Report
Inventory/Stock Management
Monthly Budget
Commission Calculation
Module 08: Excel Reporting & Dashboard
Charts
Pivot Table
Pivot Chart
Data Analysis
Interactive Report
Basic Dashboard
Printing Professional Reports
Practical Project

একটি Professional Excel Office Management System তৈরি

🟥 ৪র্থ মাস — PowerPoint, Database, Internet & Office Management
Module 09: Professional PowerPoint
Professional Presentation Design
Slide Layout
Theme & Template
Text & Image
SmartArt
Tables & Charts
Animation
Transition
Audio/Video ব্যবহার
Presentation-এর Design Principles
Presenter View
Professional Presentation Delivery
Practical

একটি Business/Office Presentation তৈরি ও উপস্থাপন

🟪 Module 10: Database Management
Database কী
Database Structure
Table
Field & Record
Primary Key
Data Entry
Data Types
Query
Form
Report
Basic MS Access
Database Search & Filter
Basic Database Management
Practical Project

Student/Customer/Employee Database তৈরি

🌐 Module 11: Internet, Email & Online Office
Internet
Professional Web Browsing
Effective Google Search
Download & Upload
Online Forms
Online Applications
Cloud Storage
Professional Email
Professional Email Writing
Email Formatting
CC & BCC
Attachment
Reply & Forward
Email Organization
Email Etiquette
Online Office Tools
Google Docs
Google Sheets
Google Drive
Google Forms
Online File Sharing
Collaborative Work
💼 Module 12: Professional Office Management
Office Administration
Digital Document Management
Office Filing System
Record Keeping
Data Management
Meeting Management
Schedule Management
Office Communication
Telephone Etiquette
Customer Service
Teamwork
Time Management
Workplace Etiquette
Confidentiality & Data Security
🎯 Career Preparation
Job Preparation
Professional CV তৈরি
Cover Letter
Job Application
Email-এর মাধ্যমে Job Application
Interview Preparation
Mock Interview
Office Job-এর জন্য প্রয়োজনীয় Skills
Professional Communication
অফিসে কীভাবে কথা বলতে হয়
Senior/Junior-এর সঙ্গে Communication
Client Communication
Telephone Communication
Professional Email Communication
🏆 Final Assessment & Practical Project

কোর্সের শেষে শিক্ষার্থীকে একটি Complete Office Management Project করতে হবে।

Project-এর অংশ:

✅ Professional CV
✅ Official Letter
✅ Office Notice
✅ Meeting Minutes
✅ Mail Merge Document
✅ Salary Sheet
✅ Attendance Sheet
✅ Sales/Expense Report
✅ Excel Dashboard
✅ PowerPoint Presentation
✅ Basic Database
✅ Professional Email
✅ Digital File Management

📅 ৪ মাসের সংক্ষিপ্ত পরিকল্পনা
মাস প্রধান বিষয়
১ম মাস Advanced Computer, Windows, Typing & Office Fundamentals
২য় মাস Advanced MS Word & Professional Documentation
৩য় মাস Advanced MS Excel, Data Analysis & Reporting
৪র্থ মাস PowerPoint, Database, Internet, Email & Office Management
⭐ প্রশিক্ষণের ধরন

Theory + Demonstration + Hands-on Practical + Assignment + Project + Assessment

🎓 কোর্স শেষে শিক্ষার্থী প্রস্তুত হবে

Computer Operator • Office Executive • Data Entry Operator • Office Assistant • Documentation Assistant • Administrative Assistant • Computer Office Management-এর বিভিন্ন কাজের জন্য।

NYTA Skilled Development Training Institute

দক্ষতাই শক্তি