| 1 |
Computer & Office Fundamentals |
- Computer basics and office workflow
- File and folder management
- Digital productivity mindset
- AI overview for office work
- Assignment: Workspace & folder setup
|
1 |
3 |
4 |
- Understand modern digital office
- Organize files professionally
- Identify automation areas
|
| 2 |
Microsoft Word – Professional Documentation |
- Advanced formatting & styles
- Headers, footers, tables, layouts
- Mail merge basics
- AI drafting (ChatGPT / Gemini)
- Assignment: Business letter template
|
1 |
6 |
7 |
- Create professional documents
- Automate documentation
- Use AI for drafting & editing
|
| 3 |
Word Automation & Smart Writing |
- Templates & reusable blocks
- AI summarization & rewriting
- SOP & policy drafting
- Tone optimization
- Assignment: AI SOP document
|
1 |
6 |
7 |
- Generate documents quickly
- Improve writing clarity
- Build reusable systems
|
| 4 |
Excel Fundamentals for Office Work |
- Excel interface & workbook design
- Basic formulas & references
- Sorting, filtering, charts
- Formatting best practices
- Assignment: Performance tracker
|
1 |
7 |
8 |
- Create structured spreadsheets
- Apply formulas
- Build reports
|
| 5 |
Advanced Excel for Industry |
- IF/IFS formulas
- XLOOKUP, INDEX-MATCH
- Pivot tables
- Conditional formatting
- Assignment: Sales dashboard
|
1 |
7 |
8 |
- Create dashboards
- Analyze datasets
- Apply reporting techniques
|
| 6 |
Excel + AI Automation |
- AI-generated formulas
- Data cleaning with AI
- Insight generation
- AI narrative reporting
- Assignment: AI MIS report
|
1 |
7 |
8 |
- Speed up analytics
- Automate reporting
- Reduce manual effort
|
| 7 |
PowerPoint for Business Communication |
- Slide design fundamentals
- Visual storytelling
- Charts & layouts
- AI slide tools (Gamma, Canva AI)
- Assignment: Business presentation
|
1 |
6 |
7 |
- Create presentation decks
- Communicate visually
- Use AI tools
|
| 8 |
Internet, Email & Digital Communication |
- Email etiquette
- Calendar management
- Cloud storage basics
- AI email drafting
- Assignment: Email workflow
|
0 |
5 |
5 |
- Communicate professionally
- Use AI in communication
|
| 9 |
Google Workspace Collaboration |
- Docs, Sheets, Slides
- Sharing & permissions
- Real-time editing
- AI features
- Assignment: Team document
|
0 |
5 |
5 |
- Work in cloud
- Collaborate effectively
|
| 10 |
Office Automation Concepts |
- Automation workflows
- Macro basics
- No-code tools
- Zapier, Make.com
- Assignment: Automate task
|
0 |
5 |
5 |
- Identify automation opportunities
- Design workflows
|
| 11 |
AI Tools for Office Productivity |
- ChatGPT for reports
- Claude for documents
- Perplexity for research
- Gemini for analysis
- Assignment: AI report
|
0 |
5 |
5 |
- Select right AI tools
- Improve productivity
|
| 12 |
Reporting & MIS Automation |
- KPI tracking
- Monthly reporting
- AI insights
- Automated formatting
- Assignment: KPI system
|
0 |
5 |
5 |
- Create MIS reports
- Automate reporting cycles
|
| 13 |
Data Management & Documentation |
- File naming & version control
- Documentation standards
- Knowledge organization
- AI summarization
- Assignment: Documentation system
|
0 |
5 |
5 |
- Organize enterprise data
- Maintain consistency
|
| 14 |
Industry Use Cases & Workflows |
- HR automation
- Sales/admin workflows
- Operations tracking
- AI workflow redesign
- Assignment: Workflow improvement
|
0 |
5 |
5 |
- Apply automation in real scenarios
- Improve efficiency
|
| 15 |
Capstone Projects |
- Excel MIS dashboard
- AI documentation system
- Workflow automation
- Final presentation
|
2 |
4 |
6 |
- Build end-to-end solutions
- Integrate AI tools
- Present professionally
|
| Total Duration |
9 |
81 |
90 |
- |
