Microsoft 365 tutorials
Format a report, check a formula or prepare a presentation. Choose a lesson and try the example in your own file.
68 lessons · Examples and exercises · No sign-up needed
Illustration, not an official screenshot
Navigation
Q3 Office Move Plan
TitleTimeline
Heading 1Week 1 – Packing
Heading 2Week 2 – Move day
Heading 2Word workflow
From a first draft to a report you can share.
What you’ll learn
Clean a list, write a useful formula and turn the results into a report.
What you’ll learn
Plan the story, build readable slides and rehearse your delivery.
What you’ll learn
Each lesson starts with a task and tells you which version of the app you'll need.
Learning goal
Use SUMIFS to add up sales that match one condition, then add a second.
Find the menu, select the cells or text, and see what should happen next.
Practise with a memo, a sales table or a project update. The examples use sample data.
Try a small change yourself, then compare the total, document layout or slide output.
Exercise
Total West sales of at least 1500.
Expected result
3300
Run through this before a document leaves your team.
Use this before you build totals, charts or PivotTables.
Check this the day before you present.
Copilot is optional. Whether Copilot appears in Word, Excel or PowerPoint depends on your Microsoft account, plan and, at work, your organization's license and settings. Every lesson works without it.
Use when: A long draft has no clear structure.
Review the structure of this document. Suggest a Heading 1 and Heading 2 outline using the existing content, and point out any section that should be split or merged. Don't rewrite the body text.
Use when: Before a document goes outside your team.
Proofread this document for a client audience. List unclear sentences, inconsistent terms and any placeholder text that still needs to be filled in. Show each issue with its section heading.
Use when: You've pasted an export and totals look wrong.
Look at this table. Identify rows with inconsistent capitalization, extra spaces or likely duplicates, and suggest the formulas or steps to clean them. Don't delete anything yet.
Use when: You need totals by region, team or month.
Summarize total Sales by Region and Month from this table. Show the result as a PivotTable and point out which region changed the most from the first month to the last.
Use when: You're starting a deck from a blank file.
Draft a six-slide outline for a 10-minute update to leadership about [topic]. Write each slide title as a one-sentence takeaway and list up to three supporting points per slide.
Use when: You need notes you can glance at while presenting.
Write speaker notes for this slide as three short cue lines a presenter can glance at. Keep the facts exactly as they appear on the slide.
How the lessons work, what you need,
and where Copilot fits in.
Choose the app you're using. Start at the beginning or find the lesson that helps with today's task.