Office 365 Cheat Sheet

Updated 2026-04-21

Office 365 (now primarily branded as Microsoft 365) is Microsoft's cloud-based productivity suite combining familiar desktop applications like Word, Excel, and PowerPoint with cloud services including OneDrive, SharePoint, and Teams. Originally a subscription alternative to perpetual Office licenses, it has evolved into a comprehensive collaboration and AI-powered productivity platform with real-time co-authoring, cloud storage, Copilot AI integration, and cross-device access. The key distinction: while Office 365 focused on productivity applications, Microsoft 365 bundles those apps with advanced security, device management, compliance tools, and increasingly integrated AI capabilities—making it essential to verify which features your specific subscription plan includes, as capabilities vary significantly across Personal, Family, Business, and Enterprise (E3/E5) tiers.

What This Cheat Sheet Covers

This topic spans 22 focused tables and 192 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.

Table 1: Subscription PlansTable 2: Core ApplicationsTable 3: Collaboration FeaturesTable 4: Cloud Storage and File ManagementTable 5: Email and Calendar (Outlook/Exchange)Table 6: Microsoft Teams FeaturesTable 7: Security and ComplianceTable 8: AI and AutomationTable 9: Web and Mobile AppsTable 10: Admin Center and ManagementTable 11: Keyboard Shortcuts (Universal)Table 12: Excel-Specific FeaturesTable 13: Word-Specific FeaturesTable 14: PowerPoint-Specific FeaturesTable 15: Outlook-Specific FeaturesTable 16: SharePoint-Specific FeaturesTable 17: OneDrive-Specific FeaturesTable 18: Licensing and DeploymentTable 19: Advanced Excel FormulasTable 20: Power Platform IntegrationTable 21: Troubleshooting Common IssuesTable 22: New Features and Changes (2026)

Table 1: Subscription Plans

Plan	Example	Description
Microsoft 365 Personal	$6.99/month or$ 69.99/year (rising to $9.99/$ 99.99 in July 2026)	• For one person on up to 5 devices • includes Office apps, 1 TB OneDrive storage, and Outlook email—no advanced security or device management features.
Microsoft 365 Family	$9.99/month or$ 99.99/year (rising to $12.99/$ 129.99 in July 2026)	• For up to six users with 1 TB OneDrive per person • same apps as Personal plan but shareable across household members.
Microsoft 365 Business Basic	$6.00/user/month (rising to$ 7.00 in July 2026)	• Web-based apps only (no desktop versions) • includes Teams, Exchange, OneDrive, and SharePoint—ideal for organizations needing collaboration tools without local installs.
Microsoft 365 Business Standard	$12.50/user/month (rising to$ 14.00 in July 2026)	Everything in Business Basic plus desktop Office apps (Word, Excel, PowerPoint, Outlook) and increased mailbox storage (50 GB rising to 100 GB).
Microsoft 365 Business Premium	$22.00/user/month (rising to$ 25.00 in July 2026)	Business Standard plus advanced security, device management (Intune), and threat protection—best for small to mid-sized businesses requiring cybersecurity controls.

Table 1: Subscription Plans

Plan	Example	Description
Microsoft 365 Personal	$6.99/month or$ 69.99/year (rising to $9.99/$ 99.99 in July 2026)	• For one person on up to 5 devices • includes Office apps, 1 TB OneDrive storage, and Outlook email—no advanced security or device management features.
Microsoft 365 Family	$9.99/month or$ 99.99/year (rising to $12.99/$ 129.99 in July 2026)	• For up to six users with 1 TB OneDrive per person • same apps as Personal plan but shareable across household members.
Microsoft 365 Business Basic	$6.00/user/month (rising to$ 7.00 in July 2026)	• Web-based apps only (no desktop versions) • includes Teams, Exchange, OneDrive, and SharePoint—ideal for organizations needing collaboration tools without local installs.
Microsoft 365 Business Standard	$12.50/user/month (rising to$ 14.00 in July 2026)	Everything in Business Basic plus desktop Office apps (Word, Excel, PowerPoint, Outlook) and increased mailbox storage (50 GB rising to 100 GB).
Microsoft 365 Business Premium	$22.00/user/month (rising to$ 25.00 in July 2026)	Business Standard plus advanced security, device management (Intune), and threat protection—best for small to mid-sized businesses requiring cybersecurity controls.