Inne

Exploring Microsoft Excel's Hidden Treasures. Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features

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.

Extending Dynamics 365 Customer Engagement Apps with Low Code. Create tailor-made Dynamics 365 CE apps using the powerful low-code capabilities of Power Platform

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.

Extending Dynamics 365 Finance and Operations Apps with Power Platform. Integrate Power Platform solutions to maximize the efficiency of your Finance & Operations projects

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.

Extending Microsoft Business Central with Power Platform. Leverage Power Platform to create scalable Business Central solutions with high business value

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.

Extending Microsoft Dynamics 365 for Operations Cookbook. Create and extend real-world solutions using Dynamics 365 Operations

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.

Extending Power BI with Python and R. Perform advanced analysis using the power of analytical languages - Second Edition

Luca Zavarella, Rajat Talwar

The latest edition of this book delves deep into advanced analytics, focusing on enhancing Python and R proficiency within Power BI. New chapters cover optimizing Python and R settings, utilizing Intel's Math Kernel Library (MKL) for performance boosts, and addressing integration challenges. Techniques for managing large datasets beyond available RAM, employing the Parquet data format, and advanced fuzzy matching algorithms are explored. Additionally, it discusses leveraging SQL Server Language Extensions to overcome traditional Python and R limitations in Power BI. It also helps in crafting sophisticated visualizations using the Grammar of Graphics in both R and Python.This Power BI book will help you master data validation with regular expressions, import data from diverse sources, and apply advanced algorithms for transformation. You'll learn how to safeguard personal data in Power BI with techniques like pseudonymization, anonymization, and data masking. You'll also get to grips with the key statistical features of datasets by plotting multiple visual graphs in the process of building a machine learning model. The book will guide you on utilizing external APIs for enrichment, enhancing I/O performance, and leveraging Python and R for analysis.You'll reinforce your learning with questions at the end of each chapter.

Extreme DAX. Take your Power BI and Fabric analytics skills to the next level - Second Edition

Michiel Rozema, Madzy Stikkelorum, Henk Vlootman, Jeroen...

This book helps experienced analysts unlock the full potential of DAX in Power BI and Microsoft Fabric to build scalable, production-ready analytics solutions.You’ll begin by strengthening your understanding of semantic models, data modeling, and evaluation context—the foundation of reliable analytics. Instead of isolated examples, the book uses real-world scenarios such as inventory analysis, benchmarking, and data security to show how advanced DAX calculations are applied in practice.As you progress, you’ll master advanced techniques including context transition, table functions, calculation groups, field parameters, and custom calendars. You’ll also explore analytical methods such as regression and goal-seeking to generate deeper insights from your data.With step-by-step guidance and practical PBIX examples, you’ll learn how to design efficient models, avoid common pitfalls, and implement reusable calculations. By the end, you’ll be able to create advanced DAX measures and high-performance Power BI solutions for complex analytical requirements.