Microsoft Excel 2019 Formulas and Functions
Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets.
Use Excel 2019 and Office 365 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including the latest improvements to arrays, formula error handling, and statistics. McFedries' step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate- to advanced-level formula construction, and help you leverage Excel's most useful functions in your everyday work. Becoming an Excel expert has never been easier!
By reading this book, you will: Improve business analyses by adding intelligence and knowledge to your models; Replace cumbersome formulas with convenient predefined functions; Radically ...
Microsoft Excel 2019 Pivot Table Data Crunching
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables.
Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power - including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else.
By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables; Control all future pivot tables using new pivot table defaults; Transform huge data sets into clear summary reports; Instantly ...
Microsoft Word 2019 Step by Step
Get more done quickly with Microsoft Word 2019 and Word for Office 365. Jump in wherever you need answers - brisk lessons and informative screenshots show you exactly what to do, step by step.
Create great-looking, well-organized documents to enhance communication; Use headings, bookmarks, and footnotes for more intuitive access to knowledge; Visualize information by using diagrams and charts; Illustrate concepts by using 3D models, icons, and screen clippings; Collaborate, track changes, and coauthor documents in real-time; Enforce security and privacy in electronic documents; Quickly build tables of contents, indexes, and equations; Generate individualized emails, letters, labels, envelopes, directories, and catalogs; Supercharge efficiency with custom styles, themes, templates, and building blocks; Look up just the tasks and lessons you need. ...
Dynamic SQL, 2nd Edition
Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to improve efficiency and maintainability.
Executing dynamic SQL is key to large-scale searching based on user-entered criteria. Dynamic SQL can generate lists of values and even code with minimal impact on performance. Dynamic SQL enables dynamic pivoting of data for business intelligence solutions as well as customizing of database objects. Yet dynamic SQL is feared by many due to concerns over SQL injection or code maintainability.
Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and secu ...
Developing Bots with QnA Maker Service
Learn to develop bots with zero coding knowledge using the Azure Cognitive QnA Maker service, a GUI cognitive service from Microsoft. This book shows you how to integrate QnA Maker with the Azure Bot Service and Microsoft Bot Framework, along with how to integrate your bot with social channels such as Web Chat, and Telegram.
You will learn what QnA Maker is, why you should use this service in enterprise settings, when you should use this service, and how you should use the service. Developing Bots with QnA Maker Service takes you through the QnA Maker FAQ knowledge base with Azure Bot Service, where you will discover how to get started with a web app bot using the Azure portal. This section culminates in deploying your bot on Azure Web App, making your bot live.
Next, you will learn QnA Maker with the .NET Framework and Visual Studio 2017 along with ways to manage QnA Maker service post deployment. Finally, you will learn how to add media content including videos and image ...
Microsoft Dynamics NAV Development Quick Start Guide
Microsoft Dynamics NAV is an enterprise resource planning (ERP) software suite for organizations. The system offers specialized functionality for manufacturing, distribution, government, retail, and other industries. This book gets you started with its integrated development environment for solving problems by customizing business processes.
This book introduces the NAV development environment - C/SIDE. It gives an overview of the internal system language and the most essential development tools. The book will enable the reader to customize and extend NAV functionality with C/AL code, design a user interface through pages, create role centers, and build advanced reports in Microsoft Visual Studio.
By the end of the book, you will have learned how to extend the NAV data model, how to write and debug custom code, and how to exchange data with external applications. ...
Learn Microsoft Azure
Azure is one of the leading public cloud service providers. Thanks to a number of Azure service updates, it continues to make advances in the realm of cloud computing.
Learn Microsoft Azure starts with the fundamentals of cloud computing. You will learn to configure and set up the Azure infrastructure. As you make your way through the book, you'll explore Azure services, along with working on virtual memory systems (VMS) and deployment models. You will understand various services in the Azure ecosystem, such as Azure IoT and Azure Analytics, among others. An easy-to-follow introduction to various cloud design patterns will also add to your efficiency in designing cloud solutions. In the concluding chapters, you'll secure your virtual networks using Network security groups and configure Azure Active Directory (Azure AD) to set a custom domain name and company profile. ...
Microsoft System Center Data Protection Manager Cookbook
System Center Data Protection Manager (SCDPM) is a robust enterprise backup and recovery system that contributes to your BCDR strategy by facilitating the backup and recovery of enterprise data. With an increase in data recovery and protection problems faced in organizations, it has become important to keep data safe and recoverable. This book contains recipes that will help you upgrade to SCDPM and it covers the advanced features and functionality of SCDPM.
This book starts by helping you install SCDPM and then moves on to post-installation and management tasks. You will come across a lot of useful recipes that will help you recover your VMware and Hyper-V VMs. It will also walk you through tips for monitoring SCDPM in different scenarios. Next, the book will also offer insights into protecting windows workloads followed by best practices on SCDPM. You will also learn to back up your Azure Stack Infrastructure using Azure Backup. You will also learn about recovering data from backu ...
Deployment of Microsoft Azure Cloud Solutions
Microsoft Azure has numerous effective solutions that shape the future of any business. Over the years, Azure cloud services have grown quickly, and the number of organizations adopting Azure for their cloud services is also gradually increasing. Leading industry giants are finding that Azure fulfills their extensive cloud requirements.
Deployment of Microsoft Azure Cloud Solutions starts with an extensive introduction to all the categories of designs available with Azure. These design patterns focus on different aspects of the cloud such as high availability, data management, and so on.
You will learn various aspects such as building your cloud structure and architecture. You will also have a brief understanding of the different types of services provided by Azure, such as Azure functions and Azure Analytics, which can prove beneficial for an organization. You will learn each and every aspect and function required to develop an Azure cloud based on your organizatio ...
Microsoft Excel 2019 VBA and Macros
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets.
Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions.
By reading this book, you will: Quickly master Excel macro development; Work more efficiently with ranges, cells, and formulas; Generate automated reports and quickly adapt them for new requirements; Learn to automate ...
Microsoft Office 2019 Step by Step
Get more done quickly with Office 2019. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step.
Covers Word, Excel, PowerPoint and Outlook; Format Word documents for maximum visual impact; Build powerful, reliable Excel workbooks for analysis and reporting; Prepare highly effective PowerPoint presentations; Use Outlook to organize your email, calendar, and contacts; Includes downloadable practice files. ...