Sample chapters

403 Items Sort by date|Sort by title

Overview of Windows PowerShell 5.0

  • By Ed WilsonNov 2, 2015
  • This chapter from "Windows PowerShell Step by Step, 3rd Edition" covers the basic use and capabilities of Windows PowerShell, how to install Windows PowerShell, how to use basic command-line utilities inside Windows PowerShell and access Windows PowerShell help, and run and get help on basic Windows PowerShell cmdlets.

How to Change the Appearance of a Workbook in Microsoft Excel 2016

  • By Curtis FryeOct 16, 2015
  • This chapter from Microsoft Excel 2016 Step by Step guides you through procedures related to changing the appearance of data, applying existing formats to data, making numbers easier to read, changing data’s appearance based on its value, and adding images to worksheets.

How to Combine Data from Multiple Sources in Microsoft Excel 2016

  • By Curtis FryeOct 16, 2015
  • This chapter from Microsoft Excel 2016 Step by Step guides you through procedures related to using a workbook as a template for other workbooks, linking to data in other workbooks, and consolidating multiple sets of data into a single workbook.

Provision SharePoint Online Site Collections

  • By Orin ThomasSep 5, 2015
  • Understanding how to configure and manage SharePoint Online site collections is critical for an Office 365 administrator. This chapter from Exam Ref 70-347 Enabling Office 365 Services covers how to configure external user sharing, create SharePoint site collection, and plan a collaboration solution.

Provisioning Office 365

  • By Orin ThomasJun 30, 2015
  • In this chapter from Exam Ref 70-346 Managing Office 365 Identities and Requirements, learn the basic process of setting up an Office 365 tenancy. To master this objective you’ll need to understand some of the prerequisites, such as what you’ll need to think about before signing up for an Office 365 subscription, what an Office 365 tenant name is, what the different administrator roles are, and what to manage regarding tenant subscriptions and licensing.

Create and Manage Users and Groups in Active Directory


Deploy Your First Active Directory Forest and Domain


Get Started with Office 365

  • By Blain BartonJun 24, 2015
  • Office 365, one of the public cloud-based services offered by Microsoft, is a software as a service (SaaS) suite that includes not only the personal computer versions of Office, but also mobile versions and the server services needed to connect them. If you’re ready to learn more about Office 365, this chapter from Microsoft Public Cloud Services: Setting up your business in the cloud will give you a great overview.

Design Microsoft Azure Infrastructure and Networking


Managing User Profiles in Microsoft SharePoint Online for Office 365

  • By Bill EnglishJun 23, 2015
  • In this chapter from Microsoft SharePoint Online for Office 365: Administering and configuring for the cloud, Bill English introduces the management of user profiles and discusses the usefulness of these profiles for finding experience and expertise within your organization. He looks at how to create new user profiles and why you might want to create user subtypes to make unique profiles or different profile types in your environment. He also discusses organization profiles and how to set up My Sites.

Microsoft Public Cloud Services: What the Cloud Can Do for Your Business


How to Install, Configure, and Manage the Mailbox Role in Microsoft Exchange Server 2013


Planning and Deploying Session-based Virtual Desktops


Virtualizing Desktops and Apps with Windows Server 2012 R2 Inside Out: Planning and Implementing App-V


Working with Site Data in Node.js


Enabling a Mobile Workforce: Managing BYOD and Company-Owned Devices


Agile Project Management with Kanban: Adapting from Waterfall


Exam Ref 70-695 Deploying Windows Devices and Enterprise Apps (MCSE): Implement a Lite-Touch Deployment


Design and Implement an Azure Storage Strategy



  • By Itzik Ben-Gan, Kevin Farlee, Adam Machanic, Dejan SarkaMar 11, 2015
  • This chapter from T-SQL Querying starts with the logical design aspects of the filters. It then uses a paging scenario to demonstrate their optimization. The chapter also covers the use of TOP with modification statements. Finally, the chapter demonstrates the use of TOP and OFFSET-FETCH in solving practical problems like top N per group and median.

Sign up now

Microsoft Press Store newsletter and special offers