Office 365 for IT Pros (2023)

Office 365 for IT Pros (1) recommends Office 365 for IT Pros. Now in its ninth (2023) edition, Office 365 for IT Pros is written by a group of Microsoft MVPs led by Tony Redmond.

Intensely practical and offering the most up-to-date coverage of its topics,Office 365 for IT Pros (2023 edition) is essential reading if you want to maximize your use of Microsoft's Office 365 cloud service. Office 365 for IT Pros (2023 Edition) is the only book covering the management of Office 365 that is constantly refreshed and updated with new information. Until the next edition is published, your subscription allows you to download updated content to keep pace with developments in Office 365, which means that Office 365 for IT Pros continues as a valuable reference for you long after you first read it.

For more information, see Full details of changes made to the book are in our change log at

Tracking Developments Inside Office 365

Originally published on July 1, 2022, Office 365 for IT Pros (2023 edition) is updated monthly to make sure that content stays fresh. Over the last few years, Microsoft has made thousands of changes to Office 365. That’s a lot of information to track. Subscribers receive monthly updates to ensure that they always have the latest information. The writing team made 300 major chapter updates to the 2022 edition over 11 updates, which proves the volume of change across the Microsoft 365 and Office 365 ecosystem.

Written by a team of highly experienced Microsoft Most Valuable Professionals (MVPs), Office 365 for IT Pros (2023 edition) is a practical, hands-on reference, based on experience gained by working in real-life projects with a range of customers since the introduction of Office 365 in June 2011. Because we keep an eye on what Microsoft does inside Office 365, you don't have to worry about making decisions based on outdated material - we do all the work for you.

The Massive Scale of Office 365

Companies are migrating to Office 365 at increasing speed. Office 365 has more than 345 million monthly active users. Microsoft CEO Satya Nadella calls Exchange Online "the gateway drug to the cloud" because email is usually the first workload to move from on-premises servers into the cloud. But as you'll learn in Office 365 for IT Pros, there are plenty of new and exciting advantages to be gained from using the wide breadth of functionality that exists inside Office 365.

(Video) Office 365 Support Administration Basics | New IT Professionals

Office 365 for IT Pros (2023 edition) covers essential business productivity features such as Teams, Microsoft 365 Groups, Stream, Planner, Flow, PowerApps, Exchange Online, SharePoint Online, Yammer, and OneDrive for Business. You'll learn about Office 365 data governance, compliance, and eDiscovery, and how to exploit the Office 365 audit log to understand what's really happening inside a tenant. A chapter on Microsoft Information Protection teaches you how to use Office 365 to protect sensitive messages and documents with rights management and encryption.

Two books are included in this package. You'll get PDF and EPUB versions of the main book and the companion volume. The companion volume covers topics like Delve and MyAnalytics that were in the main book (in previous editions) together with other information that we can’t fit into the main book but still consider interesting and valuable.


Office 365 for IT Pros (2023 edition) includes in-depth instructions (including over 1,000 examples of using PowerShell and the Microsoft Graph) for provisioning, exploiting, and administering the many different services and features that exist within Office 365.

The chapters are:

1. The Microsoft 365 Ecosystem and Office 365: Outlining the role Office 365 plays in the Microsoft 365 ecosystem, how Microsoft’s datacenters and networks serve users, and the commercial success of the service.

2. Embracing the Cloud: Discusses the factors surrounding the movement of work to the Microsoft 365 cloud, the issues that might occur, and how you mitigate any potential problems to ensure a successful deployment.

3. Managing Identities: Without an identity, no one can access or use a Microsoft 365 service. This chapter dives into the role of Azure AD, including hybrid directories, and authentication, exploring topics like conditional access policies.

4. Managing Tenants: Covers the basics of managing an Office 365 tenant within Microsoft 365.

5. Managing Users: A deep dive into how user accounts work within an Office 365 tenant and how to manage them over their lifecycle.

6. Managing Exchange Online: Exchange Online is one of two core workloads within Office 365. This chapter covers details of how to manage Exchange Online and the differences between it and its on-premises counterparts.

(Video) 02 Office 365 for IT Pros

7. Managing Mailflow: Office 365 processes a huge volume of inbound and outbound email. This chapter covers how to manage mail flow, including malware protection and detection.

8. Managing SharePoint Online: SharePoint Online is the second core workload delivering a document management service to Office 365 apps like Teams, Planner, and Yammer. It also encompasses OneDrive for Business, a part of Office 365 that’s seen huge growth recently. This chapter also reviews important components associated with SharePoint, like Search, Syntex, and Viva Topics.

9. Managing Microsoft 365 Tasks: Tasks span anything from personal tasks created with Outlook or To Do to group tasks created in Planner (and maybe even Project). Microsoft 365 treats tasks as a common object type supported by multiple apps, so we dive into the creation and management of tasks in Planner, Outlook, and Teams.

10. Managing Video: Office 365 has long boasted a video portal. Today, Stream is in the middle of a transition from its first implementation (which replaced the original Office 365 video portal) to Stream 2.0 (aka Stream on SharePoint). The earliest sign of Stream 2.0 is how Teams meeting recordings use OneDrive for Business and SharePoint Online to store its MP4 files. All covered here.

11. Managing Groups: Microsoft 365 groups is a core identity and membership service used by apps like Teams, Planner, and Yammer. This chapter reviews how the Groups service works and covers details of other groups used by Office 365, including distribution lists and dynamic groups.

12. Teams Architecture and Structure: Now with more than 270 million monthly active users, Teams is the poster child of Microsoft 365. Teams consumes services drawn from across the Microsoft 365 ecosystem to deliver its mixture of messaging, meetings, voice, video, and app services. This chapter describes the architecture and structure of Teams and the fundamentals of how Teams works.

13. Managing Teams: Nice as it is to have everyone collaborating and connecting in Teams, the app needs to be managed, especially in large deployments. This chapter discusses the essential management tasks needed to keep Teams in good working order.

14. Managing Teams Voice: Many organizations use Teams and the Microsoft Phone system as the foundation for their voice and calling infrastructure. This chapter covers how Teams voice works and how to select, deploy, and manage devices used with Teams.

15. Managing Clients: Looks at the different clients used by Office 365 applications, including Microsoft 365 apps for enterprise, Teams, and mobile clients.

16. Managing Devices with Intune: Microsoft Endpoint Manager and Intune allow organizations to manage devices connected to Office 365. This chapter covers how to approach mobile device management.

(Video) Microsoft Office365 on MacOS! | How Well Does It Work?

17. Managing Compliance: Compliance is a big topic. Office 365 E3 and E5 plans (and various Microsoft 365 licenses) allow tenants to use data governance and classification functionality to manage information created by users. This chapter covers retention policies and labels, and Exchange Online mailbox retention policies.

18. Managing eDiscovery: Once information is under control, it’s nice to be able to find data when you need it. This chapter covers how content searches, core eDiscovery, and advanced eDiscovery works.

19. Managing Data Loss Prevention: Information leakage is a terrible thing. Data Loss Prevention (DLP) policies help users inadvertently share confidential or sensitive information when they shouldn’t. This chapter explains how DLP works in Exchange Online, SharePoint Online, and Teams, and how to build custom sensitive information types for use within Office 365 compliance features.

20. Managing Information Protection: Since 2016, Microsoft has invested heavily in building out an information management framework to allow Office 365 tenants to protect email and documents with rights-management based encryption. We explain how sensitivity labels and Office 365 message encryption work and how to use labels for container management.

21. Managing Reporting and Auditing: In any reasonably-sized tenant, users generate tens of thousands of actions daily, most of which are captured as events in the Office 365 audit log. This chapter discusses how the audit log works and more importantly, how to retrieve and make sense of the audit events found there to answer questions about who did what and when. Microsoft Cloud App Security for Office 365 is also covered along with lots of recommendations about how to generate reports about user activity.

22. Managing Power Platform: The Power Platform is a great way to automate common user and administrative operations. Although designed to work without anyone needing to write any code, Power Automate needs to be understood. We explain how here.

23. Managing Tenants with PowerShell: Much, but not all, of Microsoft 365 can be managed using PowerShell. This chapter reviews the different PowerShell modules used to manage anything from mailboxes to licenses. It also dives into details of the Microsoft Graph API and how to use Graph API calls in PowerShell scripts to achieve even better automation.

24. Sponsor content: Quest Software sponsors Office 365 for IT Pros. As a major independent software vendor (ISV), Quest has many products designed to help Office 365 administrators. We explain some of those products.

It might take you more than 30 hours to read the 660,000+ words in Office 365 for IT Pros (2023 edition), but those hours will save you so much time in deploying and managing that the effort will be well worthwhile. After all, hiring a consultant to explain any of the topics covered in Office 365 for IT Pros will likely cost you twice what we charge for the book, so subscribing is really a great deal!


(Video) How to Reset Your Microsoft 365 Password- IT Pros Management

For more information about Office 365 for IT Pros, visit the Office 365 for IT Pros web site or visit their Facebook page.

(Video) Office 2021 vs Microsoft 365: what's the difference & what's new?


What are the limitations of Office 365? ›

Disadvantages of Office 365
  • Subscriptions aren't for everyone. You don't have to pay out one-time costs, but you do have to pay every month. ...
  • Compatibility issues with bespoke systems. ...
  • Constant updates mean constant changes. ...
  • Most people only use 20% of the functionality. ...
  • You don't actually own the software.

What are the advantages of using 365 Office? ›

Office 365 allows your organisation to store all the files in the cloud. This means they can be accessed on any device, from any location with an internet connection. For organisations where mobile working is essential, being able to access all the apps and files you need when out of the office is invaluable.

What is Microsoft 365 and benefits of using it? ›

Microsoft 365 combines the power of cloud computing with a full suite of mobile apps, making it easier for employees to stay productive while traveling, on site or working remotely. Microsoft 365 apps focus on individual applications (Word, Excel, Teams, etc.) and are free for small mobile devices.

What is the best IT skill? ›

Essential IT skills
  1. Security. Security should be foundational to any IT team. ...
  2. Programming. Being able to program will be a must for those who want to develop software, web applications, and websites. ...
  3. Systems and networks. ...
  4. Data analysis. ...
  5. DevOps. ...
  6. Cloud computing. ...
  7. Machine learning.
Dec 13, 2022

What are the hottest IT skills? ›

Top 10 In-Demand IT Skills To Boost Your Career in 2023
  • AI and Machine Learning.
  • Cyber Security.
  • Data Analysis.
  • Cloud Computing.
  • Blockchain Technology.
  • Mobile App Development.
  • Information Security.
  • IT Operations and Governance.

How do I say I am proficient in Microsoft Office? ›

Here is a template you can use for listing your own Microsoft Office skills:
  1. Proficient in [insert Microsoft skills]
  2. Advanced experience with [insert Microsoft skills]
  3. Basic knowledge of [insert Microsoft skills]
Feb 4, 2020

What are the two main features of Microsoft 365? ›

With a subscription to Microsoft 365, you can get: The latest productivity apps, such as Microsoft Teams, Word, Excel, PowerPoint, Outlook, OneDrive, and so much more. The ability to install on PCs, Macs, tablets, and phones. 1 TB of OneDrive cloud storage.

What is the main benefit of Microsoft 365 information protection? ›

Microsoft Purview Information Protection is a part of Microsoft 365 E5 Compliance Suite. Microsoft offers comprehensive compliance and data governance solutions to help your organization manage risks, protect and govern sensitive data, and respond to regulatory requirements.

What is the purpose of Microsoft 365? ›

Microsoft 365 is the productivity cloud designed to help you pursue your passion and run your business. More than just apps like Word, Excel, PowerPoint, Microsoft 365 brings together best-in-class productivity apps with powerful cloud services, device management, and advanced security in one, connected experience.

What is Office 365 interview questions? ›

Office 365 Interview Questions and Answers
  • What is Office 365? ...
  • Can you explain Microsoft Forms? ...
  • Can I integrate yammer with SharePoint? ...
  • Would love to understand how office365 would allow us to replace dropbox? ...
  • What is Yammer? ...
  • What is the Microsoft Graph? ...
  • What is FastTrack deployment for Office 365?

What is basic IT skills? ›

Basic computer skills courses cover the most common usages of a computer, including a majority or all of the following: understanding the basic notions of computer manipulation; managing computer files, word processing, using spreadsheets and databases; creating presentations; finding information and communicating ...

Which IT skills are in demand in world? ›

Machine Learning (ML) and Artificial Intelligence (AI)

It is predicted that global spending on AI technology will top $500 billion in 2023, as many businesses look to adopt these technologies, which means an increase in demand for ML and AI experts.

Which IT field is most in demand? ›

Here are some of the highest paying IT jobs in 2023:
  • Big Data Engineer.
  • Software Architect.
  • Blockchain Engineer.
  • DevOps Engineer.
  • Cloud Architect.
  • Full-Stack Developer.
  • Artificial Intelligence (AI) Engineer.
  • Product Manager.
5 days ago

Which is the easiest field in IT industry? ›

Here are 18 tech jobs that are easy to get into:
  • Digital strategist.
  • Digital project manager.
  • Computer programmer.
  • Cybersecurity analyst.
  • Application developer.
  • Network engineer.
  • UX designer.
  • DevOps engineer.
Jan 22, 2021

What is the toughest job in IT industry? ›

What is the most difficult job in IT? According to the 812 IT leaders who responded to the 2021 State of the CIO survey, the most challenging IT jobs to fill are those involving cybersecurity (21%), AI/machine learning (20%), data science/analytics (19%) and DevOps/DevSecOps/agile (12%).

Which IT technology is most in demand in 2022? ›

Here is the list of the most in-demand and trending tech skills that will offer you a successful career:
  • Data Science.
  • Cloud Computing.
  • Artificial Intelligence.
  • DevOps.
  • Blockchain.
  • RPA (Robotic Process Automation)
  • Augmented Reality (AR) and Virtual Reality (VR)
  • Cybersecurity.
Jan 23, 2023

How would you describe your Microsoft Office skills in an interview? ›

Example Answer

I'm proficient with Microsoft Office, including Word, Excel, and PowerPoint. I'm very comfortable using these programs and have a lot of experience doing so.

How do you describe computer proficiency skills? ›

You can describe your level of specific computer skills in the following ways: Use descriptive words: basic, intermediate, advanced, or proficient, similarly to language levels in resumes.

What are the basics of Office 365? ›

Microsoft 365 Business Basic
  • Host email with a 50 GB mailbox and custom email domain address.
  • Create a hub for teamwork to connect people using Microsoft Teams.
  • Use Microsoft 365 apps for the web, including Outlook, Word, Excel, PowerPoint, and OneNote.
  • Store and share files with 1 TB of OneDrive cloud storage per user.

What are the 5 functions of Microsoft Office? ›

It contains a word processor (Word), a spreadsheet program (Excel) and a presentation program (PowerPoint), an email client (Outlook), a database management system (Access), and a desktop publishing app (Publisher).

What are the most important Microsoft Office 365 applications? ›

Apps and services
  • Microsoft Teams.
  • Word.
  • Excel.
  • PowerPoint.
  • Outlook.
  • OneNote.
  • OneDrive.

What are the four pillars of Office 365? ›

365 Defender: An Overview of the 4 Pillars of Microsoft's...
  • Stops attacks before they happen, reducing attack surface.
  • Detects and automates across domains, integrating threat data for fast and complete responses.
  • Hunts across all data, leveraging time saved to apply each business's unique expertise.
Feb 4, 2022

What are the three core components of 365? ›

Specifically, Microsoft Office 365 is composed of Microsoft Exchange Online, Microsoft SharePoint Online, and Microsoft Lync Online.

Which feature is unique to Windows 365? ›

Microsoft 365 Apps for enterprise includes exclusive intelligent capabilities like Ideas in Excel, Researcher in Word, real-time collaboration, Teams as the hub for teamwork, and advanced security features. As a user-based license, you can deploy Office on up to five PCs or Macs, five tablets, and five mobile devices.

What's the difference between Microsoft 365 and Office 365? ›

What is the difference between Office 365 and Microsoft 365? Microsoft 365 includes everything you know in Office 365. Microsoft 365 is designed to help people and businesses achieve more with innovative Office apps, intelligent cloud services, and world-class security.

What are the most important Microsoft Office skills? ›

From my experience and research (LinkedIn, Indeed, etc.), here are the most desired skills for each of the Microsoft Office applications.
  • Excel. Analyze Tables. Charts & Sparklines. ...
  • Word. Compare and Merge documents. ...
  • Outlook. Auto Reply. ...
  • PowerPoint. Broadcast and Share a Slideshow. ...
  • Access. Create & Design Databases.

How do I pass a Microsoft interview? ›

Top interview tips for getting hired at Microsoft
  1. First you should apply. The best place to start is here. ...
  2. Do your due diligence. ...
  3. Know where you want to go. ...
  4. Work well with others. ...
  5. Showcase the qualities we're looking for. ...
  6. Demonstrate your thinking. ...
  7. Be yourself. ...
  8. See the landscape.

What are the 4 types of Microsoft Office? ›

Choose your Office
  • Microsoft 365 Family. From $99.99 per year.
  • Microsoft 365 Personal. From $69.99 per year.
  • Office Home & Business 2021. $249.99.
  • Office Home & Student 2021. $149.99.
  • Project Professional 2021. $1,129.99.

What should be the IT skills in resume? ›

Hard Skills and Computer Skills for an IT Resume
  • Computer Hardware Knowledge.
  • Computer Software Knowledge.
  • Internet Applications.
  • Networks.
  • Operating Systems.
  • Troubleshooting.
  • Internet Security.
  • Data Privacy.

What are your IT skill? ›

What Are IT Skills? IT skills (also known as information technology skills) are technical skills necessary to work within technical support, maintenance, and development. IT skills are a rather wide skill set that range from hardware installment and software development to troubleshooting and data analysis.

What skills do you need for Microsoft Office? ›

Best Office Skills for 2022
  • MS Excel.
  • MS Word.
  • MS Access.
  • MS PowerPoint.
  • Written Communication.
  • Organizational Skills.
May 19, 2022

What are the core IT skills? ›

IT careers 2021: 7 hot technology and core skills
  • 7 IT career skills that matter now. ...
  • Database and data pipeline automation expertise. ...
  • DevOps dexterity. ...
  • Popular programming languages. ...
  • AI and MLOps skills. ...
  • Governance, risk and compliance skills. ...
  • Cloud and container-related skills. ...
  • Emotional intelligence (EQ)
Jan 18, 2021

Is Excel an IT skill? ›

Excel is an important, in-demand skill in countless industries. Advanced Excel skills include the ability to produce graphs and tables, use spreadsheets efficiently, and perform calculations and automation to process large volumes of data.

How can I improve my IT knowledge? ›

How to improve IT skills
  1. Develop your current skill set. If you already have some IT skills, it's usually a good idea to keep working on developing them. ...
  2. Continue your education. ...
  3. Assume more responsibility at work. ...
  4. Find a mentor to guide you.
Feb 25, 2020

Which skill is required for a IT job? ›

IT Job Description

An IT professional should be good with computer systems, programming, artificial intelligence, and machine learning, among other things. In addition, an excellent IT professional should be equipped with the skills and knowledge to tackle various IT-related roadblocks.


1. 02 - Office 365 Fundamentals - Office 365 for IT Pros
(RG Edu)
2. GoDaddy Office 365 vs. Microsoft Office 365: Pros and Cons
3. Office 365 for IT Pros interview with Tony Redmond
(Practical 365)
4. Microsoft 365 Fundamentals Certification (MS-900) — Full Course Pass the Exam!
5. Office 365 ProPlus Deployment for IT Pros - 07 Office and App V
(IT Refresher Courses)
6. 🤷‍♂️ What is Microsoft 365 - Explained
(Kevin Stratvert)
Top Articles
Latest Posts
Article information

Author: Rueben Jacobs

Last Updated: 10/03/2022

Views: 5888

Rating: 4.7 / 5 (57 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Rueben Jacobs

Birthday: 1999-03-14

Address: 951 Caterina Walk, Schambergerside, CA 67667-0896

Phone: +6881806848632

Job: Internal Education Planner

Hobby: Candle making, Cabaret, Poi, Gambling, Rock climbing, Wood carving, Computer programming

Introduction: My name is Rueben Jacobs, I am a cooperative, beautiful, kind, comfortable, glamorous, open, magnificent person who loves writing and wants to share my knowledge and understanding with you.