| 1 |
Computer & Office Fundamentals |
- Computer basics & office workflow
- File & folder management
- Digital productivity mindset
- AI overview for office work
- Workspace setup assignment
|
1 |
3 |
4 |
- Understand digital office environment
- Organize files professionally
- Identify automation areas
|
| 2 |
Microsoft Word – Professional Documentation |
- Advanced formatting & styles
- Headers, footers, tables
- Mail merge basics
- AI drafting tools
- Business letter template
|
1 |
6 |
7 |
- Create professional documents
- Automate documentation
- Use AI for drafting
|
| 3 |
Word Automation & Smart Writing |
- Templates & reusable blocks
- AI summarization
- SOP drafting
- Tone optimization
- AI-assisted SOP creation
|
1 |
6 |
7 |
- Generate consistent documents
- Improve writing clarity
- Build reusable systems
|
| 4 |
Excel Fundamentals for Office Work |
- Excel interface & design
- Basic formulas
- Sorting & filtering
- Charts & formatting
- 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
- Sales dashboard
|
1 |
7 |
8 |
- Create dashboards
- Analyze datasets
- Apply reporting techniques
|
| 6 |
Excel + AI Automation |
- AI-generated formulas
- Data cleaning with AI
- Auto insights
- AI reporting
- MIS report generation
|
1 |
7 |
8 |
- Speed up analytics
- Automate reports
- Reduce manual work
|
| 7 |
PowerPoint for Business Communication |
- Slide design
- Visual storytelling
- Charts & layouts
- AI slide tools
- Business presentation
|
1 |
6 |
7 |
- Create presentations
- Visualize insights
- Use AI tools
|
| 8 |
Internet, Email & Digital Communication |
- Email etiquette
- Calendar management
- Cloud storage
- AI email drafting
|
0 |
5 |
5 |
- Communicate professionally
- Use AI for emails
|
| 9 |
Google Workspace Collaboration |
- Docs, Sheets, Slides
- Sharing & permissions
- Real-time editing
- AI features
|
0 |
5 |
5 |
- Work in cloud
- Collaborate effectively
|
| 10 |
Office Automation Concepts |
- Automation workflows
- Macro basics
- No-code tools
- Zapier, Make
|
0 |
5 |
5 |
- Identify automation
- Build workflows
|
| 11 |
AI Tools for Office Productivity |
- ChatGPT for reports
- Claude for documents
- Perplexity research
- Gemini analysis
|
0 |
5 |
5 |
- Choose right AI tools
- Improve productivity
|
| 12 |
Reporting & MIS Automation |
- KPI tracking
- Monthly reports
- AI insights
- Automated formatting
|
0 |
5 |
5 |
- Create MIS reports
- Automate reporting
|
| 13 |
Data Management & Documentation |
- File naming
- Version control
- Documentation standards
- AI summarization
|
0 |
5 |
5 |
- Organize data
- Maintain documentation
|
| 14 |
Industry Use Cases & Workflows |
- HR automation
- Sales reporting
- Operations tracking
- AI workflow redesign
|
0 |
5 |
5 |
- Apply automation in real cases
- 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 |
- |
