Microsoft Excel Formulas and Functions
Use Excel 365 and Excel 2021 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 recent improvements ranging from dynamic arrays to XLOOKUP and LET. 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 Excels most useful functions in your everyday work. By reading this book, you will: Improve business analyses by adding intelligence and knowledge to your models; Replace cumbersome formulas with convenient predefined functions; Use modern lookups to make your formulas more powerful and flexible; Simplify complex calculations with dynamic arrays in Excel 365 and Excel 2021; Use conditional formatting to reveal anom ...
Use Excel 365 and Excel 2021 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 recent improvements ranging from dynamic arrays to XLOOKUP and LET. 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 Excels most useful functions in your everyday work. By reading this book, you will: Improve business analyses by adding intelligence and knowledge to your models; Replace cumbersome formulas with convenient predefined functions; Use modern lookups to make your formulas more powerful and flexible; Simplify complex calculations with dynamic arrays in Excel 365 and Excel 2021; Use conditional formatting to reveal anom ...
Microsoft Visual C# Step by Step, 10th Edition
Expand your expertiseand teach yourself the fundamentals of programming the latest version of Visual C# with Visual Studio 2022. This book provides software developers all the guidance, exercises, and code needed to start building responsive, scalable, cloud-connected applications that can run almost anywhere. Discover how to: Quickly start creating Visual C# code and projects with Visual Studio; Work with variables, operators, expressions, methods, and program flow; Build more robust apps with error, exception, and resource management; Spot problems fast with the integrated Visual Studio 2022 debugger; Master new default interface methods, static local functions, async disposable types, and other enhancements; Make the most of the C# object model, and create functional data structures; Leverage advanced properties, indexers, generics, and collection classes; Create Windows 11 apps that share data, collaborate, and use cloud services; Use lightweight records to build immutable ref ...
Expand your expertiseand teach yourself the fundamentals of programming the latest version of Visual C# with Visual Studio 2022. This book provides software developers all the guidance, exercises, and code needed to start building responsive, scalable, cloud-connected applications that can run almost anywhere. Discover how to: Quickly start creating Visual C# code and projects with Visual Studio; Work with variables, operators, expressions, methods, and program flow; Build more robust apps with error, exception, and resource management; Spot problems fast with the integrated Visual Studio 2022 debugger; Master new default interface methods, static local functions, async disposable types, and other enhancements; Make the most of the C# object model, and create functional data structures; Leverage advanced properties, indexers, generics, and collection classes; Create Windows 11 apps that share data, collaborate, and use cloud services; Use lightweight records to build immutable ref ...
Extreme DAX
This book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of Microsoft Business Intelligence tools. Extreme DAX will first teach you the principles of business intelligence, good model design, and how DAX fits into it all. Then, you'll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, forecasting, intercompany business, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with Power BI models and common mistakes to look out for as you build advanced data aggregations. You'll deepen your understanding of DAX functions, filters, and measures, and how and when they can be used to derive effective insights. You'll also be provided with PBIX files for each chapter, so that you can follow along and explore in your own time. ...
This book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of Microsoft Business Intelligence tools. Extreme DAX will first teach you the principles of business intelligence, good model design, and how DAX fits into it all. Then, you'll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, forecasting, intercompany business, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with Power BI models and common mistakes to look out for as you build advanced data aggregations. You'll deepen your understanding of DAX functions, filters, and measures, and how and when they can be used to derive effective insights. You'll also be provided with PBIX files for each chapter, so that you can follow along and explore in your own time. ...
Practical Paint.NET
Learn to use the most up-to-date version of Paint.NET, the free, Windows-based program for image editing. This book is ideal for PC users who find Microsoft Paint too lacking, and Photoshop or GIMP too overwhelming. ​Paint.NET is a lightweight yet capable program that's easy to navigate and is regularly updated. You'll quickly become acquainted with this powerful, yet easy-to-learn program's features; tools, layers, adjustments, and effects. See how to correct exposure, digitally retouch and repair damaged photos, and handle a broad spectrum of photo editing tasks - even how to colorize a black-and-white image. You'll also learn how to create digital art using the Paint.NET drawing tools and effects. Practice files are provided with step-by-step instructions to jump into photo editing and art creation. Practical Paint.NET highlights this powerful program's rich set of features and capabilities providing you the pathway for just about any kind of image editing. Join the large c ...
Learn to use the most up-to-date version of Paint.NET, the free, Windows-based program for image editing. This book is ideal for PC users who find Microsoft Paint too lacking, and Photoshop or GIMP too overwhelming. ​Paint.NET is a lightweight yet capable program that's easy to navigate and is regularly updated. You'll quickly become acquainted with this powerful, yet easy-to-learn program's features; tools, layers, adjustments, and effects. See how to correct exposure, digitally retouch and repair damaged photos, and handle a broad spectrum of photo editing tasks - even how to colorize a black-and-white image. You'll also learn how to create digital art using the Paint.NET drawing tools and effects. Practice files are provided with step-by-step instructions to jump into photo editing and art creation. Practical Paint.NET highlights this powerful program's rich set of features and capabilities providing you the pathway for just about any kind of image editing. Join the large c ...
Mastering the Microsoft Kinect
Know how to program the Microsoft Kinect and use the device for applications that interact directly with humans through gestures and motion. This book covers the mathematics and theoretical background needed for depth sensing, motion tracking, and object recognition while maintaining a practical focus on getting things done. You will learn to track the human body in three-dimensional space, analyze the human motion, and remove the background to isolate the person being tracked. You will see how to recognize objects and voice, and transform between the three-dimensional physical space and a computer's two-dimensional screen. The book is written with real-world applications in mind. It provides step-by-step tutorials and source code for common use cases. The author has worked with startups and Fortune 500 companies, and all of the examples are taken directly from the industry. The book's practical focus simplifies the core principles, removes the clutter, and allows developers to star ...
Know how to program the Microsoft Kinect and use the device for applications that interact directly with humans through gestures and motion. This book covers the mathematics and theoretical background needed for depth sensing, motion tracking, and object recognition while maintaining a practical focus on getting things done. You will learn to track the human body in three-dimensional space, analyze the human motion, and remove the background to isolate the person being tracked. You will see how to recognize objects and voice, and transform between the three-dimensional physical space and a computer's two-dimensional screen. The book is written with real-world applications in mind. It provides step-by-step tutorials and source code for common use cases. The author has worked with startups and Fortune 500 companies, and all of the examples are taken directly from the industry. The book's practical focus simplifies the core principles, removes the clutter, and allows developers to star ...
Pro Serverless Data Handling with Microsoft Azure
Design and build architectures on the Microsoft Azure platform specifically for data-driven and ETL applications. Modern cloud architectures rely on serverless components more than ever, and this book helps you identify those components of data-driven or ETL applications that can be tackled using the technologies available on the Azure platform. The book shows you which Azure components are best suited to form a strong foundation for data-driven applications in the Microsoft Azure Cloud. If you are a solution architect or a decision maker, the conceptual aspects of this book will help you gain a deeper understanding of the underlying technology and its capabilities. You will understand how to develop using Azure Functions, Azure Data Factory, Logic Apps, and to employ serverless databases in your application to achieve the best scalability and design. If you are a developer, you will benefit from the hands-on approach used throughout this book. Many practical examples and architectu ...
Design and build architectures on the Microsoft Azure platform specifically for data-driven and ETL applications. Modern cloud architectures rely on serverless components more than ever, and this book helps you identify those components of data-driven or ETL applications that can be tackled using the technologies available on the Azure platform. The book shows you which Azure components are best suited to form a strong foundation for data-driven applications in the Microsoft Azure Cloud. If you are a solution architect or a decision maker, the conceptual aspects of this book will help you gain a deeper understanding of the underlying technology and its capabilities. You will understand how to develop using Azure Functions, Azure Data Factory, Logic Apps, and to employ serverless databases in your application to achieve the best scalability and design. If you are a developer, you will benefit from the hands-on approach used throughout this book. Many practical examples and architectu ...
Pro iPhone Development with SwiftUI, 3rd Edition
You know the basics. Your Swift code flows with logic and ease. This isn't your first time building a workable app for iOS platforms. Now, it's time to build a magical app for iOS platforms! Move beyond what you mastered in the best-selling Beginning iPhone Development with SwiftUI. Debug Swift code, use multi-threaded programming with Grand Central Dispatch, pass data between view controllers, and design apps functional in multiple languages. Not only will your apps run like magic under the hood but, with the new standard of SwiftUI, you'll add animations, scaling, multiscreen support, and so much more to your interfaces. You'll also see how to integrate audio and video files in your apps, access the camera and send pictures to and from the Photos library, use location services to pinpoint your user's position on a map, and display web pages in-app. Don't just stop at flawless code and stickily engaging interfaces. Give your apps a mind with Apple's advanced frameworks for machine ...
You know the basics. Your Swift code flows with logic and ease. This isn't your first time building a workable app for iOS platforms. Now, it's time to build a magical app for iOS platforms! Move beyond what you mastered in the best-selling Beginning iPhone Development with SwiftUI. Debug Swift code, use multi-threaded programming with Grand Central Dispatch, pass data between view controllers, and design apps functional in multiple languages. Not only will your apps run like magic under the hood but, with the new standard of SwiftUI, you'll add animations, scaling, multiscreen support, and so much more to your interfaces. You'll also see how to integrate audio and video files in your apps, access the camera and send pictures to and from the Photos library, use location services to pinpoint your user's position on a map, and display web pages in-app. Don't just stop at flawless code and stickily engaging interfaces. Give your apps a mind with Apple's advanced frameworks for machine ...
OOP
You can find a whole range of programming textbooks intended for complete beginners. However, this one is exceptional to certain extent. The whole textbook is designed as a record of the dialogue of the author with his daughter who wants to learn programming. The author endeavors not to explain the Java programming language to the readers, but to teach them real programming. To teach them how to think and design the program as the experienced programmers do. Entire matter is explained in a very illustrative way which means even a current secondary school student can understand it quite simply. The book comes out of the author's long-term experience with teaching children, university students as well as professional programmers. The author teaches programming according to the Architecture First methodology which reacts at the companies' complaints that the school graduates are usually good in coding, but bad in software architecture. Coding itself is gradually taken over by various ...
You can find a whole range of programming textbooks intended for complete beginners. However, this one is exceptional to certain extent. The whole textbook is designed as a record of the dialogue of the author with his daughter who wants to learn programming. The author endeavors not to explain the Java programming language to the readers, but to teach them real programming. To teach them how to think and design the program as the experienced programmers do. Entire matter is explained in a very illustrative way which means even a current secondary school student can understand it quite simply. The book comes out of the author's long-term experience with teaching children, university students as well as professional programmers. The author teaches programming according to the Architecture First methodology which reacts at the companies' complaints that the school graduates are usually good in coding, but bad in software architecture. Coding itself is gradually taken over by various ...
Unity Artificial Intelligence Programming, 5th Edition
Developing artificial intelligence (AI) for game characters in Unity has never been easier. Unity provides game and app developers with a variety of tools to implement AI, from basic techniques to cutting-edge machine learning-powered agents. Leveraging these tools via Unity's API or built-in features allows limitless possibilities when it comes to creating game worlds and characters. The updated fifth edition of Unity Artificial Intelligence Programming starts by breaking down AI into simple concepts. Using a variety of examples, the book then takes those concepts and walks you through actual implementations designed to highlight key concepts and features related to game AI in Unity. As you progress, you'll learn how to implement a finite state machine (FSM) to determine how your AI behaves, apply probability and randomness to make games less predictable, and implement a basic sensory system. Later, you'll understand how to set up a game map with a navigation mesh, incorporate move ...
Developing artificial intelligence (AI) for game characters in Unity has never been easier. Unity provides game and app developers with a variety of tools to implement AI, from basic techniques to cutting-edge machine learning-powered agents. Leveraging these tools via Unity's API or built-in features allows limitless possibilities when it comes to creating game worlds and characters. The updated fifth edition of Unity Artificial Intelligence Programming starts by breaking down AI into simple concepts. Using a variety of examples, the book then takes those concepts and walks you through actual implementations designed to highlight key concepts and features related to game AI in Unity. As you progress, you'll learn how to implement a finite state machine (FSM) to determine how your AI behaves, apply probability and randomness to make games less predictable, and implement a basic sensory system. Later, you'll understand how to set up a game map with a navigation mesh, incorporate move ...
Leadership in a Zoom Economy with Microsoft Teams
Manage and lead a team remotely by intertwining leadership principles with the many robust tools of Microsoft Teams. This book shows you how to utilize Microsoft Teams in an effective way to achieve your global team goals. Leading a team is a challenge, but leading a team in the zoom economy can make you stressed out and overworked. Peter Ward gives the reader a communication and organization centered approach for the dynamic, hardworking, successful employee who wants to step into a leadership role and vastly improve their organization with the aid of Microsoft Teams. Ward shares his own "rules" for successful leadership of teams and small companies, to scale at a steady pace, creating a culture of accountability and responsibility, with a remote workforce, not using venture capital, and applying minimal bureaucracy. Ward says teamwork, right hires, diversity, and work balance are equally important as profitability. Leadership in a Zoom Economy with Microsoft Teams is a portrait of ...
Manage and lead a team remotely by intertwining leadership principles with the many robust tools of Microsoft Teams. This book shows you how to utilize Microsoft Teams in an effective way to achieve your global team goals. Leading a team is a challenge, but leading a team in the zoom economy can make you stressed out and overworked. Peter Ward gives the reader a communication and organization centered approach for the dynamic, hardworking, successful employee who wants to step into a leadership role and vastly improve their organization with the aid of Microsoft Teams. Ward shares his own "rules" for successful leadership of teams and small companies, to scale at a steady pace, creating a culture of accountability and responsibility, with a remote workforce, not using venture capital, and applying minimal bureaucracy. Ward says teamwork, right hires, diversity, and work balance are equally important as profitability. Leadership in a Zoom Economy with Microsoft Teams is a portrait of ...