Microsoft books

Complete guide to Excel Key Features Basic components of excel, the available menu options and tools, some customizations, working with multiple workbooks and worksheets. An initial introduction to what are formulas, functions, and their components. Usage of multiple examples to explain the application in real world scenario. Explaining of different chart types available in Excel. Different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends. Description The first version of MS Excel was released in 1985 and was widely adopted across the globe and became the most prolific and important programs for over 750 million users. Many people assume that Excel is only used by accountants, analysts, scientists and other similar professions that points to the fact that there is a real problem with the understanding of what in this book. Through this book, we will explain why Excel is such an amazing program and why it can do so much more than you think. What are the main uses of Excel and how can this help my business? Excel enables any format of information to be organized in a spreadsheet and its innate flexibility as a program, you can define and structure the layout according to how you want to manage it. It allows for over 1 million rows by over 16,000 columns of data to be managed, which shows how Excel is advancing as a business tool. This allows Excel to be used for a large variety of business purposes. What You Will Learn New to Excel 2016 or upgrading from a previous version? Use this guide to learn the basics and advance features of Excel. This user guide will introduce you to some of Excel’s 2016 more complex functionality, such as: Use Conditional Logic in a formula IF statements Use the SumIF and CountIF functions Produce a chart Sort and filter Apply subtotals Data Validation What-if-Analysis Tools Introduction to Pivot Tables Introduction to Macros Advanced Image Processing Operations Who This Book is For Anyone who wants to learn Excel, do the mundane task easily and quickly, do complex calculations, analysis huge data from internal or external sources, take decisions based on predictions, do forecasting, create plans and charts, monitor dashboards for progress and status, and so on. Table of Contents 1. Overview of Excel 2016 2. Cell References and Range 3. Working with Formulas and Functions 4. Data Validation 5. Protection 6. Sorting a Database 7. Filtering a Database 8. Subtotals 9. Pivot Tables 10. Conditional formatting 11. What-if-Analysis Tools 12. Working with Multiple Worksheets, Workbooks and Applications 13. Working with Charts 14. Macros About the Author Ritu Arora, is a certified MS Excel 2016 corporate trainer having more than 14 years of experience. She has conducted more than 1,000 corporate trainings on Advance Excel and trained more than 10000 people. Linkedin profile: linkedin.com/in/ritu-arora-29019a13

Discover blueprints that explore various components of Blazor, C#, and .NET to help you build web apps without learning JavaScriptKey FeaturesExplore complete, easy-to-follow web projects using BlazorBuild projects such as a weather app, expense tracker, and Kanban board with real-world applicationsUnderstand and work with Blazor WebAssembly effectively without spending too much time focusing on the theoryBook DescriptionBlazor WebAssembly makes it possible to run C# code on the browser instead of having to use JavaScript, and does not rely on plugins or add-ons. The only technical requirement for using Blazor WebAssembly is a browser that supports WebAssembly, which, as of today, all modern browsers do. Blazor WebAssembly by Example is a project-based guide for learning how to build single-page web applications using the Blazor WebAssembly framework. This book emphasizes the practical over the theoretical by providing detailed step-by-step instructions for each project. You'll start by building simple standalone web applications and progress to developing more advanced hosted web applications with SQL Server backends. Each project covers a different aspect of the Blazor WebAssembly ecosystem, such as Razor components, JavaScript interop, event handling, application state, and dependency injection. The book is designed in such a way that you can complete the projects in any order. By the end of this book, you will have experience building a wide variety of single-page web applications with .NET, Blazor WebAssembly, and C#.What you will learnDiscover the power of the C# language for both server-side and client-side web developmentUse the Blazor WebAssembly App project template to build your first Blazor WebAssembly applicationUse templated components and the Razor class library to build and share a modal dialog boxUnderstand how to use JavaScript with Blazor WebAssemblyBuild a progressive web app (PWA) to enable native app-like performance and speedUnderstand dependency injection (DI) in .NET to build a shopping cart appGet to grips with .NET Web APIs by building a task manager appWho this book is forThis book is for .NET web developers who are tired of constantly learning new JavaScript frameworks and wish to write web applications using Blazor WebAssembly, leveraging the power of .NET and C#. The book assumes beginner-level knowledge of the C# language, .NET framework, Microsoft Visual Studio, and web development concepts.

Understanding the new Microsoft Extension model for development Key Features Develop solutions for Dynamics 365 Business Central Orient yourself with the new Microsoft Extension model for development Learn modern ways to develop with Dynamics 365 Business Central Book Description Microsoft Dynamics 365 Business Central is the new SaaS ERP proposition from Microsoft. This latest version has many exciting features guaranteed to make your life easier. This book is an ideal guide to Dynamics 365 Business Central and will help you get started with implementing and designing solutions for real-world scenarios. This book will take you through the fundamental topics for implementing solutions based on Dynamics 365 Business Central (on-premise and SaaS). We'll see the core topics of the new development model (based on extensions) and we'll see how to create applications with the new Microsoft ERP proposition. The book begins by explaining the basics of Dynamics 365 Business Central and the Microsoft ERP proposition. We will then cover topics such as extensions, the new modern development model of Visual studio code, sandboxes, Docker, and many others. By the end of the book, you will have learned how to debug and compile extensions and to deploy them to the cloud and on-premise.You will also have learned how to create serverless business processes for Microsoft Dynamics 365 Business Central. What you will learn Develop solutions for Dynamics 365 Business Central Create a sandbox for extensions development (local or on cloud) Use Docker with Dynamics 365 Business Central Create extensions for Dynamics 365 Business Central Handle dependencies, translations and reporting Deploy extensions on-premise and to the cloud Create serverless processes with Dynamics 365 Business Central Understand source code management for AL Who this book is for This book is for Microsoft Dynamics 365 Business Central solution developers and architects that needs to implement solutions based on the Microsoft's ERP (on-premise and SaaS).

Discover the benefits of regularized programming by implementing Bosque to build a variety of reliable appsKey FeaturesGet up and running with the Bosque programming language and use it to build better softwareStreamline your app development and improve productivity using Bosque programmingEliminate sources of complexity such as loops, recursion, and invariants to develop quality productsBook DescriptionBosque is a new high-level programming language inspired by the impact of structured programming in the 1970s. It adopts the TypeScript syntax and ML semantics and is designed for writing code that is easy to reason about for humans and machines. With this book, you'll understand how Bosque supports high productivity and cloud-first development by removing sources of accidental complexity and introducing novel features. This short book covers all the language features that you need to know to work with Bosque programming. You'll learn about basic data types, variables, functions, operators, statements, and expressions in Bosque and become familiar with advanced features such as typed strings, bulk algebraic data operations, namespace declarations, and concept and entity declarations. This Bosque book provides a complete language reference for learning to program with Bosque and understanding the regularized programming paradigm. You'll also explore real-world examples that will help you to reinforce the knowledge you've acquired. Additionally, you'll discover more advanced topics such as the Bosque project structure and contributing to the project. By the end of this book, you'll have learned how to configure the Bosque environment and build better and reliable software with this exciting new open-source language.What you will learnFind out what the Bosque project isIdentify accidental complexity in code and how to overcome it with BosqueUnderstand the principles of the regularized programming paradigmInstall and configure the Bosque environmentGet hands-on experience using the Bosque language and its key featuresRecognize the advantages of explicit code intermediate representation designWho this book is forThis book is for experienced developers and early adopters who are interested in learning a new, mindset-changing programming language. You'll also find this book useful if you know TypeScript or JavaScript programming and want to understand the advantages of Bosque compared to other programming languages. Experience with any programming language and knowledge of various programming paradigms such as structured programming and functional programming are required to get started with this book.

Implement rich Azure SAAS-PAAS-IAAS ecosystems using containers, serverless services, and storage solutions Key Features This book starts from basic fundamentals and takes you to a professional level. Books emphasize on the real-liferoject use case and in-depth implementation. Books starts right from scratch with creation of Azure account to manually creating Azure resources and deploying them. Exclusive topics are dedicated for Azure Web App, Web Job, Cloud Service (Web Role, Worker Role), Azure functions. All practical implementation of Azure services (PASS, Server less computing) are covered. Description Book explains Azure services offerings to advance resource creation to see how all the moving parts go together. It walks through various cloud development tools which will speed our development process. Books majorly cover practical information to get you started to a Proficient level and towards cloud mindset, Azure Cloud offers enormous services to solve your problem in this modern world. Microsoft Azure has Web, Mobile, Big Data, IoT, AI + Machine Learning, Storage, Database, and so on. We will be going through some of these available services to solve our business problem in this book. If you are a .NET developer who wants to learn Microsoft Azure and want to have cloud mindset, this book is for you. Cloud application development requires a Cloud mindset. Cloud mindset is developed by gradually going through all the available services provided by Microsoft Azure and using the best fit solution for your problem. “If you are C# DEVELOPER who wants to start with Azure, then this book is for you." What You Will Learn Azure and Services Offered for .NET Developers To create Free Azure Account and Web App Service on Azure Creating and Deploying a Sample ASP.NET Core on Azure Web App. Creating and Running a Background Job with help of Web Jobs on Azure Creating and Running a Service Bus Triggered Web Jobs on Azure to send mail to the Customer using Send Grid Creating your first Cloud Service app on Azure Who This Book is For Students of Polytechnic Diploma Classes- Computer Science/ Information Technology Graduate Students- Computer Science/ CSE / IT/ Computer Applications Master Class Students—Msc (CS/IT)/ MCA/ M.Phil, M.Tech, M.S. .NET developer, C# developer Table of Contents 1. The Era of Data Center 2. Abstract 3. Introduction Day 1: Understanding Azure and Services Offered for .NET Developers Day 2: Creating your Free Azure Account and Create Your First Web App Service on Azure Day 3: Creating and Deploying a Sample ASP.NET Core on Azure Web App. Day 4: Creating and Running a Background Job with help of Web Jobs on Azure Day 5: Creating and Running a Service Bus Triggered Web Jobs on Azure to send mail to the Customer using Send Grid Day 6: Creating your first Cloud Service app on Azure Day 7: Logic/Function as a Service Often Termed has Serverless Computing, Creating your First Azure Function on Microsoft Azure References About the Author Saillesh Pawar is a Senior Consultant working on .NET Web Technologies for five years. Writing this book has been a big responsibility in order to demonstrate easy and real-life implementation of Azure services. LinkedIn: linkedin.com/in/saillesh-pawar-44721a24 Website: sailleshpawar.wordpress.com

Leverage the power of SQL Server 2017 Integration Services to build data integration solutions with ease Key Features Work with temporal tables to access information stored in a table at any time Get familiar with the latest features in SQL Server 2017 Integration Services Program and extend your packages to enhance their functionality Book Description Microsoft SQL Server 2017 uses the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. By learning how to use the features of SQL Server 2017 effectively, you can build scalable apps and easily perform data integration and transformation. You'll start by brushing up on the features of SQL Server 2017. This Learning Path will then demonstrate how you can use Query Store, columnstore indexes, and In-Memory OLTP in your apps. You'll also learn to integrate Python code in SQL Server and graph database implementations for development and testing. Next, you'll get up to speed with designing and building SQL Server Integration Services (SSIS) data warehouse packages using SQL server data tools. Toward the concluding chapters, you'll discover how to develop SSIS packages designed to maintain a data warehouse using the data flow and other control flow tasks. By the end of this Learning Path, you'll be equipped with the skills you need to design efficient, high-performance database applications with confidence. This Learning Path includes content from the following Packt books: SQL Server 2017 Developer's Guide by Milos Radivojevic, Dejan Sarka, et. al SQL Server 2017 Integration Services Cookbook by Christian Cote, Dejan Sarka, et. al What you will learn Use columnstore indexes to make storage and performance improvements Extend database design solutions using temporal tables Exchange JSON data between applications and SQL Server Migrate historical data to Microsoft Azure by using Stretch Database Design the architecture of a modern Extract, Transform, and Load (ETL) solution Implement ETL solutions using Integration Services for both on-premise and Azure data Who this book is for This Learning Path is for database developers and solution architects looking to develop ETL solutions with SSIS, and explore the new features in SSIS 2017. Advanced analysis practitioners, business intelligence developers, and database consultants dealing with performance tuning will also find this book useful. Basic understanding of database concepts and T-SQL is required to get the best out of this Learning Path.

Modernize your apps with Microsoft Azure by moving web, desktop, and mobile apps to the cloud Key Features Decide which migration strategy is most suitable for your organization and create a migration roadmap Move existing infrastructure to Azure and learn strategies to reduce cost, increase storage, and improve ROI Design secure, scalable, and cost-effective solutions with the help of practical examples Book Description Whether you are trying to re-architect a legacy app or build a cloud-ready app from scratch, using the Azure ecosystem with .NET and Java technologies helps you to strategize and plan your app modernization process effectively. With this book, you'll learn how to modernize your applications by using Azure for containerization, DevOps, microservices, and serverless solutions to reduce development time and costs, while also making your applications robust, secure, and scalable. You will delve into improving application efficiency by using container services such as Azure Container Service, Azure Kubernetes Service (AKS), and more. Next, you will learn to modernize your application by implementing DevOps throughout your application development life cycle. You will then focus on increasing the scalability and performance of your overall application with microservices, before learning how to add extra functionality to your application with Azure serverless solutions. Finally, you'll get up to speed with monitoring and troubleshooting techniques. By the end of this book, you will have learned how to use the Azure ecosystem to refactor, re-architect, and rebuild your web, mobile, and desktop applications. What you will learn Use DevOps and containerization technologies to modernize your applications and infrastructure Build microservices using Azure Service Fabric Develop scalable applications using Azure Functions Manage and deploy your application code and database connectivity Secure and monitor your applications in Azure effectively Design for high availability and disaster recovery Who this book is for This book is for.NET and Java developers who want to modernize their applications using Azure. Solution architects and experienced developers interested in modernizing legacy applications using Azure will also find this book useful. Some prior understanding of cloud computing concepts will be beneficial.

Explore the fundamentals of Dynamics 365 Business Central and the Visual Studio Code development environment with the help of useful examples and case studies Key Features Tailor your applications to best suit the needs of your business Explore the latest features of Business Central with examples curated by industry experts Integrate Business Central features in your applications with this comprehensive guide Book Description Microsoft Dynamics 365 Business Central is a full ERP business solution suite with a robust set of development tools to support customization and enhancement. These tools can be used to tailor Business Central's in-built applications to support complete management functions for finance, supply chain, manufacturing, and operations. Using a case study approach, this book will introduce you to Dynamics 365 Business Central and Visual Studio Code development tools to help you become a productive Business Central developer. You'll also learn how to evaluate a product's development capabilities and manage Business Central-based development and implementation. You'll explore application structure, the construction of and uses for each object type, and how it all fits together to build apps that meet special business requirements. By the end of this book, you'll understand how to design and develop high-quality software using the Visual Studio Code development environment, the AL language paired with the improved editor, patterns, and features. What you will learn Programming using the AL language in the Visual Studio Code development environment Explore functional design and development using AL How to build interactive pages and learn how to extract data for users How to use best practices to design and develop modifications for new functionality integrated with the standard Business Central software Become familiar with deploying the broad range of components available in a Business Central system Create robust, viable systems to address specific business requirements Who this book is for If you want to learn about Dynamics 365 Business Central's powerful and extensive built-in development capabilities, this is the book for you. ERP consultants and managers of Business Central development will also find this book helpful. Although you aren't expected to have worked with Dynamics Business Central, basic understanding of programming and familiarity with business application software will help you understand the concepts covered in this book.

Explore Xamarin.Forms to develop dynamic applications Key Features Explore SQLite through Xamarin to store locations for various location-based applications Make a real-time serverless chat service by using Azure SignalR service Build Augmented Reality application with the power of UrhoSharp together with ARKit and ARCore Book Description Xamarin.Forms is a lightweight cross-platform development toolkit for building applications with a rich user interface. In this book you'll start by building projects that explain the Xamarin.Forms ecosystem to get up and running with building cross-platform applications. We'll increase in difficulty throughout the projects, making you learn the nitty-gritty of Xamarin.Forms offerings. You'll gain insights into the architecture, how to arrange your app's design, where to begin developing, what pitfalls exist, and how to avoid them. The book contains seven real-world projects, to get you hands-on with building rich UIs and providing a truly cross-platform experience. It will also guide you on how to set up a machine for Xamarin app development. You'll build a simple to-do application that gets you going, then dive deep into building advanced apps such as messaging platform, games, and machine learning, to build a UI for an augmented reality project. By the end of the book, you'll be confident in building cross-platforms and fitting Xamarin.Forms toolkits in your app development. You'll be able to take the practice you get from this book to build applications that comply with your requirements. What you will learn Set up a machine for Xamarin development Get to know about MVVM and data bindings in Xamarin.Forms Understand how to use custom renderers to gain platform-specific access Discover Geolocation services through Xamarin Essentials Create an abstraction of ARKit and ARCore to expose as a single API for the game Learn how to train a model for image classification with Azure Cognitive Services Who this book is for This book is for mobile application developers who want to start building native mobile apps using the powerful Xamarin.Forms and C#. Working knowledge of C#, .NET, and Visual Studio is required.