Aplikacje biurowe
David Ringstrom
David Ringstrom coined the phrase “Either you work Excel, or it works you!” after observing how many users carry out tasks inefficiently.In this book, you’ll learn how to get more done with less effort. This book will enable you to create resilient spreadsheets that are easy for others to use as well, while incorporating spreadsheet disaster preparedness techniques. The time-saving techniques covered in the book include creating custom shortcuts and icons to streamline repetitive tasks, as well as automating them with features such as Tables and Custom Views. You’ll see how Conditional Formatting enables you to apply colors, Cell icons, and other formatting on-demand as your data changes. You’ll be empowered to protect the integrity of spreadsheets and increase usability by implementing internal controls, and understand how to solve problems with What-If Analysis features. In addition, you’ll master new features and functions such as XLOOKUP, Dynamic Array functions, LET and LAMBDA, and Power Query, while learning how to leverage shortcuts and nuances in Excel.By the end of this book, you’ll have a broader awareness of how to avoid pitfalls in Excel. You’ll be empowered to work more effectively in Excel, having gained a deeper understanding of the frustrating oddities that can arise daily in Excel.
Nicolás Fernández
Extending Dynamics 365 Customer Engagement Apps with Low Code helps you gain a comprehensive, practical understanding of how a no-code/low-code project approach works for Dynamics 365 (D365) Customer Engagement (CE). This book covers the most relevant native capabilities for configuration, along with real-world scenarios to showcase the magic of extending D365 CE apps with Power Platform.The book starts by identifying different scenarios and use cases to extend D365 CE apps with a low-code approach. You’ll learn about the different capabilities of Dataverse and Power Apps used to extend native applications. Next, you'll discover how to leverage Power Apps, both Canvas apps and model-driven apps, and Power Pages, to build apps and portals around D365 CE processes. You’ll also explore Power Automate's capabilities to create or modify business processes, as well as incorporate new processes and automation. As you advance, you’ll also discover how Power Virtual Agents can be implemented in D365 CE apps. The book concludes by teaching you to integrate Power BI natively with customer engagement, thus facilitating the construction of advanced reports and dashboards.By the end of this book, you’ll have gained hands-on expertise in customizing CE apps with Power Platform to deliver more scalable and maintainable solutions.
Adria Ariste Santacreu
Uncover the synergy between Microsoft Power Platform and its integration with Dynamics 365 Finance & Operations (F&O) with this essential guide to implementing low-code and no-code concepts to not only extend and enhance F&O but also improve maintainability and speed up development.Systematically exploring Power Platform, this book covers topics such as Dataverse, Power Automate, Power Apps, and Power BI using real-world scenarios in Dynamics 365 F&O to offer practical insights. You’ll then master the integration of F&O and Power Platform using dual-write and virtual tables, and delve into process automation with Power Automate. The book further deepens your proficiency in Power Apps by showing you how they can be used to extend the F&O functionality and incorporate artificial intelligence using AI Builder and its pre-trained AI models ready to use with your data. Throughout, you’ll gain a solid understanding of the diverse components of Power Platform and how they can transform your Dynamics 365 F&O experience.By the end of this book, you’ll be equipped with the skills and knowledge necessary to fully harness the immense potential of Power Platform and Dynamics 365 F&O.
Kim Congleton, Shawn Sissenwein
Unlock the untapped potential of Business Central by harnessing the power of the Power Platform with this comprehensive guide, transforming your cumbersome manual processes and limited customization capabilities into a vast array of extended functionalities and possibilities.You’ll begin by exploring the potential of Power Platform and its seamless integration with both the on-premises and cloud versions of Business Central, amplifying the capabilities of your business operations. You’ll then learn how to set up virtual tables and use Dataverse to create a simple model-driven app. As the book progresses, you’ll leverage Power Apps, including both Canvas apps and model-driven apps, to build apps around Business Central processes. The book also highlights Power Automate’s capabilities to create or modify business processes while incorporating new processes and automation. As you advance, you’ll connect to Business Central APIs that can be implemented to connect with Business Central Data and finally integrate Power BI natively with Business Central, empowering you to construct advanced reports and dashboards.With the hands-on experience gained throughout the book, you’ll build expertise in customizing Business Central with Power Platform to deliver more scalable and maintainable solutions.
Simon Buxton
Dynamics 365 Finance and Supply Chain Management is Microsoft’s ERP solution, which can be implemented as a cloud or on-premise solution to facilitate better decision-making with the help of contemporary, scalable ERP system tools. This book is updated with the latest features of Dynamics 365 Finance and Supply Chain Management including Chain of Command (CoC), Acceptance Test Libraries (ATL), and Business Events. The book not only features more than 100 tutorials that allow you to create and extend business solutions, but also addresses specific problems and offers solutions with insights into how they work.This cookbook starts by helping you set up a Azure DevOps project and taking you through the different data types and structures used to create tables. You will then gain an understanding of user interfaces, write extensible code, manage data entities, and even model Dynamics 365 ERP for security. As you advance, you’ll learn how to work with various in-built Dynamics frameworks such as SysOperation, SysTest, and Business Events. Finally, you’ll get to grips with automated build management and workflows for better application state management.By the end of this book, you’ll have become proficient in packaging and deploying end-to-end scalable solutions with Microsoft Dynamics 365 Finance and Supply Chain Management.
Simon Buxton
Dynamics 365 Finance and Supply Chain Management is Microsoft’s ERP solution, which can be implemented as a cloud or on-premise solution to facilitate better decision-making with the help of contemporary, scalable ERP system tools. This book is updated with the latest features of Dynamics 365 Finance and Supply Chain Management including Chain of Command (CoC), Acceptance Test Libraries (ATL), and Business Events. The book not only features more than 100 tutorials that allow you to create and extend business solutions, but also addresses specific problems and offers solutions with insights into how they work.This cookbook starts by helping you set up a Azure DevOps project and taking you through the different data types and structures used to create tables. You will then gain an understanding of user interfaces, write extensible code, manage data entities, and even model Dynamics 365 ERP for security. As you advance, you’ll learn how to work with various in-built Dynamics frameworks such as SysOperation, SysTest, and Business Events. Finally, you’ll get to grips with automated build management and workflows for better application state management.By the end of this book, you’ll have become proficient in packaging and deploying end-to-end scalable solutions with Microsoft Dynamics 365 Finance and Supply Chain Management.
Simon Buxton
Dynamics 365 for Operations is the ERP element of Microsoft’s new Dynamics 365 Enterprise Edition. Operations delivers the infrastructure to allow businesses to achieve growth and make better decisions using scalable and contemporary ERP system tools. This book provides a collection of “recipes” to instruct you on how to create—and extend—a real-world solution using Operations. All key aspects of the new release are covered, and insights into the development language, structure, and tools are discussed in detail. New concepts and patterns that are pivotal to elegant solution designs are introduced and explained, and readers will learn how to extend various aspects of the system to enhance both the usability and capabilities of Operations. Together, this gives the reader important context regarding the new concepts and the confidence to reuse in their own solution designs. This “cookbook” provides the ingredients and methods needed to maximize the efficiency of your business management using the latest in ERP software—Dynamics 365 for Operations.
Extending Microsoft Dynamics NAV 2016 Cookbook. Extend Dynamics NAV 2016 to win the business world
Alexander Drogin
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. Its integrated development environment enables customizations with minimal disruption to business processes.The book starts explaining the new features of Dynamics NAV along with how to create and modify a simple module. Moving on, you will learn the importance of thinking beyond the boundaries of C/AL development and the possibilities opened by with it. Next, you will get to know how COM can be used to extend the functionalities of Dynamics NAV. You’ll find out how to extend the Dynamics NAV 2016 version using .NET interoperability and will see the steps required to subscribe to .NET events in order to extend Dynamics NAV. Finally, you’ll see the cmdlets available to manage extension packages. By the end of the book, you will have the knowledge needed to become more efficient in selecting the extending methods, developing and deploying them to the Dynamics NAV, and practicing the best practices.
Danish Naglekar
Power Apps Component Framework is used by professional developers to extend the capabilities of model-driven and canvas apps. Extending Microsoft Power Apps with Power Apps Component Framework will take you through the basic as well as advanced topics using practical examples.The book starts by helping you understand the fundamentals of the framework, its lifecycle, and the tools that you'll use to build code components using best practices and file management guidelines. You'll then learn how to extend Power Apps step by step and apply the principles and concepts covered in the book to build code components for field type attributes. The book covers different ways of debugging code components and guides you through the process of building code components for datasets. You'll also explore the functions and methods provided by the framework to enhance your controls using powerful sets of libraries and extensions. As you advance, you'll get to grips with creating and managing authentication profiles, discover different ways of deploying code components, and configure code components in model-driven and canvas apps. Finally, you'll learn some of the important features of the framework and learn modern web development practices.By the end of this Power Apps book, you'll be able to build, debug, enrich, and deploy code components confidently.
Danish Naglekar
Power Apps Component Framework is used by professional developers to extend the capabilities of model-driven and canvas apps. Extending Microsoft Power Apps with Power Apps Component Framework will take you through the basic as well as advanced topics using practical examples.The book starts by helping you understand the fundamentals of the framework, its lifecycle, and the tools that you'll use to build code components using best practices and file management guidelines. You'll then learn how to extend Power Apps step by step and apply the principles and concepts covered in the book to build code components for field type attributes. The book covers different ways of debugging code components and guides you through the process of building code components for datasets. You'll also explore the functions and methods provided by the framework to enhance your controls using powerful sets of libraries and extensions. As you advance, you'll get to grips with creating and managing authentication profiles, discover different ways of deploying code components, and configure code components in model-driven and canvas apps. Finally, you'll learn some of the important features of the framework and learn modern web development practices.By the end of this Power Apps book, you'll be able to build, debug, enrich, and deploy code components confidently.