MS Office & AI Essentials — Training Plan & Syllabus

00

Welcome — and Who This Course Is For

This program was designed on one promise: you do not need to know anything about computers to start here, and you will leave able to do real work. Every lesson assumes you might be opening these programs for the very first time — and every lesson ends with you doing something a workplace would actually pay for.

🎓

Job-Market Newcomers

Youth and first-time job seekers who need provable, practical computer skills for interviews and entry-level roles.

🏡

Homemakers & Side-Business Owners

Learners managing households or small ventures who want to budget, organize, and present like a pro.

🗂️

Admins & Secretaries

Office support staff looking to streamline daily tasks — scheduling, correspondence, and reporting — and look sharp doing it.

🌱

Lifelong Learners

Anyone investing in personal and professional growth, at any age or starting point.

A Note From Your Trainer Think of this course the way you'd think of learning to drive. Nobody expects you to merge onto the highway on day one — you start in an empty parking lot. That's exactly how we'll treat Word, Excel, PowerPoint, Outlook, and AI tools: small, safe, confidence-building steps first, real "highway driving" by the end. There's no such thing as a silly question here.

01

Program at a Glance

Four weeks, five days a week, structured to build momentum — each module hands you skills the next module immediately puts to use.

4

Weeks Total

2.5–3

Hours / Training Day

5

Core Software Modules

5

Hands-On Portfolio Projects

Module 1 — MS Word

Module 2 — MS Excel

Module 3 — MS PowerPoint

Module 4 — MS Outlook

Module 5 — AI Essentials

Why This Order? We start with Word because nearly every other skill in this course produces a document, email, or report eventually — Word gives you the "muscle memory" for formatting and editing that makes everything after it easier. Excel comes next because numbers and budgets are immediately useful (and a little intimidating, so we tackle it while motivation is highest). PowerPoint and Outlook build on both. AI Essentials comes last on purpose — by Week 4 you'll have real documents, spreadsheets, and emails of your own to practice AI prompts on, instead of imaginary examples.

02

What You'll Be Able to Do

By graduation day, you will be able to:

Create, format, and proofread a professional Word document from a blank page, including styles, headers, and templates.
Run a mail merge to send personalized letters or labels to a list of contacts.
Build an Excel spreadsheet that calculates totals, averages, and conditional results automatically.
Look up and pull data across spreadsheets using VLOOKUP and XLOOKUP.
Sort, filter, and visualize data with simple, readable charts.
Design a clean, professional PowerPoint presentation — and deliver it with confidence.
Use transitions and animations to support a message, not distract from it.
Manage a professional inbox: folders, rules, flags, and a calendar that doesn't run you.
Schedule meetings and manage shared calendars and task lists in Outlook.
Understand, at a plain-English level, what an AI / LLM tool actually is and isn't.
Write clear, effective AI prompts for summarizing, drafting, and brainstorming everyday work tasks.
Combine all five skill sets into one polished, job-ready portfolio.

03

Week-by-Week Schedule

Each day below runs 2.5–3 hours, blending short demonstrations with hands-on practice time — because the goal is doing, not just watching.

Week 1 · Module 1

MS Word — From Blank Page to Polished Document

Goal: leave Week 1 able to create, format, and personalize any document a workplace might ask for.

Day	Focus & Topics	Duration
Day 1	Getting Oriented in Word The Word screen tour, the Ribbon and tabs, saving & naming files, opening templates, typing and navigating text — for absolute beginners.	3 hrs
Day 2	Formatting Fundamentals Fonts, sizes, bold/italic/underline, alignment, bullet & numbered lists, spacing, and the golden rule of "select first, then format."	2.5 hrs
Day 3	Styles & Document Structure Using built-in Heading styles, the Navigation Pane, page breaks, headers/footers, and page numbers for long, professional-looking documents.	2.5 hrs
Day 4	Templates, Tables & Mail Merge Working from built-in templates, inserting and formatting tables, and the full mail merge workflow (letters, labels, and personalized emails) using an Excel contact list.	3 hrs
Day 5	Project Day — Professional Resume & Memo Build two portfolio pieces from scratch: a one-page resume using styles and a template, and a formatted internal office memo. Peer review and trainer feedback.	2.5 hrs

Week 1 Learning Objectives

Navigate the Word interface confidently without fear of "breaking" anything.
Apply consistent, professional formatting using Styles rather than manual formatting.
Produce a real, usable resume and memo, suitable for actual job applications or office use.
Execute a basic mail merge connecting a Word document to a data source.

Week 2 · Module 2

MS Excel — Numbers, Formulas & Decisions

Goal: leave Week 2 able to build a working spreadsheet that calculates, looks up, and visualizes real data.

Day	Focus & Topics	Duration
Day 6	Getting Oriented in Excel Understanding rows, columns, and cells (the "grid of boxes"); entering and editing data; AutoFill; basic formatting; the difference between text and numbers.	3 hrs
Day 7	Your First Formulas Cell references, SUM, AVERAGE, COUNT, MIN/MAX, and the all-important AutoSum button. Understanding relative vs. absolute references ($).	2.5 hrs
Day 8	Making Decisions With IF Writing IF formulas for everyday logic ("if spending is over budget, flag it"), nested IFs, and combining IF with SUM/COUNT.	2.5 hrs
Day 9	Looking Up Data: VLOOKUP & XLOOKUP Why lookups matter (finding one piece of information in a big list), VLOOKUP step-by-step, and the more modern, flexible XLOOKUP. Sorting and Filtering data ranges.	3 hrs
Day 10	Project Day — Household Budget & Mini Charts Build a complete monthly household budget tracker with automatic totals, an over/under-budget IF flag, and a simple pie or bar chart visualizing spending categories.	2.5 hrs

Week 2 Learning Objectives

Confidently enter, edit, and organize data in a spreadsheet grid.
Write and troubleshoot SUM, AVERAGE, and IF formulas independently.
Use VLOOKUP or XLOOKUP to retrieve matching data from another table.
Sort and filter a data set to answer a specific question.
Build a working personal or household budget with a supporting chart.

Week 3 · Module 3

MS PowerPoint — Presentations That Land

Goal: design and confidently deliver a clean, professional presentation.

Day	Focus & Topics	Duration
Day 11	Slide Design Fundamentals Slide layouts, themes, the "less is more" rule of slide text, working with images and icons, and the Slide Master for consistent branding.	2.5 hrs
Day 12	Transitions, Animations & Polish Adding tasteful slide transitions, entrance/emphasis animations, the Animation Pane, and why restraint beats spectacle in a professional setting.	2.5 hrs
Day 13	Project Day — "Introduce Yourself" Deck + Delivery Coaching Build a 5-slide personal/professional pitch deck (great for interviews or small-business pitches) and practice delivering it with presenter-view notes, pacing, and eye-contact tips.	2.5 hrs

Module 3 Learning Objectives

Design a visually clean slide deck using a consistent theme.
Apply transitions and animations purposefully, not decoratively.
Deliver a short presentation using Presenter View and basic public-speaking technique.

Week 3 · Module 4

MS Outlook — Running Your Day, Not Drowning In It

Goal: take full control of email, scheduling, and daily task management.

Day	Focus & Topics	Duration
Day 14	Inbox Mastery Composing professional emails, attachments, Reply vs. Reply All, folders, flags/categories, and building inbox Rules that file or highlight mail automatically.	2.5 hrs
Day 15	Calendar, Tasks & Project Day Scheduling and responding to meetings, shared calendars, setting reminders, and the Outlook Task list. Project: set up a full inbox organization system (folders + rules) and schedule a mock meeting invite.	3 hrs

Module 4 Learning Objectives

Write clear, professional emails and manage attachments confidently.
Build at least one automated inbox Rule to reduce daily clutter.
Schedule, accept, and manage calendar meetings, including recurring events.
Use Tasks to track to-dos directly inside Outlook.

Week 4 · Module 5

AI Essentials & Prompt Engineering — Your New Work Partner

Goal: understand what AI tools can (and can't) do, and use them productively in daily tasks.

Day	Focus & Topics	Duration
Day 16	What Is AI, Really? Plain-English intro to AI and LLMs (Large Language Models) like Copilot and ChatGPT — what they are, how they "think," their limits (mistakes, made-up facts), and responsible use.	2.5 hrs
Day 17	Prompt Engineering Foundations What makes a "good prompt" — being specific, giving context, giving examples, and the simple CO-STAR framework for everyday requests.	2.5 hrs
Day 18	AI for Everyday Work Tasks Practical prompting for summarizing long documents, drafting and polishing emails, brainstorming ideas, and using Copilot directly inside Word, Excel, and PowerPoint.	3 hrs
Day 19	Project Day — AI-Assisted Workflow Apply AI prompting to real outputs: summarize a long article into a one-paragraph brief, draft a professional email from rough notes, and brainstorm content ideas for a presentation.	2.5 hrs
Day 20	Capstone Day — Portfolio Assembly & Graduation Final assembly and submission of the full Workplace-Ready Portfolio (see below). Individual feedback session and course wrap-up/graduation.	3 hrs

Module 5 Learning Objectives

Explain in plain language what an LLM is and what it is not (a search engine, a human, infallible).
Write clear, well-structured prompts using a repeatable framework.
Use AI tools to summarize, draft, and brainstorm — and critically check the output.
Integrate AI assistance naturally into Word, Excel, and PowerPoint workflows.

Final Deliverable

The Workplace-Ready Portfolio

Every learner graduates with five tangible, real-world artifacts — proof of skill that can be shown to an employer, used in daily life, or built on immediately. This portfolio is the final exam.

Word Professional resume + formatted office memo

Excel Household budget tracker with formulas & chart

PowerPoint 5-slide personal/professional pitch deck

Outlook Organized inbox system + scheduled meeting

AI Essentials AI-assisted summary, email draft & brainstorm log

04

How Learners Are Assessed

This course favors demonstrated ability over written tests — because the goal is real workplace competence, not memorization. Grading is mastery-based: every project gets specific, constructive feedback and a chance to revise.

Component	What's Evaluated	Weight
Daily Practice Exercises	Short, guided tasks completed during each session — checked for completion and understanding, not perfection.	20%
Module Project Days (Word, Excel, PPT, Outlook)	The four hands-on milestone projects — resume/memo, budget tracker, pitch deck, inbox system — assessed against a simple rubric (functionality, formatting, clarity).	40%
AI Prompting Exercises	Quality and clarity of written prompts, and the learner's ability to evaluate and refine AI-generated output critically.	10%
Capstone Portfolio	The complete, polished five-piece portfolio submitted on Day 20 — the comprehensive proof of workplace readiness.	30%

On Grades There are no surprise pop quizzes here, and no trick questions. If you can confidently produce the five portfolio pieces by Day 20, you have proven exactly the skill this course set out to teach. A passing score is 70% overall, with at least a "functional" rating on all five portfolio deliverables.

05

Logistics, Materials & Support

What Learners Need

A computer (Windows or Mac) with Microsoft 365 (Word, Excel, PowerPoint, Outlook) installed or accessible via web browser.
Internet access for AI tool modules (Microsoft Copilot or a free ChatGPT account both work).
No prior software experience, typing speed requirement, or technical background needed.
A notebook or digital note-taking app for jotting down keyboard shortcuts and personal "cheat sheet" notes.

Class Format

Pace: 5 days a week for 4 weeks (20 training days), 2.5–3 hours per day.
Group size: Recommended 8–15 learners per cohort to preserve hands-on support time.
Style: Live instructor-led demonstration (15–20 min) followed by guided practice, paired exercises, and 1:1 trainer circulation.
Recordings: Each session should be recorded for learners to revisit — repetition builds real confidence.

A Final Word Four weeks is a fast pace — be honest with your learners about that on Day 1. Tell them plainly: it's normal to feel behind on Day 3 and confident by Day 10. The structure is designed so every single skill gets reinforced again later in a new context, so nothing taught early is "one and done."

MS Office & AI EssentialsFrom Basics to Workplace Ready