This course is for learners who have basic computer knowledge and want to professionally use Microsoft Office (Word, Excel, PowerPoint). It also covers internet skills and modern AI tools to help you work faster and smarter.
Module 1: Course Introduction & Setup
- Overview of Microsoft Office (Word, Excel, PowerPoint) and what each is used for
- Opening and closing Office apps
- Understanding the Ribbon, Tabs, and Quick Access Toolbar
- Saving files, file formats (.docx, .xlsx, .pptx), and Save As
- Using OneDrive/cloud storage to save and access files anywhere
Part A — Microsoft Word
Module 2: Word Basics
- Creating a new document and understanding the workspace
- Typing, selecting, and editing text
- Formatting text: font, size, color, bold, italic, underline
- Paragraph alignment, line spacing, bullet points, and numbering
Module 3: Word — Intermediate Skills
- Inserting tables, images, and shapes
- Using Headers, Footers, and Page Numbers
- Spelling and grammar check
- Using Find & Replace
- Creating simple letters, resumes, and reports (practical exercise)
Module 4: Word — Practical Document Tasks
- Page setup, margins, and page orientation
- Printing documents (Print Preview and settings)
- Sharing documents (email, cloud link)
- Basic use of built-in AI writing help (rewrite, summarize) in Word
Part B — Microsoft Excel
Module 5: Excel Basics
- Understanding rows, columns, and cells
- Entering and editing data
- Basic formatting: borders, colors, cell size, number formats
- Saving and naming a workbook
Module 6: Excel Formulas & Functions
- Basic formulas: addition, subtraction, multiplication, division
- Common functions: SUM, AVERAGE, MAX, MIN, COUNT
- Using cell references (relative vs. absolute)
- Simple IF function for basic conditions
Module 7: Excel — Organizing & Analyzing Data
- Sorting and filtering data
- Creating and formatting tables
- Freezing rows/columns for easier viewing
- Basic charts and graphs (bar, pie, line)
Module 8: Excel — Practical Tasks
- Creating a simple budget or expense sheet
- Creating a basic attendance or grade sheet
- Removing duplicate data and cleaning data
- Printing and sharing Excel sheets
Module 9: Excel AI — Working Smarter with AI Tools
- Introduction to AI tools that work with Excel (Microsoft Copilot, Claude, ChatGPT, etc.)
- How AI can help: writing formulas, summarizing data, creating charts, cleaning data
- Writing good prompts for Excel tasks (step-by-step approach)
- Using Copilot in Excel (if available) to ask questions about your data
- Using AI (like Claude) outside Excel to generate formulas, analyze data, or explain results
- Practical exercise: Complete a small data analysis task using AI prompts
Part C — Microsoft PowerPoint
Module 10: PowerPoint Basics
- Understanding slides, layouts, and themes
- Adding and formatting text on slides
- Inserting images, icons, and shapes
- Adding new slides and organizing slide order
Module 11: PowerPoint — Intermediate Skills
- Adding tables and simple charts
- Using transitions and animations (basic, professional use)
- Adding speaker notes
- Using Designer/AI suggestions for slide layouts (if available)
Module 12: PowerPoint — Practical Presentation Tasks
- Creating a simple presentation from start to finish (practical exercise)
- Presenting slides (Slide Show mode, timing, navigation)
- Exporting presentation as PDF
- Tips for clear and effective presentations
Part D — Internet, Email & AI
Module 13: Internet Surfing & Search Engines
- What is the internet? Introduction to browsers (Chrome, Edge, etc.)
- Navigating websites: address bar, tabs, bookmarks, downloads
- Using search engines effectively (Google Search techniques)
- Evaluating reliable vs. unreliable information online
- Online safety: passwords, phishing awareness, safe browsing
Module 14: Email Basics
- Creating and setting up an email account
- Understanding Inbox, Sent, Spam, and Trash
- Composing, sending, replying, and forwarding emails
- Adding attachments (including Word/Excel/PowerPoint files)
- Email etiquette and identifying scam emails
Module 15: Using AI Tools for Everyday & Office Productivity
- What is AI and how it can help with daily/office tasks
- Introduction to common AI tools (Claude, ChatGPT, Copilot)
- Writing clear prompts for different tasks: drafting an email or letter, summarizing a long document, getting quick answers or research help
- Combining AI with Office: using AI to draft content, then polishing it in Word/Excel/PowerPoint
- Being cautious: checking AI answers for accuracy before using them
Module 16: Final Project & Course Wrap-Up
- Practical project: Create a short report in Word, a data sheet with a chart in Excel, and a presentation in PowerPoint — using AI assistance where helpful
- Recap of key skills across Word, Excel, PowerPoint, Internet, and AI
- Q&A session
- Course completion certificate / assessment (optional)