Best Microsoft Certification Guides Books

A list of the Microsoft Certification Study Guides currently available or planned.

1. Exam Ref AZ-900 Microsoft Azure Fundamentals

Author: by Jim Cheshire
Microsoft Press
English
350 pages

View on Amazon

Prepare for Microsoft Exam AZ-900Demonstrate your real-world knowledge of cloud services and how they can be provided with Microsoft Azure, including high-level concepts that apply throughout Azure, and key concepts specific to individual services. Designed for professionals in non-technical or technical roles, the Exam Ref series focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Fundamentals level.

Focus on the expertise measured by these objectives: Describe cloud concepts Describe core Azure services Describe core solutions and management tools on Azure Describe general security and network security features Describe identity, governance, privacy, and compliance features Describe Azure cost management and Service Level Agreements This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you want to show foundational knowledge of cloud services and their delivery with Microsoft Azure; no technical background or IT experience is required About the Exam Exam AZ-900 focuses on knowledge needed to describe cloud service benefits and usage considerations; explain IaaS, PaaS, and SaaS; compare public, private, and hybrid cloud models; describe core Azure architectural components, products, solutions, and management tools; describe how network connectivity is secured in Azure; describe core identity services; describe Azure security tools, features, governance methodologies, and monitoring and reporting options; describe privacy, compliance, and data protection standards; describe Azure subscriptions, cost planning, and cost management; and describe SLAs and the service lifecycle.


2. Excel 2021: A Step-By-Step Guide to Learning the Basics of Excel and Easy Excel Tips for Beginners

Author: by Albion Jensen
B09774CD2K
English
230 pages

View on Amazon

Do you have little or no experience with Microsoft Excel? Are you looking for a way to make charts, tables, graphs, and formulas? Do you need to increase your marketability in the increasingly competitive job market? Keep reading if the response is yes!

Stop struggling with Excel formulas that are not working! It’s time to start working smarter, not harder. If you like learning by doing and if you’re looking to maximize your efficiency and supercharge your productivity using Excel this is the book for you.

You will:Start Entering, Editing, & Managing Data in the simplest way. Learn how to speed up your work with Excel spreadsheets. Discover the 5 proven Time-Saving Excel data insertion methods. Understand the 7 most common Excel Formulas for better workflow. Know the cause of the 6 most common Excel errors and the solution to get rid of them.

Learn the top 5 Excel charts and graphs to present your work. Become able to use Excel for data analysis. Learn how to prepare your work for printing. Impress employees and coworkers with Excel skillsHave a first look at the highlights of Excel 2021.


3. Microsoft Azure Architect Technologies and Design Complete Study Guide: Exams AZ-303 and AZ-304

Author: by Benjamin Perkins
Sybex
English
768 pages

View on Amazon

Become a proficient Microsoft Azure solutions architect Azure certifications are critical to the millions of IT professionals Microsoft has certified as MCSE and MCSA in Windows Server in the last 20 years. All of these professionals need to certify in key Azure exams to stay current and advance in their careers.

Exams AZ-303 and AZ-304 are the key solutions architect exams that experienced Windows professionals will find most useful at the intermediate and advanced points of their careers. Microsoft Azure Architect Technologies and Design Complete Study Guide Exams AZ-303 and AZ-304 covers the two critical Microsoft Azure exams that intermediate and advanced Microsoft IT professionals will need to show proficiency as their organizations move to the Azure cloud.

Understand Azure Set up your Microsoft Cloud network Solve real-world problems Get the confidence to pass the exam By learning all of these things plus using the Study Guide review questions and practice exams, the reader will be ready to take the exam and perform the job with confidence.


4. Office 2019 All-in-One For Dummies

Author: by Peter Weverka
For Dummies
English
816 pages

View on Amazon

One book that does the work of nine Knowing your way around Microsoft Office requires you to be part mathematician, part storyteller, and part graphic designerwith some scheduling wizard and database architect sprinkled in. So what do you do if these talents don’t come naturally to you?Fear not!

Office 2019 All-in-One For Dummies fills in the gaps and helps you create easy-to-read Word documents, smash numbers in Excel, tell your tale with PowerPoint, and keep it all organized with Outlook. With additional books covering Access, OneNote, and common Office tasks, this is the only Office book you need on your shelf.

Get insight into tools common to all Office applications Find full coverage of Word, Excel, PowerPoint, Outlook, and Access Benefit from updated information based on the newest software release Discover the tricks Office pros use to enhance efficiency If you need to make sense of Office 2019 and don’t have time to waste, this is the all-in-one reference you’ll want to keep close by!


5. Exam Ref DA-100 Analyzing Data with Microsoft Power BI

Author: by Daniil Maslyuk
Microsoft Press
English
288 pages

View on Amazon

Prepare for Microsoft Exam DA-100 and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced data analytics professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Associate level.

Focus on the expertise measured by these objectives: Prepare the data Model the data Visualize the data Analyze the data Deploy and maintain deliverables This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you are an experienced business intelligence professional or data analyst, or have a similar role Analyzing Data with Microsoft Power BI About the Exam Exam DA-100 focuses on skills and knowledge needed to acquire, profile, clean, transform, and load data; design and develop data models; create measures with DAX; optimize model performance; create reports and dashboards; enrich reports for usability; enhance reports to expose insights; perform advanced analysis; manage datasets, and create and manage workspaces.


6. Exam Ref AZ-500 Microsoft Azure Security Technologies

Author: by Yuri Diogenes
Microsoft Press
English
410 pages

View on Amazon

Prepare for Microsoft Exam AZ-500: Demonstrate your real-world knowledge of Microsoft Azure security, including tools and techniques for protecting identity, access, platforms, data, and applications, and for effectively managing security operations. Designed for professionals with Azure security experience, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified: Azure Security Engineer Associate level.

Focus on the expertise measured by these objectives: Manage identity and access Implement platform protection Manage security operations Secure data and applications This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have expertise implementing security controls and threat protection, managing identity and access, and protecting assets in cloud and hybrid environments About the Exam Exam AZ-500 focuses on the knowledge needed to manage Azure Active Directory identities; configure secure access with Azure AD; manage application access and access control; implement advanced network security; configure advanced security for compute; monitor security with Azure Monitor, Azure Firewall manager, Azure Security Center, Azure Defender, and Azure Sentinel; configure security policies; configure security for storage and databases; and configure and manage Key Vault.


7. Exam Ref MD-100 Windows 10

Author: by Andrew Bettany
Microsoft Press
English
400 pages

View on Amazon

Prepare for Microsoft Exam MD-100: Windows 10and help demonstrate your real-world mastery of skills and knowledge required to deploy, configure, secure, manage, and monitor Windows devices and client applications. Designed for Windows administrators, Exam Ref MD-100: Windows 10 focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Associate level.

Focus on the expertise measured by these objectives: Deploy Windows Manage devices and data Configure connectivity Maintain Windows This Microsoft Exam Ref MD-100: Windows 10: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have some experience administering Windows 10 and non-Windows devices and technologies About the Exam Exam MD-100: Windows 10 focuses on knowledge needed to deploy Windows; perform post-installation configuration; manage local users, local groups, and devices; configure data access and protection; configure devices with local policies; manage Windows security; configure networking; configure remote connectivity; configure system and data recovery; manage updates; and monitor and manage Windows.


8. Excel 2021: Learn How You Can Use Excel as a Powerful Tool to Solve Problems and to Organize Your Work and Personal Life. Get the Skills You Need to Succeed in Today's Job Market

Author: by Nigel Tillery
B098BNDH82
June 29, 2021
English

View on Amazon

Have you always wanted to learn how to use Excel, but you’re busy at work and have other responsibilities that make it difficult for you to take a class or read a book on Microsoft Excel? Do you want to prove your worth to your boss?

Or do you want a new job with a higher salary? What skill is critical to acquire these days to succeed in the working world? Whether your goal is a job promotion, career advancement, or just getting ahead in today’s competitive job market, there’s no better way than mastering Excel.

The skills learned will help anyone become more productive at work while also increasing their salary! You don’t need any experience with spreadsheets before reading this book. This guide is the perfect introduction for anyone who has never used Excel before.

Don’t be afraid of the future and the next generation. Take advantage of the information in this book and combine it with your own experience to defeat the youth and get a better job and a higher salary! Let young people keep playing video games while you achieve your professional goals!


9. Exam Ref AZ-204 Developing Solutions for Microsoft Azure

Author: by Santiago Munoz
Microsoft Press
English
400 pages

View on Amazon

Prepare for Microsoft Exam AZ-204and help demonstrate your real-world mastery of Microsoft Azure solution development. Designed for working Azure developers, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Solutions Associate level.

Focus on the expertise measured by these objectives: Develop Azure compute solutions Develop for Azure storage Implement Azure security Monitor, troubleshoot, and optimize Azure solutions Connect to and consume Azure services and third-party services This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you want to show your ability to design and build diverse Microsoft Azure cloud solutions, and successfully participate in all phases of their development About the Exam Exam AZ-204 focuses on knowledge needed to implement IaaS solutions; create Azure App Service Web Apps; implement Azure Functions; develop solutions using Cosmos DB and Blob Storage; implement user authentication, authorization, and secure cloud solutions; integrate caching and content delivery within solutions; instrument solutions to support monitoring and logging; develop an App Service Logic App; implement API Management; develop event- and message-based solutions.

10. MCA Modern Desktop Administrator Complete Study Guide: Exam MD-100 and Exam MD-101

Author: by William Panek
Sybex
English
832 pages

View on Amazon

The ultimate study guide for Microsoft 365 Certified Associate (MCA) Modern Desktop certificationcovers the new Exam MD-100 and the new Exam MD-101 in one book! Referred to as the Modern Desktop, Microsoft 365 is Microsoft’s new suite of modern workplace services comprising Windows 10, Office 365, and Enterprise Mobility & Security.

IT administrators tasked with deploying and implementing Modern Desktop are required to configure, secure, manage, and monitor devices and applications in enterprise environments. Success on the MCA Modern Desktop Administrator certification exam is essential for IT professionals seeking to expand their job opportunities and advance their careers.

The MCA Modern Desktop Administrator Complete Study Guide is an indispensable resource for candidates preparing for certification. This guide covers 100% of all exam objectives for the new Exam MD-100: Windows 10 and the new Exam-101: Managing Modern Desktops. All aspects of both new exams are covered, including in-depth information on advanced topics and technologies.

11. Exam Ref AZ-303 Microsoft Azure Architect Technologies

Author: by Mike Pfeiffer
Microsoft Press
English
320 pages

View on Amazon

Prepare for Microsoft Exam AZ-303and help demonstrate your real-world mastery of architecting high-value Microsoft Azure solutions for your organization or customers. Designed for modern IT professionals, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Expert level.

Focus on the expertise measured by these objectives: Implement and monitor an Azure infrastructure Implement management and security solutions Implement solutions for apps Implement and manage data platforms This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you are an IT professional who wants to demonstrate your ability to design modern Microsoft Azure solutions involving compute, network, storage, and security About the Exam Exam AZ-303 focuses on knowledge needed to implement cloud infrastructure monitoring, storage accounts, and VMs (Windows and Linux); automate resource deployment and configuration; implement virtual networking and Azure Active Directory; implement and manage hybrid identities; manage Azure workloads; implement Azure Site Recovery; implement application infrastructure; manage application security; implement load balancing and network security; integrate Azure virtual networks with on-premises networks; implement and manage Azure governance solutions; manage Role-Based Access Control; implement application infrastructure and container-based apps; implement NoSQL and Azure SQL databases; and implement Azure SQL database managed instances.

12. MOS Study Guide for Microsoft Excel Exam MO-200

Author: by Joan Lambert
Microsoft Press
English
192 pages

View on Amazon

Advance your everyday proficiency with Excel! And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Worksheets and Workbooks Manage Data Cells and Ranges Manage Tables and Table Data Perform Operations by Using Formulas and Functions Manage Charts About MOS A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards.

Hands-on experience with the technology is required to successfully pass Microsoft Certification exams.

13. Managing Microsoft Teams: MS-700 Exam Guide: Configure and manage Microsoft Teams workloads and achieve Microsoft 365 certification with ease

Author: by Peter Rising
English
452 pages
1801071004

View on Amazon

Discover how to plan a Microsoft Teams deployment within a business environment and manage Teams administrative functions on a day-to-day basisKey FeaturesPlan and design your Microsoft Teams deploymentPrepare, deploy, and manage policies for Microsoft Teams and for apps within TeamsPass the MS-700 exam and achieve certification with the help of self-assessment questions and a mock examBook DescriptionDo you want to build and test your proficiency in the deployment, management, and monitoring of Microsoft Teams features within the Microsoft 365 platform?

Managing Microsoft Teams: MS-700 Exam Guide will help you to effectively plan and implement Microsoft Teams using the Microsoft 365 Teams admin center and Windows PowerShell. You’ll also discover best practices for rolling out and managing MS services for Teams users within your Microsoft 365 tenant.

The chapters are divided into three easy-to-follow parts: planning and design, feature policies and administration, and team management, while aligning with the official MS-700 exam objectives to help you prepare effectively for the exam. The book starts by taking you through planning and design, where you’ll learn how to plan migrations, make assessments for network readiness, and plan and implement governance tasks such as configuring guest access and monitoring usage.

14. Microsoft Certified Azure Fundamentals Study Guide

Author: by James Boyce
Sybex
English
256 pages

View on Amazon

Quickly preps technical and non-technical readers to pass the Microsoft AZ-900 certification exam Microsoft Certified Azure Fundamentals Study Guide: Exam AZ-900 is your complete resource for preparing for the AZ-900 exam. Microsoft Azure is a major component of Microsoft’s cloud computing model, enabling organizations to host their applications and related services in Microsoft’s data centers, eliminating the need for those organizations to purchase and manage their own computer hardware.

In addition, serverless computing enables organizations to quickly and easily deploy data services without the need for servers, operating systems, and supporting systems. This book is targeted at anyone who is seeking AZ-900 certification or simply wants to understand the fundamentals of Microsoft Azure.

Whatever your role in business or education, you will benefit from an understanding of Microsoft Azure fundamentals. Readers will also get one year of FREE access to Sybex’s superior online interactive learning environment and test bank, including hundreds of questions, a practice exam, electronic flashcards, and a glossary of key terms.

15. NuWave Oven Cookbook For Beginners: Healthy and Delicious NuWave Oven Recipes that Friends and Loved Ones Will Be Begging You to Serve! (NuWave Cookbook)

Author: by Frankie Nicholson
English
99 pages
1720566798

View on Amazon

This is a collection of healthy and tasty recipes that you can quickly prepare with your NuWave Oven recipes cookbook! The NuWave Oven is a multi-purpose kitchen appliance that sits on your countertop, offering three styles of heatconvection, infrared, and conduction.

This unique NuWave Oven Cookbook results in saving a whole lot of time and energy while at the same time trims extra fats and calories from your foods. No need to worry about preheating your foods with your NuWave Oven, nor will you have to defrost foods before placing them in the oven.

With the use of the NuWave Oven, you can prepare many different food items:Red meatPoultryVegetablesSeafoodAnd a whole lot moreImagine your NuWave oven will not only re-heat food, but it will breathe new life into it. Picture re-heating some refrigerated fried chicken breast leftovers.

The extra fat drips away, leaving you with a beautiful piece of fat-free, crispy chicken to enjoy.