Aplikacje biznesowe
Excel Insights. A Microsoft MVP Guide to the Best Parts of Excel
MrExcel's Holy Macro! Books, 24 Excel MVPs
Dive into the world of advanced Excel techniques designed to elevate your data analysis skills. Start with mastering custom number formatting, efficient data entry, and powerful formulas like INDEX MATCH. Explore Excel's evolving features, including dynamic arrays and new data types, ensuring you stay at the forefront of the latest tools.The course then guides you through creating impactful charts for presentations and advanced filtering techniques. You’ll also discover the transformative power of Power Query, allowing you to manipulate and combine data with ease. With chapters on financial modeling and creative Excel model development, you’ll learn to solve complex problems and develop innovative solutions.Finally, the course introduces you to VBA, teaching you how to automate tasks and create custom worksheet functions, equipping you with the skills to enhance your workflows. By the end of the course, you’ll have a robust understanding of Excel's advanced features, empowering you to handle any data challenge with confidence and creativity.
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 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.
Luca Zavarella
With this updated second edition, you'll not only learn how to configure the Power BI environment to run Python and R scripts at peak performance—you'll also become familiar with the appropriate solutions to the most common problems you may encounter. Extending Power BI with Python and R explores data ingestion and data transformation extensions before moving on to focus on data enrichment and data visualization. You'll learn how to ingest data larger than available memory, import data from external sources, and transform data using complex algorithms, as well as implementing personal data de-identification methods such as pseudonymization, anonymization, and masking in Power BI. You'll find out how to call external APIs to enrich your data much faster, and address I/O performance issues using Python and R. Next, you'll learn advanced Python and R techniques to perform in-depth analysis and extract valuable information using statistics and machine learning. You'll also get to grips with the key statistical features of data sets by plotting multiple visual graphs in the process of building a machine learning model. Your knowledge will be tested through questions and answers at the end of each chapter.By the end of this book, you’ll be able to enrich your Power BI data models and unlock valuable insights using Python and R.