Microsoft Suite Tutorial

Understand Microsoft 365, the apps it includes, and how schools and workplaces in Africa use the suite for learning and productivity.

Create and manage your Microsoft account, sign in safely across devices, and set up multi-factor authentication to protect your work.

Use OneDrive to store files in the cloud, sync across devices, share links, and control who can view or edit your documents.

Organize your digital files with clear names and folder structures so you and your team can find documents quickly.

Navigate Microsoft Word, understand the ribbon and key tools, and create your first professional document from scratch.

Apply professional formatting with fonts, spacing, styles, and built-in templates so documents look consistent and polished.

Add headers, footers, and page numbers to long documents such as reports, theses, and official letters.

Insert and format tables and images in Word, and add alt text so documents are accessible to everyone.

Collaborate on documents with comments and Track Changes so teachers, supervisors, and teammates can review edits clearly.

Learn the Excel workbook layout, how cells, rows, and columns work, and how to enter and format basic data.

Write your first Excel formulas, understand the equals sign, and apply order of operations correctly.

Use essential Excel functions to total, average, count, and make simple logical decisions in your spreadsheets.

Understand relative and absolute cell references so formulas copy correctly across rows and columns.

Create clear charts from spreadsheet data to visualize sales, grades, survey results, and trends.

Convert data ranges to Excel Tables and use filters and sorting to analyze lists quickly.

Navigate PowerPoint, choose slide layouts, and build a structured presentation from a blank deck.

Apply themes, use images effectively, and write speaker notes so your presentation looks professional and delivers well.

Combine Word and Excel skills in a mini project: a one-page report with a supporting data table and chart.

Look up values in large tables to pull prices, grades, or employee details without manual searching.

Summarize thousands of rows into clear reports with pivot tables for sales, attendance, and survey data.

Clean messy spreadsheets with Text to Columns, remove duplicates, trim spaces, and fix common import problems.

Highlight cells automatically by rules, color scales, and data bars to spot trends and exceptions fast.

Add professional animations and slide transitions that support your message without distracting the audience.

Present with confidence using Presenter View, timing, audience engagement, and handling Q&A in African settings.

Manage email overload with folders, focused inbox, search, and habits that keep school and work communication under control.

Schedule meetings, send invites, manage time zones, and use calendar sharing for teams and study groups.

Automate inbox sorting with rules and create professional email signatures for school and work.

Use Microsoft Teams for class and work communication with chats, team channels, and @mentions.

Join and host Teams meetings, share your screen safely, and follow recording etiquette for class and work.

Understand how Teams stores files in SharePoint and OneDrive and collaborate without creating duplicate copies.

Organize lecture notes, meeting minutes, and project research in OneNote notebooks synced across devices.

Build surveys, feedback forms, and simple quizzes with Microsoft Forms and collect responses in Excel.

Share Microsoft 365 files safely with classmates, clients, and partners inside and outside your organization.

Build a class schedule Excel workbook and document a Teams channel plan for a group project.

Navigate SharePoint team sites for document libraries, news, and team home pages beyond simple OneDrive folders.

Collaborate smoothly on Word, Excel, and PowerPoint with multiple editors without conflicts or confusion.

Recover previous versions of Office files and undo accidental edits or deletions using version history.

Manage tasks with Microsoft Planner and To Do, and collaborate on flexible pages with Loop components.

Learn what Power Automate is, when to use it, and walk through one simple flow idea for repetitive Office tasks.

Build a simple Excel dashboard with KPIs, charts, slicers, and clean layout for management or project reporting.

Generate personalized letters, certificates, and labels from one Word template and an Excel recipient list.

Use the Accessibility Checker and inclusive design practices so Office documents work for people with disabilities.

Recognize phishing, manage sharing risks, and understand sensitivity labels for protecting organizational data.

Use a decision framework to pick Word, Excel, PowerPoint, Teams, OneNote, Forms, or SharePoint for each task.

Master high-impact keyboard shortcuts across Word, Excel, PowerPoint, Outlook, and Teams to work faster.

Prepare Excel reports for printing and PDF export with margins, headers, print areas, and fit-to-page settings.

Organize professional contacts and track follow-up tasks in Outlook alongside email and calendar.

Build a complete portfolio pack: Word CV, Excel budget, PowerPoint pitch, and Outlook/Teams workflow documentation.

Self-assess and peer-review Microsoft 365 capstone projects with a structured quality checklist.

Explore MOS and Microsoft 365 certification paths and plan continued learning after this tutorial track.