Office 365 Tutorials

3 Tutorials
Updated 03/22/19

Office 365 is a subscription-based service offer by Microsoft for home and business users. Buying an Office 365 subscription allows you to use Microsoft productivity applications like Microsoft Word, Excel, Outlook, PowerPoint Etc. and depending on the subscription package you choose you can also get enterprise solutions like Microsoft Exchange for email, Teams for collaboration, and SharePoint for document management. One key detail about the Office 365 applications is that they never get outdated as new features and enhancements are applied to the software through incremental updates.

History

The initial public release of Office 365 was June 28th, 2011, and it was more of a change of approach on how to distribute their software than a new product from Microsoft as they already had been offering similar products like Microsoft Online Services before that. This initial release of Office 365 was primarily targeted to enterprise businesses and included Exchange Server for email, SharePoint for document management, Lync for communication, and the Office Web Apps.

In 2013 Microsoft expanded their offering to home users and also made it more accessible to businesses of all sizes. In this release, they refreshed their package to include solutions like OneDrive, Yammer and other data mining tools like Power BI.

Features

Most of the applications bundled in Office 365 are web-based tools accessible from anywhere on the Internet from a web browser, and most of them can be installed as a standalone application in your computer to give you a richer experience. You can install the applications in 5 devices per subscription.

The entire Office 365 ecosystem is managed from a single web-based administration panel where you have complete autonomy on how to provision licenses and managed your subscription user accounts. If you have an enterprise network where you manage your network resources with Active Directory you have the option to run both systems in a hybrid mode so both systems share data between each other.

Even though the Office 365 package is made of many standalone applications that have been around since even before the term cloud was invented, Office 365 is a well cohesive solution where all the applications are well integrated with one another.

Applications

This are the main applications offered by Office 365 and they are available based on the subscription plan you get.

  • Delve is where you customize your office 365 profile and from here you can search for and discover content across Office 365 based on personalized insights.
  • Microsoft Dynamics  Microsoft Dynamics is a group of enterprise resource planning and customer relationship management software applications. Microsoft markets Dynamics applications through a network of reselling partners who provide specialized services.
  • Flow Microsoft Flow allows you to automate workflows across applications. You can use Flow to connect email and IM alerts, synchronize files between applications, copy files from one service to another, collect data from one app and store it in another, and more.
  • Forms Microsoft Forms is a new part of Office 365 Education that allows you to quickly and easily create custom quizzes, surveys, questionnaires, registrations, and more.
  • One Drive for Business Let you sync your files and share them with your colleagues or external parties.
  • OneNote Let you take notes and share those notes with multiple people.
  • Planner  Allows you to create new plans, organize and assign tasks, share files, chat about what you’re working on, and get updates on progress
  • SharePoint Allows users to create sites for every project team, department, and division. Share files, data, news, and resources. You can quickly customize team sites or create a hub website like an Intranet.
  • Sway  allows users who have a Microsoft account to combine text and media to create a presentable website.
  • Stream is a video service that uses the power of intelligent enterprise video to enable knowledge sharing, easier communication, and connectivity in a secure enterprise environment
  • Teams is a unified communications platform that combines persistent workplace chat, video meetings, file storage, and application integration.
  • Yammer is an enterprise social networking service used for private communication within organizations
  • Power BI It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards
  • PowerApps It allows you to create Mobile Apps to run on Android and iOS.
  • MyAnalytics is an application designed to help employees and their managers gain insight into how workers spend their time, with the goal of optimizing tasks and making them more efficient
  • Microsoft Office Suite This includes all the desktop applications people use every day like Word, Excel, PowerPoint, Outlook, Publisher, Access some of them are available online for easy access and collaboration.

Subscription Plans Available

Enterprise Plans

PackageProPlusE1E3E5
Price$12/mo$8/mo$20/mo$36/mo
Core Apps IncludedWord
Excel
PowerPoint
Outlook
Publisher
Access
NoneWord
Excel
PowerPoint
Outlook
Publisher
Access
Word
Excel
PowerPoint
Outlook
Publisher
Access
Services IncludedOneDriveExchange
OneDrive
SharePoint
Teams
Yammer
Stream
Exchange
OneDrive
SharePoint
Teams
Yammer
Stream
Exchange
OneDrive
SharePoint
Teams
Yammer
Stream
Power BI Pro

Small Business Plans

PackageBusinessBusiness PremiumBusiness Essentials
Price$8.25/mo$12.50/mo$5/mo
Core Apps IncludedWord
Excel
PowerPoint
Outlook
Access
Word
Excel
PowerPoint
Outlook
Access
Online version of Office Only
Services IncludedOneDriveExchange
OneDrive
SharePoint
Teams
Exchange
OneDrive
SharePoint
Teams

Home Plans

PackageHomePersonalHome & Student
Price$99.99/yrs$69.99/yrsOne-time fee: $149.99
Core Apps IncludedWord
Excel
PowerPoint
Outlook
Publisher
Access
Word
Excel
PowerPoint
Outlook
Publisher
Access
Word
Excel
PowerPoint
Services IncludedOneDrive
Skype
OneDrive
Skype
None

Plans For Large Non-Profits

PackageE1E3E5
PriceFree$4.50/mo$15/mo
Core Apps IncludedNoneWord
Excel
PowerPoint
Outlook
Publisher
Access
Word
Excel
PowerPoint
Outlook
Publisher
Access
Services IncludedExchange
OneDrive
SharePoint
Teams
Yammer
Stream
Exchange
OneDrive
SharePoint
Teams
Yammer
Stream
Exchange
OneDrive
SharePoint
Teams
Yammer
Stream
Power BI Pro

Below you will find many tutorials on how to use and configure your Office 365 applications.


Connecting to Exchange Online Using PowerShell

If you have recently or are planning to move your On-premise Exchange server to Office 365 Exchange Online one of the first things you will probably need to do is connect to Exchange Online using PowerShell. There are so many administrative tasks that cannot be done through the browser online console and need to be done through PowerShell. In this…


How to Connect To Office 365 through PowerShell

When you start administering Office 365 the need to connect to your tenant through PowerShell will come up. And for a beginner, it might be a bit confusing connecting to Office 365 through PowerShell for the first time. I couldn’t find an easy to follow tutorial when I did it, so I wrote this one to save you some time.…


Get a Report Of All Licensed Users In Office 365

One of the things you need to do once you migrate your on-premise exchange server to Office 365 is to keep an eye on the licenses assigned to accounts. Even though you can see the licenses assigned to individual accounts from the Office 365 admin panel, in this post I will show you how to get a generate a quick…