Sample chapters
- By Bill Jelen, Tracy SyrstadMar 11, 2022
A range in Excel can be a cell, a row, a column, or a grouping of any of these. In this sample chapter from Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365), you will explore different ways of referring to ranges, such as specifying a row or column. You’ll also find out how to manipulate cells based on the active cell and how to create a new range from overlapping ranges.
- By Paul McFedriesMar 11, 2022
Despite your best efforts, the odd error might appear in your Excel formulas from time to time. In this sample chapter from Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365), you will learn how to decipher formula error values, diagnose formula problems with Excel’s Formula Error Checker, and use worksheet auditing tools.
Managing and sharing 365 files
- By Joe HabrakenMar 3, 2022
In this sample chapter from Microsoft Office Inside Out (Office 2021 and Microsoft 365), you will look at the file formats used in each of the Microsoft 365 applications and how to share them.
Manage chat, calling, and meetings
- By Ed FisherFeb 12, 2022
In this sample chapter from Exam Ref MS-700 Managing Microsoft Teams, you will explore the administrative tasks and policies associated with managing chat, calling, and meetings in Microsoft Teams.
Describe fundamental principles of machine learning on Azure
- By Julian SharpFeb 1, 2022
Machine learning focuses on identifying and making sense of the patterns and structures in data and using those patterns in software for reasoning and decision making. In this sample chapter from Exam Ref AI-900 Microsoft Azure AI Fundamentals, you will learn how to describe common machine learning types, identify the features and labels in a dataset, select and interpret model evaluation metrics, and more.
- By Curtis Frye, Joan LambertJan 29, 2022
In this sample chapter from Microsoft Excel Step by Step (Office 2021 and Microsoft 365), you will review procedures related to naming data ranges, creating formulas to calculate values, summarizing data in one or more cells, copying and moving formulas, creating array formulas, troubleshooting issues with formula calculations, and configuring automatic and iterative calculation options.
Exam MO-400: Manage messages in Outlook 2019
- By Joan LambertJan 12, 2022
In this sample chapter from MOS Study Guide for Microsoft Outlook Exam MO-400, you will explore ways to add content to outgoing messages and how to organize incoming messages in Outlook 2019.
- By Bill JelenJan 10, 2022
Although pivot tables provide an extremely fast way to summarize data, sometimes the pivot table defaults are not exactly what you need. In this sample chapter from Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365), you will learn how to make common cosmetic or report layout changes, add or remove subtotals, and change summary calculations.
- By Wayne WinstonDec 20, 2021
The INDEX function makes it easy to reference an entire row or column of an array. In this sample chapter from Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition, you will learn how to use the INDEX function to compute the distance between two cities.
Manage user identity and roles
- By Orin ThomasDec 15, 2021
In this sample chapter from Exam Ref MS-100 Microsoft 365 Identity and Services, 2nd Edition, learn how to plan identity synchronization with Azure AD Connect, how to manage that synchronization, how to manage Azure AD identities, and how to manage Azure AD user roles.
Microsoft Identity and Access Management Solutions
- By Nicholas DiCola, Yuri Diogenes, Kevin McKinnerney, Mark MorowczynskiDec 1, 2021
In this sample chapter fromExam Ref SC-900 Microsoft Security, Compliance, and Identity Fundamentals, you will learn how to define the basic identity services and identity types of Azure AD.
- By Andrew Bettany, Andrew WarrenNov 29, 2021
In this sample chapter from Exam Ref MD-101 Managing Modern Desktops, 2nd Edition, you will learn how to use traditional user profile management and how Azure Active Directory enables users to roam their Windows settings from any device, even when working remotely.
Understand Azure data solutions
- By Danilo Dominici, Francesco Milano, Daniel A. SearaOct 11, 2021
In this sample chapter from Microsoft Azure Data Solutions - An Introduction, you will review types of data—structured, semi-structured, and unstructured—and their required type of storage.
- By Andrew Bettany, Andrew WarrenSep 23, 2021
In this sample chapter from Exam Ref MD-100 Windows 10, 2nd Edition, learn how to manage local users, local groups, and devices, configure devices by using local policies, and manage Windows security.
Hypertext Markup Language (HTML)
- By Rob MilesSep 10, 2021
In this sample chapter from Begin to Code with JavaScript, you will explore the HTML standard and learn how to link JavaScript to elements on a web page.
- By Scott Hoag, Harshul Patel, Jonathan Tuliani, Michael WashamSep 2, 2021
In this sample chapter from Exam Ref AZ-104 Microsoft Azure Administrator, you will review how to implement and manage storage with an emphasis on Azure Storage.
- By Ashish Agrawal, Avinash Bhavsar, MJ Parker, Gurvinder SinghAug 6, 2021
The challenge of migrating to a cloud-centered architecture forces us to think of new ways to protect data, resources, and services. In this sample chapter from Exam Ref AZ-304 Microsoft Azure Architect Design, you will learn how to design authentication, authorization, and security for applications.
- By Arvind Chandaka, Ovais Mehboob Ahmed KhanJul 26, 2021
In this sample chapter from Developing Microservices Architecture on Microsoft Azure with Open Source Technologies, you will review the core fundamentals of microservices, including the transition from historical architecture to present, benefits and challenges, and a comparison of a monolithic application architecture with microservices architecture.
Secure Azure Network architectures
- By Nicholas DiCola, Anthony RomanJun 7, 2021
In this sample chapter from Microsoft Azure Network Security, you will review the best practices of general network architecture, various types of network architectures in Azure, and how network security services can be layered to protect these architectures.
Describe how to work with relational data on Azure
- By Francesco Milano, Daniel A. SearaMay 30, 2021
Relational data storage is described as storing information based on a predefined structure of the information. In this sample chapter from Exam Ref DP-900 Microsoft Azure Data Fundamentals, you will learn how to identify the right data offering for a relational workload, describe relational data structures, and more.
Sign up now
Microsoft Press Store newsletter and special offers
Subscribe