A comprehensive guide to gaining a 360-degree overview of the VBA programming language and learning how to build your own programs for automating routine tasks Key Features Extend the capabilities of Excel and other Office applications with the help of Microsoft VBA Take your Excel programming skills to the next level by creating custom applications with dialogue boxes and the range object Automate repetitive and monotonous office work with VBA Excel programming Book DescriptionVisual Basic for Applications (VBA) is a programming language developed by Microsoft to automate tasks in MS Office applications. This book will help you to focus on the essential aspects of your role by automating mundane tasks in Excel and other Office applications. With comprehensive coverage of VBA delivered in the form of practice problems and bite-sized recipes, this book will help you to hit the ground running. Unlike most books that assume prior programming experience, this book starts with the fundamentals and gradually progresses to solving bigger problems. You'll start by becoming familiar with VBA so that you can start recording macros right away. With this foundation in place, you'll advance to using the full capabilities of the language as you apply loops, functions, and custom dialog boxes to design your own automation programs. You'll also get to grips with embedded macros and other advanced tools to enhance productivity and explore topics relating to app performance and security. Throughout this VBA book, you'll cover multiple practice projects in Excel, Word, and PowerPoint while exploring tips and best practices to hone your skills. By the end of this book, you'll have developed the skills you need to use VBA to create your own programs that control MS Office applications. What you will learn Understand the VBA programming language's role in the context of the MS Office suite Discover various aspects of VBA programming such as its terminology, syntax, procedures, functions, and forms Investigate the elements, features, and characteristics of the VBA Editor to write and edit custom scripts Automate Excel sheets with the help of ranges Explore error handling and debugging techniques to catch bugs in your programs Create and use custom dialog boxes to collect data from users Customize and extend Office apps such as Excel, PowerPoint, and Word Who this book is forThis book is for experienced Excel users, business analysts, finance professionals, and business users looking to boost their productivity by learning VBA programming to automate repetitive, tedious, or complex tasks. No prior programming experience is required to get started with this book.

Make the most out of your investment in Office 365 apps and services with this Microsoft Office cookbook Key Features Learn how to manage and secure the entire Office 365 stack in addition to specific services Delve into newer and frequently shifting areas such as Power Platform, Microsoft Teams, and Microsoft Search administration Discover carefully selected techniques that cover a range of administrative tasks of varying difficulty levels Book DescriptionOrganizations across the world have switched to Office 365 to boost workplace productivity. However, to maximize investment in Office 365, you need to know how to efficiently administer Office 365 solutions. Microsoft Office 365 Administration Cookbook is packed with recipes to guide you through common and not-so-common administrative tasks throughout Office 365. Whether you're administering a single app such as SharePoint or organization-wide Security & Compliance across Office 365, this cookbook offers a variety of recipes that you'll want to have to hand. The book begins by covering essential setup and administration tasks. You'll learn how to manage permissions for users and user groups along with automating routine admin tasks using PowerShell. You'll then progress through to managing core Office 365 services such as Exchange Online, OneDrive, SharePoint Online, and Azure Active Directory (AD). This book also features recipes that'll help you to manage newer services such as Microsoft Search, Power Platform, and Microsoft Teams. In the final chapters, you'll delve into monitoring, reporting, and securing your Office 365 services. By the end of this book, you'll have learned about managing individual Office 365 services along with monitoring, securing, and optimizing your entire Office 365 deployment efficiently. What you will learn Get to grips with basic Office 365 setup and routine administration tasks Manage Office 365 identities and groups efficiently and securely Harness the capabilities of PowerShell to automate common administrative tasks Configure and manage core Office 365 services such as Exchange Online, SharePoint, and OneDrive Configure and administer fast-evolving services such as Microsoft Search, Power Platform, Microsoft Teams, and Azure AD Get up and running with advanced threat protection features provided by the Microsoft 365 Security & Compliance Center Protect your organization's sensitive data with Office 365 Data Loss Prevention Monitor activities and behaviors across all Office 365 services Who this book is forThis book is for newer Office 365 administrators and IT pros alike, and comes with recipes of varying difficulty levels along with step-by-step guidance. Whether you are new to Office 365 administration or just seeking new ideas, this cookbook contains recipes to enhance your organization's app and service management and productivity.

Publisher's note: This edition is based on MS Office 2019 and does not make use of the most recent features in MS Office 2021. A new second edition, updated for MS Office 2021 including new topics and the latest productivity feature enhancements for Office web and desktop has now been published. Key Features Explore MS Office to enhance productivity and boost your professional development Get up and running with the new and improved features in Microsoft Office 2019 Discover how to overcome common challenges when working with Office 2019 applications Book DescriptionLearn Microsoft Office 2019 provides a comprehensive introduction to the latest versions of Microsoft Word, Excel, PowerPoint, Access, and Outlook. With the help of illustrated explanations, this Microsoft Office book will take you through the updated Office 2019 applications and guide you through implementing them using practical examples. You'll start by exploring the Word 2019 interface and creating professional Word documents using elements such as citations and cover pages, tracking changes, and performing mail merge. You'll then learn how to create impressive PowerPoint presentations and advance to performing calculations and setting up workbooks in Excel 2019, along with discovering its data analysis features. Later chapters will focus on Access 2019, assisting you in everything from organizing a database to constructing advanced queries. You'll then get up to speed with Outlook, covering how to create and manage tasks, as well as how to handle your mail and contacts effortlessly. Finally, you'll find solutions to commonly encountered issues and best practices for streamlining various workplace tasks. By the end of this book, you'll have learned the essentials of Office business apps and be ready to work with them to boost your productivity. What you will learn Use PowerPoint 2019 effectively to create engaging presentations Gain working knowledge of Excel formulas and functions Collaborate using Word 2019 tools, and create and format tables and professional documents Organize emails, calendars, meetings, contacts, and tasks with Outlook 2019 Store information for reference, reporting, and analysis using Access 2019 Discover new functionalities such as Translator, Read Aloud, Scalable Vector Graphics (SVG), and data analysis tools that are useful for working professionals Who this book is forWhether you're just getting started or have used Microsoft Office before and are looking to develop your MS Office skills further, this book will help you to make the most of the different Office applications. Familiarity with the Office 2019 suite will be useful, but not mandatory.

Develop customized business management solutions with the latest features of Microsoft Dynamics 365 Business Central Key Features Learn Dynamics 365 Business Central, the next generation of Dynamics NAV Explore advanced topics for handling complex integrations such as using APIs, OData, and Azure Functions Discover best practices for developing SaaS extensions and moving existing solutions to the cloud Book DescriptionDynamics 365 Business Central is an all-in-one business management solution, which is easy to adopt and helps you make smarter business decisions. This book is a comprehensive guide to developing solutions with Microsoft ERP (in the cloud and also on-premises). It covers all aspects of developing extensions, right from preparing a sandbox environment to deploying a complete solution. The book starts by introducing you to the Dynamics 365 Business Central platform and the new Modern Development Environment. You'll then explore the sandbox concept, and see how to create sandboxes for development. As you advance, you'll be able to build a complete advanced solution for Dynamics 365 Business Central with AL language and Visual Studio Code. You'll then learn how to debug and deploy the extension and write automatic testing. The book will also take you through advanced topics like integration (with Azure Functions, web services, and APIs), DevOps and CI/CD techniques, and machine learning. You'll discover how Dynamics 365 Business Central can be used with Office 365 apps. Finally, you'll analyze different ways to move existing solutions to the new development model based on extensions. By the end of this book, you'll be able to develop highly customized solutions that meet the requirements of modern businesses using Dynamics 365 Business Central. What you will learn Create a sandbox environment with Dynamics 365 Business Central Handle source control management when developing solutions Explore extension testing, debugging, and deployment Create real-world business processes using Business Central and different Azure services Integrate Business Central with external applications Apply DevOps and CI/CD to development projects Move existing solutions to the new extension-based architecture Who this book is forIf you're a new developer looking to get started with Dynamics 365 Business Central, this book is for you. This book will also help experienced professionals enhance their knowledge and understanding of Dynamics 365 Business Central.

Written for students, professionals, and social scientists with little or no knowledge of data visualization principles, this complete guide presents step-by-step instructions for clearly and effectively presenting data using MS Office programs. Throughout the book, the focus is on turning raw, quantitative data into attractive, well-designed charts and tables that tell an accurate narrative about underlying information. Helpful illustrations, expert tips for solving common issues, and discussions on working efficiently are included to equip readers with the tools they need to engage their audience using a visual format.

Become a professional photo editor and bring your ideas to life with Photoshop Elements 2019 Key Features Improve your pictures with easy-to-follow techniques that help you make simple, fast and effective edits Understand how to animate and add multiple layers to your images Master the Photoshop Elements user interface (UI) with real-life examples Book DescriptionAdobe Photoshop Elements is a raster graphics editor for entry-level photographers, image editors, and hobbyists. Though it shares many of Photoshop CC's high-end features, it also boasts a significant number of simple to use, yet highly effective tools not found at the professional level. This book presents the complexities of image editing in easy-to-follow, bite-sized chunks, allowing you to quickly recognize the editing challenge, and helps you to identify the tools and techniques required to make improvements, and to apply those techniques quickly and efficiently. You will start by learning how to import, organize, manage, edit, and use your pictures in a format that's designed for creative photography projects. Going further, you'll discover how to fix a wide range of photographic problems based on the book's extensive repertoire of commonly applied solutions. You'll be escorted through a wide range of common processes that include applying artistic effects to creative projects, custom image makeovers, processing images for social media, and other file export methods. Towards the end of the book, you will understand what the most important tools and features actually do in Photoshop Elements, answering the often-asked question; What, when, and where would you use these features in a precise and practical way. What you will learn Understand the latest Photoshop tools to add life to your photos Add graphic elements to any composition, photograph, or illustration Tackle challenges in editing multi-layered images for your photography projects Develop illustrative skills with Photoshop Elements' variety of drawing tools Understand techniques for professional photo retouching Work with online and local templates to create calendars, greeting cards, and other projects Who this book is forThis book is for photographers, creative professionals, and individuals who want to master image editing for publishing, press, and web formats with Adobe's Photoshop Elements. Professionals who are looking to become accomplished image retouchers will also find the book helpful. Photography skills along with basic photo editing knowledge will be useful, but not necessary.

Using Benchmark Series: Microsoft (R) PowerPoint 365, 2019 Edition, students can build mastery skills in the presentation software. They will become proficient using PowerPoint to organize, analyze, and present eye-catching presentations that inform and motivate audiences. Through Benchmark's multi-part projects and hierarchy of assessments, students are required to think critically and independently to execute strategies they would implement in today's workplace. Benchmark Series: Microsoft (R) PowerPoint 365, 2019 Edition, covers the Microsoft (R) Office Specialist certification exam objectives. Complete course content is delivered in the Cirrus learning environment through a series of scheduled assignments that report to a grade book to track student progress and achievements.

Enhance your skills in expert module development, deployment, security, DevOps, and cloud Key Features A step-by-step guide to get you started with PowerShell Core 6.0 Harness the capabilities of PowerShell Core 6.0 to perform simple to complex administration tasks Learn core administrative concepts such as scripting, pipelines, and DSC Book DescriptionBeginning with an overview of the different versions of PowerShell, Learn PowerShell Core 6.0 introduces you to VSCode and then dives into helping you understand the basic techniques in PowerShell scripting. You will cover advanced coding techniques, learn how to write reusable code as well as store and load data with PowerShell. This book will help you understand PowerShell security and Just Enough Administration, enabling you to create your own PowerShell repository. The last set of chapters will guide you in setting up, configuring, and working with Release Pipelines in VSCode and VSTS, and help you understand PowerShell DSC. In addition to this, you will learn how to use PowerShell with Windows, Azure, Microsoft Online Services, SCCM, and SQL Server. The final chapter will provide you with some use cases and pro tips. By the end of this book, you will be able to create professional reusable code using security insight and knowledge of working with PowerShell Core 6.0 and its most important capabilities. What you will learn Get to grips with Powershell Core 6.0 Explore basic and advanced PowerShell scripting techniques Get to grips with Windows PowerShell Security Work with centralization and DevOps with PowerShell Implement PowerShell in your organization through real-life examples Learn to create GUIs and use DSC in production Who this book is forIf you are a Windows administrator or a DevOps user who wants to leverage PowerShell to automate simple to complex tasks, then this book is for you. Whether you know nothing about PowerShell or just enough to get by, this guide will give you what you need to go to take your scripting to the next level. You'll also find this book useful if you're a PowerShell expert looking to expand your knowledge in areas such as PowerShell Security and DevOps.

Leverage Office 365 to increase your organization's efficiency Key Features Perform common to advanced-level management and administrative tasks for your organization with Office 365 Become an Office 365 generalist who can work with the entire stack-not just specific products An advanced-level guide that will teach you to implement enterprise-level services into your organization, no matter the size of the business Book DescriptionIn today's world, every organization aims to migrate to the cloud in order to become more efficient by making full use of the latest technologies. Office 365 is your one-stop solution to making your organization reliable, scalable, and fast. This book will start with an overview of Office 365 components, and help you learn how to use the administration portal, and perform basic administration. It then goes on to cover common management tasks, such as managing users, admin roles, groups, securing Office 365, and enforcing compliance. In the next set of chapters, you will learn about topics including managing Skype for Business Online, Yammer, OneDrive for Business, and Microsoft Teams. In the final section of the book, you will learn how to carry out reporting and monitor Office 365 service health. By the end of this book, you will be able to implement enterprise-level services with Office 365 based on your organization's needs. What you will learn Understand the vast Office 365 feature set Understand how workloads and applications interact and integrate with each other Connect PowerShell to various Office 365 services and perform tasks Manage Skype for Business Online Get support and monitor Office 365 service health Manage and administer identities and groups efficiently Who this book is forThis book targets architects, sys admins, engineers, and administrators who are working with Office 365 and are responsible for configuring, implementing, and managing Office 365 in their organization. A prior knowledge of Office 365 and Exchange servers is mandatory.

Plan and execute a successful Office 365 Exchange Online migration with ease About This Book * This book gives you the most up-to-date and accurate information available today on online migration with Microsoft Office 365 * Discover the very best migration path for your small or enterprise network and avoid costly mistakes * Learn from seasoned professionals who migrate small businesses to multinational companies from around the world on a daily basis Who This Book Is For If you are an appointed IT person or an IT administrator who is part of a large internal team in your organization, then this book is for you. If you are a small business owner, manager, or consultant, this book will also help you. Knowledge of Office 365 is not required. However, experience with Exchange Server and mail clients, and role and delegation concepts is required. What You Will Learn * Sign up for an Office 365 account and configure your e-mail domains * Migrate mailboxes from Exchange server, Google, and any other POP3 or IMAP based system in to Office 365 * Configure a hybrid configuration by using Azure AD Connect to synchronize your on-premises Active Directory with Office 365 * Deploy Active Directory Federation Services (AD FS) to enable Single sign on and streamline the login process for your users * Set up a hybrid Exchange configuration and host mailboxes locally or in the cloud and move mailboxes between the two with ease * Configure a public folder hybrid and share existing on-premises public folders with users hosted in Exchange online * Setup a hybrid Skype for Business (SFB) configuration and move users into SFB online * Configure a SharePoint configuration, allowing users to create and search content hosted on an existing SharePoint server as well as in SharePoint online In Detail Organizations are migrating to the cloud to save money, become more efficient, and empower their users with the latest technology. Office 365 delivers all of this in a reliable, fast, and ever-expanding way, keeping you ahead of the competition. As the IT administrator of your network, you need to make the transition as painless as possible for your users. Learn everything you need to know and exactly what to do to ensure your Office 365 Exchange online migration is a success! This guide gives you everything you need to develop a successful migration plan to move from Exchange, Google, POP3, and IMAP systems to Office 365 with ease. We start by providing an overview of the Office 365 plans available and how to make a decision on what plan fits your organization. We then dive into topics such as the Office 365 Admin Portal, integration options for professionals and small businesses, integration options for enterprises, preparing for a simple migration, performing a simple migration, and preparing for a hybrid deployment. Later in the book, we look at migration options for Skype for Business and SharePoint to further help you leverage the latest collaborative working technologies within your organization. Style and approach This is a detailed yet easy to follow step-by-step guide to planning and executing a successful migration to Office 365.