Verleger: 16
MrExcel's Holy Macro! Books, Mike Girvin
Unlock the full potential of Microsoft 365 Excel with this extensive guide, crafted for both beginners and seasoned users alike. Begin by uncovering the foundational reasons behind Excel’s creation and its unmatched significance in the business world. Dive deep into the structure of Excel files, worksheets, and key concepts that underscore the application’s versatility. As you progress, master efficient workflows, keyboard shortcuts, and powerful formulas, making Excel an indispensable tool for solving complex problems.Moving forward, the book will guide you through advanced topics, including logical tests, lookup functions, and the latest features like LET and LAMBDA functions. Gain hands-on experience with data analysis, exploring the full capabilities of standard pivot tables, advanced Power Query, and Power BI. Each chapter builds on the last, ensuring that you gain both practical skills and a deep understanding of Excel’s capabilities, preparing you to confidently tackle even the most challenging data tasks.By the end of this guide, you’ll not only be adept at using Excel but also equipped with strategies to apply Excel's advanced features to real-world scenarios—whether you’re interested in financial modeling, big data analysis, or simply enhancing efficiency in your day-to-day tasks.
Gustavo Moraes, Douglas Romao
With its extensive set of tools and features for improving productivity and collaboration, Microsoft 365 is being widely adopted by organizations worldwide. This book will help not only developers but also business people and those working with information to discover tips and tricks for making the most of the apps in the Microsoft 365 suite.The Microsoft 365 Fundamentals Guide is a compendium of best practices and tips to leverage M365 apps for effective collaboration and productivity. You'll find all that you need to work efficiently with the apps in the Microsoft 365 family in this complete, quick-start guide that takes you through the Microsoft 365 apps that you can use for your everyday activities. You'll learn how to boost your personal productivity with Microsoft Delve, MyAnalytics, Outlook, and OneNote. To enhance your communication and collaboration with teams, this book shows you how to make the best use of Microsoft OneDrive, Whiteboard, SharePoint, and Microsoft Teams. You'll also be able to be on top of your tasks and your team's activities, automating routines, forms, and apps with Microsoft Planner, To-Do, Power Automate, Power Apps, and Microsoft Forms.By the end of this book, you'll have understood the purpose of each Microsoft 365 app, when and how to use it, and learned tips and tricks to achieve more with M365.
Aaron Guilmette
This book serves as a comprehensive guide to prepare you for the Microsoft Identity and Services exam, which focuses on the core identity and security aspects of a Microsoft 365 tenant. The exam MS-100 tests your proficiency in Azure AD authentication types, user management roles, access management, and workload applications.This book follows the published MS-100 blueprint, which covers identity and identity synchronization concepts, administrative roles, and crucial security topics such as self-service password reset, Azure AD password protection, and multifactor authentication. You’ll gain insights into application and authentication concepts, including OAuth application request management, enterprise application configuration, the benefits of Azure AD Application Proxy, and deploying Microsoft 365 apps.The book also delves into passwordless sign-in methods and provides overviews of configuring Exchange Online, Microsoft Teams, SharePoint Online, and OneDrive for Business in both cloud-only and hybrid deployments. You’ll be able to assess your knowledge retention at the end of each chapter.By the end of this MS-100 study guide, you’ll have built the knowledge and skills to pass the MS-100 exam and be able to ensure thorough preparation with the help of practice exam questions.
Nate Chamberlain
Exam MS-101: Microsoft 365 Mobility and Security is a part of the Microsoft 365 Certified: Enterprise Administrator Expert certification path designed to help users validate their skills in evaluating, planning, migrating, deploying, and managing Microsoft 365 services. This book will help you implement modern device services, apply Microsoft 365 security and threat management, and manage Microsoft 365 governance and compliance. Written in a succinct way, you’ll explore chapter-wise self-assessment questions, exam tips, and mock exams with answers.You’ll start by implementing mobile device management (MDM) and handling device compliance. You’ll delve into threat detection and management, learning how to manage security reports and configure Microsoft 365 alerts. Later, you’ll discover data loss prevention (DLP) tools to protect data as well as tools for configuring audit logs and policies. The book will also guide you through using Azure Information Protection (AIP) for deploying clients, applying policies, and configuring services and users to enhance data security. Finally, you’ll cover best practices for configuring settings across your tenant to ensure compliance and security.By the end of this book, you’ll have learned to work with Microsoft 365 services and covered the concepts and techniques you need to know to pass the MS-101 exam.
Peter Rising
The Microsoft 365 Security Administration (MS-500) exam is designed to measure your ability to perform technical tasks such as managing, implementing, and monitoring security and compliance solutions for Microsoft 365 environments.This book starts by showing you how to configure and administer identity and access within Microsoft 365. You will learn about hybrid identity, authentication methods, and conditional access policies with Microsoft Intune. Next, the book shows you how RBAC and Azure AD Identity Protection can be used to help you detect risks and secure information in your organization. You will also explore concepts, such as Advanced Threat Protection, Windows Defender ATP, and Threat Intelligence. As you progress, you will learn about additional tools and techniques to configure and manage Microsoft 365, including Azure Information Protection, Data Loss Prevention, and Cloud App Discovery and Security. The book also ensures you are well prepared to take the exam by giving you the opportunity to work through a mock paper, topic summaries, illustrations that briefly review key points, and real-world scenarios.By the end of this Microsoft 365 book, you will be able to apply your skills in the real world, while also being well prepared to achieve Microsoft certification.
Sasha Kranjac, Omar Kudovic
In today's hostile cyber landscape, securing data and complying with regulations is paramount for individuals, businesses, and organizations alike. Learn how Microsoft 365 Security and Compliance offers powerful tools to protect sensitive data and defend against evolving cyber threats with this comprehensive guide for administrators.Starting with an introduction to Microsoft 365 plans and essential compliance and security features, this book delves into the role of Azure Active Directory in Microsoft 365, laying the groundwork for a robust security framework. You’ll then advance to exploring the complete range of Microsoft 365 Defender security products, their coverage, and unique protection services to combat evolving threats.From threat mitigation strategies to governance and compliance best practices, you’ll gain invaluable insights into classifying and protecting data while mastering crucial data lifecycle capabilities in Microsoft 365.By the end of this book, you’ll be able to elevate the security and compliance posture of your organization significantly.
Peter Rising
The Microsoft 365 Security, Compliance, and Identity Administration is designed to help you manage, implement, and monitor security and compliance solutions for Microsoft 365 environments.With this book, you’ll first configure, administer identity and access within Microsoft 365. You’ll learn about hybrid identity, authentication methods, and conditional access policies with Microsoft Intune. Next, you’ll discover how RBAC and Azure AD Identity Protection can be used to detect risks and secure information in your organization. You’ll also explore concepts such as Microsoft Defender for endpoint and identity, along with threat intelligence. As you progress, you’ll uncover additional tools and techniques to configure and manage Microsoft 365, including Azure Information Protection, Data Loss Prevention (DLP), and Microsoft Defender for Cloud Apps.By the end of this book, you’ll be well-equipped to manage and implement security measures within your Microsoft 365 suite successfully.
Heather Ackmann, Bill Kulterman, Ramit Arora
If you’re proud of yourself for finally learning how to use keyboard shortcuts and the search function, but still skip a beat when asked to generate a table of contents, then this book is for you. Written by two experts who’ve been teaching the world about Word for decades, Microsoft 365 Word Tips and Tricks is a powerhouse of demystifying advice that will take you from Word user to Word master.This book takes you on a step-by-step journey through Word essentials with plenty of practical examples. With it, you'll explore different versions of Microsoft Word, its full functionality, and understand how these versions impact collaboration with others. Each chapter focuses on a different aspect of working with the legendary text editor, including a whole chapter dedicated to concentrating better with the help of Word. Expert advice will fill your knowledge gaps and teach you how to work more productively and efficiently with text, images, styles, and even macros.By the end of this book, you will be able to make better documents faster and troubleshoot any Word-related problem that comes your way. And because of its clear and cohesive structure, you can easily come back to refresh your knowledge whenever you need it.