VBA Automation for Excel 2019 Cookbook. Solutions to automate routine tasks and increase productivity with Excel and other MS Office applications

Mike Van Niekerk

Visual 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.

Work Smarter with Microsoft OneNote. An expert guide to setting up OneNote notebooks to become more organized, efficient, and productive

Do you want to take your information and note organization to a new level? This book will show you how to use Microsoft’s organizational app, OneNote, to store endless amounts of information in a productive and organized way, including solutions for creating your notes and then sharing them easily with your team or department.You’ll be guided through everything you need to set up a notebook and customize it to suit you or your team. The book will show you how to navigate through OneNote and search for virtually anything, as well as save time with all the shortcuts. You’ll discover that inserting information into your notebooks goes far beyond text, images, and videos, and also includes emails, links to documents, and clippings from the web. But it doesn’t stop there. Integration with other Microsoft products is key for making your experience successful, and this book demonstrates how to use OneNote with Microsoft Outlook, OneDrive, SharePoint and Teams. Beyond instructions and essential topics, this book also provides you with the motivation you need to make OneNote a habit as well as real-life examples of notebooks you can use.By the end of this book, you’ll be able to use OneNote for everything and from every device. Even if you start a notebook on your laptop and continue it on your phone, you’ll find working with the app seamless.

Workflow Automation with Microsoft Power Automate. Achieve digital transformation through business automation with minimal coding

Aaron Guilmette

Microsoft Power Automate is a workflow automation solution included in Microsoft 365. This book explores the core concepts of workflow automation, such as working with connectors, triggers, and actions, along with their practical implementation in automating business tasks and simplifying digital processes to boost enterprise productivity.

Working with Microsoft Forms and Customer Voice. Efficiently gather and manage customer feedback, insights, and experiences

Welly Lee, James Phillips, Ray Smith

Microsoft Forms and Dynamics 365 Customer Voice enable organizations to collect and analyze feedback from employees and customers, helping developers to integrate their feedback and business users to collect feedback that will guide them to develop customer-centric solutions.This book takes a hands-on approach to leveraging Microsoft Forms and Dynamics 365 Customer Voice capabilities for common feedback scenarios and covers best practices and tips and tricks to have your solution up and running in no time. You'll start by exploring common scenarios where organizations collect feedback from employees and customers and implement end-to-end solutions with Forms. You’ll then discover how to create surveys and get to grips with different configuration options commonly used for each scenario. Throughout the book, you'll also find sample questions and step-by-step instructions for integrating the survey with related technology such as Microsoft Teams, Power Automate, and Power BI for an end-to-end scenario.By the end of this Microsoft book, you’ll be able to build and deploy your complete solution using Microsoft Forms and Dynamics 365 Customer Voice, allowing you to listen to customers or employees, interpret their feedback, take timely follow-up action, and monitor results.