Sample chapters
Manage workbook options and settings
- By Paul McFedriesFeb 1, 2017
In this sample chapter from MOS 2016 Study Guide for Microsoft Excel Expert, learn how to use worksheet protection features to prevent changes to a single cell or entire workbook in Microsoft Excel 2016.
- By Joan LambertJan 30, 2017
In this sample chapter from MOS 2016 Study Guide for Microsoft Outlook, learn more about exam objectives related to managing calendars, calendar items, tasks, and notes.
Apply transitions and animations
- By Joan LambertJan 9, 2017
In this sample chapter from MOS 2016 Study Guide for Microsoft PowerPoint, author Joan Lambert explains how to configure slide transitions and animate slide content in PowerPoint 2016.
Background to T-SQL querying and programming
- By Itzik Ben-GanOct 7, 2016
Learning the theory behind T-SQL querying and programming is an important step in developing code. In this sample chapter from T-SQL Fundamentals, 3rd Edition, Itzik Ben-Gan provides a brief theoretical background about SQL, set theory and predicate logic, the relational model, and types of database systems.
- By Yuri Diogenes, Debra Shinder, Tom ShinderOct 4, 2016
Azure networking has a lot of moving parts. This chapter from Microsoft Azure Security discusses components from a security perspective, best practices, and some patterns that you might want to adopt for your own deployments.
- By Rob MilesOct 4, 2016
If you can organize a party, you can write a program. What happens in a program is a little different, but the basic principles are the same. In this sample chapter from Begin to Code with C#, Rob Miles discusses what it takes to be a programmer and takes a closer look at how computers process data.
Azure Active Directory application model
- By Vittorio BertocciJan 22, 2016
- This chapter from Modern Authentication with Azure Active Directory for Web Applications takes a closer look at how Azure AD represents applications and their relationships to other apps, users, and organizations.
The OWIN OpenID Connect Middleware
- By Vittorio BertocciJan 22, 2016
- This chapter from Modern Authentication with Azure Active Directory for Web Applications will reveal the various layers of the object model for you, showing how you can fine-tune the authentication process to meet your needs.
Working with Functions in Windows PowerShell
- By Ed WilsonNov 11, 2015
- There are clear-cut guidelines that can be used to design functions. These guidelines can be used to ensure that functions are easy to understand, easy to maintain, and easy to troubleshoot. This chapter from Windows PowerShell Step by Step, 3rd Edition examines the reasons for the scripting guidelines and provides examples of both good and bad code design.
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.
Working with Site Data in Node.js
- By David GaynesApr 1, 2015
- In this chapter from Node.js for .NET Developers, David Gaynes explains how to work with data from URLs, data from users, and data from external sources in node.js.
Agile Project Management with Kanban: Adapting from Waterfall
- By Eric BrechnerMar 16, 2015
- This chapter from Agile Project Management with Kanban will help you adapt your variation of traditional Waterfall to Kanban without much fuss or hassle.
T-SQL Querying: TOP and OFFSET-FETCH
- 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.
Administering Windows Server 2012 R2: Monitoring and Auditing
- By Orin ThomasJun 2, 2014
- In this chapter from Training Guide: Administering Windows Server 2012 R2, you will learn how to monitor and configure auditing for computers running the Windows Server 2012 and Windows Server 2012 R2 operating system.
Managing Group Policy Application and Infrastructure in Windows Server 2012 R2
- By Orin ThomasJun 2, 2014
- In this chapter from Training Guide: Administering Windows Server 2012 R2, you’ll learn how to back up, restore, import, and export GPOs. You’ll learn how to delegate the process of editing and applying GPOs, and how to resolve configuration problems related to the application of Group Policy.
Developing Requirements for Enhancement and Replacement Projects
- By Karl Wiegers, Joy BeattyAug 15, 2013
- This chapter from Software Requirements, 3rd Edition provides specific suggestions as to which practices are most relevant for enhancement and replacement projects and how to use them.
Using SharePoint 2013 with Excel and Access
- By Olga Londer, Penelope CoventryAug 15, 2013
- This chapter from Microsoft SharePoint 2013 Step by Step focuses on the integration of SharePoint 2013 with Microsoft Office Excel 2013 and Microsoft Office Access 2013.
The Managed Heap and Garbage Collection in the CLR
- By Jeffrey RichterNov 15, 2012
- Jeffrey Richter explains how the garbage collector in the common language runtime (CLR) works and various performance issues related to it in this chapter from CLR via C#, 4th Edition.
Sign up now
Microsoft Press Store newsletter and special offers
Subscribe