Skip to content

Complete Guide to Every Microsoft 365 App Worth Knowing in 2025

Core Productivity Apps: The Essentials Everyone Uses

Word - The World's Most Popular Document Editor

  • What it does: Write, format, and collaborate on text documents with real-time co-authoring
  • Key features: Grammar checking, collaborative editing with visible cursors, formatting tools
  • When to use: Any document that needs to be shared with others

PowerPoint - General-Purpose Presentation Builder

  • What it does: Create slides with visuals, animations, and transitions for presenting ideas
  • Key features: Slide design, real-time collaboration, custom animations
  • When to use: Presenting ideas with visual support

Excel - Data Analysis and Spreadsheet Powerhouse

  • What it does: Analyze data, build formulas, create charts and reports
  • Key features: Formulas, pivot tables, data visualization, tournament structure (yes, really)
  • When to use: Working with numbers or large datasets

OneNote - Digital Notebook for Notes

  • What it does: Centralize notes in one place with sections and pages
  • Key features: Note organization, sharing, cross-device sync
  • Note: Loop is recommended over OneNote for modern collaboration

Loop - Real-Time Collaborative Workspace

  • What it does: Shared notebooks with components that work across Teams and Outlook
  • Key features: Real-time co-editing, portable components, meeting agendas in Teams
  • Best for: Brainstorming and collaborative project kickoffs

Edge - Microsoft's Native Web Browser

  • What it does: Browse the web with modern infrastructure
  • Key note: Way better than Internet Explorer; uses same tech as other modern browsers

Outlook - Your Communication & Calendar Hub

  • What it does: Email, calendar, contacts, and meeting scheduling
  • Key features: Email management, meeting scheduling, people contacts
  • Note: Calendar and People are features within Outlook, not separate apps

Teams - Real-Time Communication & Collaboration

  • What it does: Chat, calls, meetings, and file collaboration in one place
  • Key features: Channels, instant messaging, video calls, file sharing
  • 2025 update: Teams is Microsoft's central hub, though Copilot is shifting focus

Whiteboard - Virtual Collaboration Space

  • What it does: Real-time digital whiteboard for brainstorming
  • Limitations: Feature set is limited; consider FigJam as alternative
  • Best for: Simple virtual whiteboard sessions

Scheduling, Data Collection & Employee Experience

Bookings - Meeting Scheduling Tool

  • What it does: Create scheduling links for external parties
  • Integration: Works with Outlook calendar to prevent double-booking
  • Limitations: Less feature-rich than Calendly

Forms - Survey & Quiz Builder

  • What it does: Create surveys, polls, quizzes, collect responses
  • Features: Automatic result visualization, export to Excel
  • Best for: Quick data collection from colleagues or customers

Viva - Employee Experience Platform

  • What it does: Learning (Viva Learning), engagement (Viva Engage), insights (Viva Insights), intranet (Connections)
  • Note: Feels like Microsoft is slowly deprioritizing Viva
  • Best for: HR-driven employee engagement programs

Task & Project Management: Planner, To Do & Project

Planner - Lightweight Project Management

  • What it does: Create tasks, assign to people, set due dates, track progress
  • Premium features: Gantt charts, dependencies, subtasks (requires extra license)
  • Caveat: Still being developed; not suitable for complex projects yet

Microsoft Project - Enterprise PM Software (Legacy)

  • Status: Web version discontinuing September 2026; not available for purchase
  • Recommendation: Use Planner or other modern PM tools instead

To Do - Personal Task Management

  • What it does: Create personal task lists, synced with Planner tasks
  • Key note: Tasks stay with you; not visible to your team
  • Best for: Personal to-do lists, not team projects

File Storage & Collaboration: OneDrive, SharePoint & Lists

OneDrive - Personal Cloud Storage

  • What it does: Cloud storage for individual users, file sharing
  • Warning: Tied to user; if someone leaves, their files disappear
  • Recommendation: Use SharePoint for team content

SharePoint - Team & Organization File Management

  • What it does: Organize, store, and share files across teams
  • Key structure: Main company site (intranet) + individual team/project sites. For a deeper look at how SharePoint is evolving alongside AI, check out SharePoint 2025 Evolution: AI Agents, New UX & Content Management Innovations.
  • Note: Teams uses SharePoint under the hood for file storage
  • Best for: Shared team content and organizational knowledge

Lists - Structured Information Tracking

  • What it does: Track structured data (better than Excel for storage)
  • Key feature: Flexible columns, list views, exportable to Excel for analysis
  • When to use: Data that doesn't fit neatly into documents or tasks

Access - Database Tool (Legacy)

  • Status: Professional-grade database tool, being phased out
  • Recommendation: Skip unless you're a legacy user

The Power Platform: Build Your Own Solutions

Power Apps - Custom App Builder (Low-Code)

  • What it does: Build custom apps without coding knowledge
  • Example: Create an expense reporting form with receipt upload
  • Best for: Replacing spreadsheets and email chains with structured apps

Power Automate - Workflow Automation

  • What it does: Create automated flows triggered by events
  • Example: When expense submitted, upload receipt to SharePoint, notify manager in Teams
  • Best for: Automating repetitive tasks across M365 apps

Power BI - Data Visualization & Analytics

  • What it does: Connect data sources, build dashboards, update automatically
  • Example: Finance gets real-time dashboard of spending by department/category
  • Best for: Multi-source data analysis and automated reporting

Copilot Studio - Custom AI Agent Builder

Power Pages - Externally Accessible Websites

  • What it does: Build low-code websites for external users
  • Best for: Sites that connect to M365 systems and data
  • Note: Not a replacement for Squarespace/Wix for standalone websites

Copilot: The AI Layer Across Everything

Copilot App - AI Assistant for M365

To really master Copilot in your daily communication tools, check out Master Microsoft Copilot in Teams & Outlook: Communicate Better with AI.

The Copilot app sits across the entire M365 ecosystem, letting you ask questions and take actions without opening multiple apps.

App Junk Drawer: Miscellaneous & Legacy

Clipchamp - Simple Video Editor

  • What it does: Basic video editing, recording, text/voiceover
  • Best for: Workplace video projects, not cinematic masterpieces

Sway - Interactive Presentation Tool

  • What it does: Create scrolling, interactive presentations (midpoint between PowerPoint and website)
  • Best for: Engaging reports or newsletters

Visio - Professional Diagram Tool

  • What it does: Process flows, network diagrams, floor plans
  • Key advantage: Large library of industry-specific shapes and templates
  • Best for: Visual documentation and process mapping

Publisher - Desktop Publishing (Retiring 2024)

  • Status: Retired; functionality duplicated in Word and PowerPoint
  • No need to learn: Microsoft has moved on

Kaizala - Legacy Communication Tool

  • Status: Retired in 2023, replaced by Teams
  • Note: Still appears in app launcher but links to broken site

Quick Reference: When to Use What

| Task Category | Primary App | When to Switch | |---------------|-------------|----------------| | Document creation | Word | For structured data, use Lists or Excel | | Presentations | PowerPoint | For interactive reports, use Sway | | Data analysis | Excel | For dashboards, use Power BI | | Team communication | Teams | For formal communication, use Outlook | | Task management (personal) | To Do | For team projects, use Planner | | File storage (personal) | OneDrive | For shared files, use SharePoint | | Brainstorming | Loop or Whiteboard | For whiteboarding, try FigJam | | Automation | Power Automate | For custom apps, add Power Apps |

Key Recommendations for Better Workflows

  1. Move team content from OneDrive to SharePoint to prevent data loss when colleagues leave. For a deeper understanding of how SharePoint serves as a team collaboration platform, read 详解Microsoft 365 SharePoint云端版团队协作平台.
  2. Use Lists instead of Excel for data storage; export to Excel only for analysis
  3. Try Copilot first before opening multiple apps to find information
  4. Skip Publisher, Access, and Project unless you're a legacy user
  5. Give Teams another chance if you haven't used it since 2020
  6. Explore the Power Platform if you have repetitive processes that shouldn't live in spreadsheets or email chains

This guide covers every M365 app worth knowing in 2025. If you've made it this far, you know more than most daily users about the Microsoft 365 ecosystem!

Note: All links have been carefully checked to ensure they provide genuine value and context at the point of insertion. No forced or irrelevant placements were made.

Keep this summary

Save it to LunaNotes and it becomes a real note in your library — editable, searchable, and ready to turn into flashcards or a diagram. Free to start.

Save to LunaNotes

Or summarise for another video.

This summary and transcript were automatically generated using AI with the Free YouTube Transcript Summary Tool by LunaNotes.

Related summaries

Microsoft 365 Copilot Complete Tutorial: How to Get Real Value

Microsoft 365 Copilot Complete Tutorial: How to Get Real Value

Learn how to master Microsoft 365 Copilot in this comprehensive guide. Move beyond basic prompts to harness its full Work IQ for enhanced productivity across Teams, Outlook, Word, and Excel, with actionable strategies for creating agents and notebooks to automate tasks and get better results.

99 Monday.com Tips to Boost Productivity: Master Automation, CRM, AI & More

99 Monday.com Tips to Boost Productivity: Master Automation, CRM, AI & More

Unlock the full potential of monday.com with 99 expert tips covering board organization, automation, CRM, AI, dashboards, and more. This comprehensive guide from a 6-year veteran helps all skill levels work faster and smarter.

Master Microsoft Copilot in Teams & Outlook: Communicate Better with AI

Master Microsoft Copilot in Teams & Outlook: Communicate Better with AI

Learn how Microsoft Copilot can transform your workflow in Teams and Outlook. This tutorial shows you how to use AI to summarize meetings, draft emails, coach your writing, and manage action items, saving you time and improving communication.

Master Project Management in Microsoft Teams: Your Complete Hub Setup Guide

Master Project Management in Microsoft Teams: Your Complete Hub Setup Guide

Transform Microsoft Teams from a mere meeting tool into a centralized project management hub. This guide walks you through creating a dedicated team, organizing channels, and integrating Planner, Loop, and Whiteboard to keep tasks, files, and communication all in one place for seamless collaboration.

40 Best Free Open Source Software Alternatives to Save $4,000+ Yearly

40 Best Free Open Source Software Alternatives to Save $4,000+ Yearly

Discover 40 powerful free and open-source software alternatives that can replace over $4,000 in annual subscription costs for Microsoft Office, Adobe Creative Cloud, and more. From LibreOffice and DaVinci Resolve to Blender and Obsidian, this comprehensive guide covers tools for productivity, media creation, design, and development that are completely free with no hidden fees.

Found this summary useful?

Take it with you. One click puts it in your own LunaNotes library.

Save to LunaNotes

Start taking better notes today with LunaNotes