Microsoft Excel Pivot Table Data Crunching
Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if youve never created a pivot table before, this book will help you leverage all their flexibility and analytical power including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen (MrExcel) shares practical recipes for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks youll find nowhere else. By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables; Transform huge datasets into clear summary reports; Instantly highlight your most profitable customers, products, or regions; Use the data model and Power Query to quickly analyze disparate data sources; Create powerful crosstab reports with new dynamic arrays and Power Query; Build ge ...
Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if youve never created a pivot table before, this book will help you leverage all their flexibility and analytical power including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen (MrExcel) shares practical recipes for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks youll find nowhere else. By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables; Transform huge datasets into clear summary reports; Instantly highlight your most profitable customers, products, or regions; Use the data model and Power Query to quickly analyze disparate data sources; Create powerful crosstab reports with new dynamic arrays and Power Query; Build ge ...
Application Delivery and Load Balancing in Microsoft Azure
With more and more companies moving on-premises applications to the cloud, software and cloud solution architects alike are busy investigating ways to improve load balancing, performance, security, and high availability for workloads. This practical book describes Microsoft Azure's load balancing options and explains how NGINX can contribute to a comprehensive solution. Cloud architects Derek DeJonghe and Arlan Nugara take you through the steps necessary to design a practical solution for your network. Software developers and technical managers will learn how these technologies have a direct impact on application development and architecture. While the examples are specific to Azure, these load balancing concepts and implementations also apply to cloud providers such as AWS, Google Cloud, DigitalOcean, and IBM Cloud. - Understand application delivery and load balancing - and why they're important; - Explore Azure's managed load balancing options; - Learn how to run NGINX OSS an ...
With more and more companies moving on-premises applications to the cloud, software and cloud solution architects alike are busy investigating ways to improve load balancing, performance, security, and high availability for workloads. This practical book describes Microsoft Azure's load balancing options and explains how NGINX can contribute to a comprehensive solution. Cloud architects Derek DeJonghe and Arlan Nugara take you through the steps necessary to design a practical solution for your network. Software developers and technical managers will learn how these technologies have a direct impact on application development and architecture. While the examples are specific to Azure, these load balancing concepts and implementations also apply to cloud providers such as AWS, Google Cloud, DigitalOcean, and IBM Cloud. - Understand application delivery and load balancing - and why they're important; - Explore Azure's managed load balancing options; - Learn how to run NGINX OSS an ...
Microsoft Excel Step by Step
This is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answersbrisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for effective visual impact; Perform calculations and find and correct errors; Manage, filter, summarize, validate, reorder, and combine data; Identify trends, illustrate processes and relationships, and dynamically analyze data; Build sophisticated forecasts, key performance indicators (KPIs), and timelines; Visualize data with customized charts, 3D maps, and other powerful tools; Import, process, summarize, and analyze huge data sets with PowerPivot and Power Query; Use powerful Excel Data Models for advanced business intelligence. ...
This is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answersbrisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for effective visual impact; Perform calculations and find and correct errors; Manage, filter, summarize, validate, reorder, and combine data; Identify trends, illustrate processes and relationships, and dynamically analyze data; Build sophisticated forecasts, key performance indicators (KPIs), and timelines; Visualize data with customized charts, 3D maps, and other powerful tools; Import, process, summarize, and analyze huge data sets with PowerPivot and Power Query; Use powerful Excel Data Models for advanced business intelligence. ...
Microsoft Excel Data Analysis and Business Modeling, 7th Edition
Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winstons hands-on, scenario-focused guide helps you use todays Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. Solve real problems with Microsoft Exceland build your competitive advantage. Quickly transition from Excel basics to sophisticated analytics; Use recent Power Query enhancements to connect, combine, and transform data sources more effectively; Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA; Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movi ...
Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winstons hands-on, scenario-focused guide helps you use todays Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. Solve real problems with Microsoft Exceland build your competitive advantage. Quickly transition from Excel basics to sophisticated analytics; Use recent Power Query enhancements to connect, combine, and transform data sources more effectively; Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA; Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movi ...
Microsoft Azure Data Solutions
Cloud technologies are advancing at an accelerating pace, supplanting traditional relational and data warehouse storage solutions with novel, high-value alternatives. Now, three pioneering Azure Data consultants offer an expert introduction to the relational, non-relational, and data warehouse solutions offered by the Azure platform. Drawing on their extensive experience helping organizations get more value from the Microsoft Data Platform, the authors guide you through decision-making, implementation, operations, security, and more. Throughout, step-by-step tutorials and hands-on exercises prepare you to succeed, even if you have no cloud data experience. Three leading experts in Microsoft Azure Data Solutions show how to: Master essential concepts of data storage and processing in cloud environments; Handle the changing responsibilities of data engineers moving to the cloud; Get started with Azure data storage accounts and other data facilities; Walk through implementing relationa ...
Cloud technologies are advancing at an accelerating pace, supplanting traditional relational and data warehouse storage solutions with novel, high-value alternatives. Now, three pioneering Azure Data consultants offer an expert introduction to the relational, non-relational, and data warehouse solutions offered by the Azure platform. Drawing on their extensive experience helping organizations get more value from the Microsoft Data Platform, the authors guide you through decision-making, implementation, operations, security, and more. Throughout, step-by-step tutorials and hands-on exercises prepare you to succeed, even if you have no cloud data experience. Three leading experts in Microsoft Azure Data Solutions show how to: Master essential concepts of data storage and processing in cloud environments; Handle the changing responsibilities of data engineers moving to the cloud; Get started with Azure data storage accounts and other data facilities; Walk through implementing relationa ...
Microsoft Office Inside Out
Dive into the Microsoft Office application suiteand really put its productivity tools and services to work for you! This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Offices most powerful tools for productivity and decision-making. Renowned Office expert Joe Habraken offers a complete tour of Microsoft Office, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, Publisher, the 365 Online apps, and more. Discover how experts tackle todays key tasksand challenge yourself to new levels of mastery. Create amazing content faster with Offices new features, tools, and shortcuts; Share, collaborate with, and secure Office files in the cloud; Organize, edit, and format complex documents with Microsoft Word; Build tables of contents, captions, indexes, and footnotes that automatically update; Efficiently enter and manage data in Excel workbooks, and format it for easy understanding; ...
Dive into the Microsoft Office application suiteand really put its productivity tools and services to work for you! This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Offices most powerful tools for productivity and decision-making. Renowned Office expert Joe Habraken offers a complete tour of Microsoft Office, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, Publisher, the 365 Online apps, and more. Discover how experts tackle todays key tasksand challenge yourself to new levels of mastery. Create amazing content faster with Offices new features, tools, and shortcuts; Share, collaborate with, and secure Office files in the cloud; Organize, edit, and format complex documents with Microsoft Word; Build tables of contents, captions, indexes, and footnotes that automatically update; Efficiently enter and manage data in Excel workbooks, and format it for easy understanding; ...
Microsoft Excel Inside Out
Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel and its latest innovations, from advanced analysis and visualizations to dashboards. Discover how experts tackle todays key tasksand challenge yourself to new levels of mastery. Save time with galleries, keyboard accelerators, and other shortcuts; Enter formulas more efficiently, and fully control operators and dates; Use new data types to return photos, arrays, or weather history and even create your own; Master Excels most widely-used functions; Integrate external data from the web and other sources; Use the new XLOOKUP function to retrieve data more efficiently, with fewer errors; Store powerful specia ...
Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel and its latest innovations, from advanced analysis and visualizations to dashboards. Discover how experts tackle todays key tasksand challenge yourself to new levels of mastery. Save time with galleries, keyboard accelerators, and other shortcuts; Enter formulas more efficiently, and fully control operators and dates; Use new data types to return photos, arrays, or weather history and even create your own; Master Excels most widely-used functions; Integrate external data from the web and other sources; Use the new XLOOKUP function to retrieve data more efficiently, with fewer errors; Store powerful specia ...
Microsoft Blazor, 3rd Edition
Build web applications in C# and Microsoft .NET 6 that run in any modern browser and become a full-stack web developer!. Do all these things using the Microsoft Blazor framework and the techniques shown in this book. New in this edition is coverage of the new and improved Razor syntax, communication with the server using SignalR and/or gRPC, the use of virtualization to load large quantities of data efficiently, deployment and ahead-of-time compilation into WASM, new unit testing features, security using OpenID Connect, and more. Reading this book helps you learn to build user interfaces and present data to a user for display and modification, capturing the user's changes via data binding. The book shows how to access a rich library of .NET functionality such as a component model for building a composable user interface, including how to develop reusable components that can be used across many pages and websites. Also covered is data exchange with a server using REST, SignalR, and ...
Build web applications in C# and Microsoft .NET 6 that run in any modern browser and become a full-stack web developer!. Do all these things using the Microsoft Blazor framework and the techniques shown in this book. New in this edition is coverage of the new and improved Razor syntax, communication with the server using SignalR and/or gRPC, the use of virtualization to load large quantities of data efficiently, deployment and ahead-of-time compilation into WASM, new unit testing features, security using OpenID Connect, and more. Reading this book helps you learn to build user interfaces and present data to a user for display and modification, capturing the user's changes via data binding. The book shows how to access a rich library of .NET functionality such as a component model for building a composable user interface, including how to develop reusable components that can be used across many pages and websites. Also covered is data exchange with a server using REST, SignalR, and ...
Design and Deploy Microsoft Azure Virtual Desktop
Design and build the new desktop service from Microsoft. This book offers a modern framework, design methodology, and best practices of design and deployment for virtual apps and desktops. Microsoft Azure Virtual Desktop (AVD) is a Desktop as a Service (DaaS) which is simple to deploy, accessible from any device, easy to manage, and secure. The book starts with AVD essentials and its critical features, followed by the planning and method of preparing for AVD. You will go through defining the requirements and assessing by setting the AVD application baseline, network requirements, and security requirements. Next, you will learn how to design and deploy the core infrastructure of Microsoft AVD to understand its Access Layer, Control Layer, Resource Layer, Hosting Layer, and User Layer. You will also learn how to design the desktop and Host Pool of AVD. And you will learn the modern way to manage and secure AVD components. After reading this book, you will have the right blend of kn ...
Design and build the new desktop service from Microsoft. This book offers a modern framework, design methodology, and best practices of design and deployment for virtual apps and desktops. Microsoft Azure Virtual Desktop (AVD) is a Desktop as a Service (DaaS) which is simple to deploy, accessible from any device, easy to manage, and secure. The book starts with AVD essentials and its critical features, followed by the planning and method of preparing for AVD. You will go through defining the requirements and assessing by setting the AVD application baseline, network requirements, and security requirements. Next, you will learn how to design and deploy the core infrastructure of Microsoft AVD to understand its Access Layer, Control Layer, Resource Layer, Hosting Layer, and User Layer. You will also learn how to design the desktop and Host Pool of AVD. And you will learn the modern way to manage and secure AVD components. After reading this book, you will have the right blend of kn ...
Game Development with Unity for .NET Developers
Understand what makes Unity the world's most widely used real-time 3D development platform and explore its powerful features for creating 3D and 2D games, as well as the Unity game engine and the Microsoft Game Dev, including the Microsoft Azure Cloud and Microsoft Azure PlayFab services, to create games. You will start by getting acquainted with the Unity editor and the basic concepts of Unity script programming with C#. You'll then learn how to use C# code to work with Unity's built-in modules, such as UI, animation, physics, video, and audio, and understand how to develop a game with Unity and C#. As you progress through the chapters, you'll cover advanced topics such as the math involved in computer graphics and how to create a custom render pipeline in Unity with the new Scriptable Render Pipeline, all while optimizing performance in Unity. Along the way, you'll be introduced to Microsoft Game Dev, Azure services, and Azure PlayFab, and using the Unity3D PlayFab SDK to access t ...
Understand what makes Unity the world's most widely used real-time 3D development platform and explore its powerful features for creating 3D and 2D games, as well as the Unity game engine and the Microsoft Game Dev, including the Microsoft Azure Cloud and Microsoft Azure PlayFab services, to create games. You will start by getting acquainted with the Unity editor and the basic concepts of Unity script programming with C#. You'll then learn how to use C# code to work with Unity's built-in modules, such as UI, animation, physics, video, and audio, and understand how to develop a game with Unity and C#. As you progress through the chapters, you'll cover advanced topics such as the math involved in computer graphics and how to create a custom render pipeline in Unity with the new Scriptable Render Pipeline, all while optimizing performance in Unity. Along the way, you'll be introduced to Microsoft Game Dev, Azure services, and Azure PlayFab, and using the Unity3D PlayFab SDK to access t ...