Microsoft Excel 2019 Step by Step
Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers - brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for easier viewing; Perform calculations and find and correct errors; Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines; Visualize data with 3D maps, funnel charts, and other powerful tools; Import, process, summarize, and analyze huge datasets with Excel's improved PowerPivot and Power Query; Build powerful data models and use them in business intelligence; Look up just the tasks and lessons you need. ...
Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers - brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for easier viewing; Perform calculations and find and correct errors; Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines; Visualize data with 3D maps, funnel charts, and other powerful tools; Import, process, summarize, and analyze huge datasets with Excel's improved PowerPivot and Power Query; Build powerful data models and use them in business intelligence; Look up just the tasks and lessons you need. ...
Microsoft Office 2019 Step by Step
Get more done quickly with Office 2019. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. Covers Word, Excel, PowerPoint and Outlook; Format Word documents for maximum visual impact; Build powerful, reliable Excel workbooks for analysis and reporting; Prepare highly effective PowerPoint presentations; Use Outlook to organize your email, calendar, and contacts; Includes downloadable practice files. ...
Get more done quickly with Office 2019. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. Covers Word, Excel, PowerPoint and Outlook; Format Word documents for maximum visual impact; Build powerful, reliable Excel workbooks for analysis and reporting; Prepare highly effective PowerPoint presentations; Use Outlook to organize your email, calendar, and contacts; Includes downloadable practice files. ...
Microsoft Excel 2019 Pivot Table Data Crunching
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power - including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else. By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables; Control all future pivot tables using new pivot table defaults; Transform huge data sets into clear summary reports; Instantly ...
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power - including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else. By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables; Control all future pivot tables using new pivot table defaults; Transform huge data sets into clear summary reports; Instantly ...
Windows 10 Inside Out, 3rd Edition
Dive into Windows 10 - and really put your Windows expertise to work. Focusing on Windows 10's newest, most powerful, and most innovative features, this supremely organized reference packs hundreds of timesaving solutions, up-to-date tips, and workarounds. From the new Timeline to key improvements in Microsoft Edge, Cortana, security, and virtualization, you'll discover how experts tackle today's essential tasks. Adapt to faster change in today's era of “Windows as a service,” as you challenge yourself to new levels of mastery. Install, configure, and personalize the latest versions of Windows 10; Manage Windows reliability, security, and feature updates in any environment; Maximize your productivity with Windows 10's growing library of built-in apps; Pinpoint information fast with advanced Windows Search and Cortana techniques; Discover major Microsoft Edge enhancements, from extensions to accessibility; Use Cortana to perform tasks, set reminders, retrieve data, and get instan ...
Dive into Windows 10 - and really put your Windows expertise to work. Focusing on Windows 10's newest, most powerful, and most innovative features, this supremely organized reference packs hundreds of timesaving solutions, up-to-date tips, and workarounds. From the new Timeline to key improvements in Microsoft Edge, Cortana, security, and virtualization, you'll discover how experts tackle today's essential tasks. Adapt to faster change in today's era of “Windows as a service,” as you challenge yourself to new levels of mastery. Install, configure, and personalize the latest versions of Windows 10; Manage Windows reliability, security, and feature updates in any environment; Maximize your productivity with Windows 10's growing library of built-in apps; Pinpoint information fast with advanced Windows Search and Cortana techniques; Discover major Microsoft Edge enhancements, from extensions to accessibility; Use Cortana to perform tasks, set reminders, retrieve data, and get instan ...
Julia Programming Projects
Julia is a new programming language that offers a unique combination of performance and productivity. Its powerful features, friendly syntax, and speed are attracting a growing number of adopters from Python, R, and Matlab, effectively raising the bar for modern general and scientific computing. After six years in the making, Julia has reached version 1.0. Now is the perfect time to learn it, due to its large-scale adoption across a wide range of domains, including fintech, biotech, education, and AI. Beginning with an introduction to the language, Julia Programming Projects goes on to illustrate how to analyze the Iris dataset using DataFrames. You will explore functions and the type system, methods, and multiple dispatch while building a web scraper and a web app. Next, you'll delve into machine learning, where you'll build a books recommender system. You will also see how to apply unsupervised machine learning to perform clustering on the San Francisco business database. After ...
Julia is a new programming language that offers a unique combination of performance and productivity. Its powerful features, friendly syntax, and speed are attracting a growing number of adopters from Python, R, and Matlab, effectively raising the bar for modern general and scientific computing. After six years in the making, Julia has reached version 1.0. Now is the perfect time to learn it, due to its large-scale adoption across a wide range of domains, including fintech, biotech, education, and AI. Beginning with an introduction to the language, Julia Programming Projects goes on to illustrate how to analyze the Iris dataset using DataFrames. You will explore functions and the type system, methods, and multiple dispatch while building a web scraper and a web app. Next, you'll delve into machine learning, where you'll build a books recommender system. You will also see how to apply unsupervised machine learning to perform clustering on the San Francisco business database. After ...
Bayesian Analysis with Python, 2nd Edition
The 2nd edition of Bayesian Analysis with Python is an introduction to the main concepts of applied Bayesian inference and its practical implementation in Python using PyMC3, a state-of-the-art probabilistic programming library, and ArviZ, a new library for exploratory analysis of Bayesian models. The main concepts of Bayesian statistics are covered using a practical and computational approach. Synthetic and real data sets are used to introduce several types of models, such as generalized linear models for regression and classification, mixture models, hierarchical models, and Gaussian processes, among others. By the end of the book, you will have a working knowledge of probabilistic modeling and you will be able to design and implement Bayesian models for your own data science problems. After reading the book you will be better prepared to delve into more advanced material or specialized statistical modeling if you need to. ...
The 2nd edition of Bayesian Analysis with Python is an introduction to the main concepts of applied Bayesian inference and its practical implementation in Python using PyMC3, a state-of-the-art probabilistic programming library, and ArviZ, a new library for exploratory analysis of Bayesian models. The main concepts of Bayesian statistics are covered using a practical and computational approach. Synthetic and real data sets are used to introduce several types of models, such as generalized linear models for regression and classification, mixture models, hierarchical models, and Gaussian processes, among others. By the end of the book, you will have a working knowledge of probabilistic modeling and you will be able to design and implement Bayesian models for your own data science problems. After reading the book you will be better prepared to delve into more advanced material or specialized statistical modeling if you need to. ...
Learn Microsoft Azure
Azure is one of the leading public cloud service providers. Thanks to a number of Azure service updates, it continues to make advances in the realm of cloud computing. Learn Microsoft Azure starts with the fundamentals of cloud computing. You will learn to configure and set up the Azure infrastructure. As you make your way through the book, you'll explore Azure services, along with working on virtual memory systems (VMS) and deployment models. You will understand various services in the Azure ecosystem, such as Azure IoT and Azure Analytics, among others. An easy-to-follow introduction to various cloud design patterns will also add to your efficiency in designing cloud solutions. In the concluding chapters, you'll secure your virtual networks using Network security groups and configure Azure Active Directory (Azure AD) to set a custom domain name and company profile. ...
Azure is one of the leading public cloud service providers. Thanks to a number of Azure service updates, it continues to make advances in the realm of cloud computing. Learn Microsoft Azure starts with the fundamentals of cloud computing. You will learn to configure and set up the Azure infrastructure. As you make your way through the book, you'll explore Azure services, along with working on virtual memory systems (VMS) and deployment models. You will understand various services in the Azure ecosystem, such as Azure IoT and Azure Analytics, among others. An easy-to-follow introduction to various cloud design patterns will also add to your efficiency in designing cloud solutions. In the concluding chapters, you'll secure your virtual networks using Network security groups and configure Azure Active Directory (Azure AD) to set a custom domain name and company profile. ...
Hands-On System Programming with C++
C++ is a general-purpose programming language with a bias toward system programming as it provides ready access to hardware-level resources, efficient compilation, and a versatile approach to higher-level abstractions. This book will help you understand the benefits of system programming with C++17. You will gain a firm understanding of various C, C++, and POSIX standards, as well as their respective system types for both C++ and POSIX. After a brief refresher on C++, Resource Acquisition Is Initialization (RAII), and the new C++ Guideline Support Library (GSL), you will learn to program Linux and Unix systems along with process management. As you progress through the chapters, you will become acquainted with C++'s support for IO. You will then study various memory management methods, including a chapter on allocators and how they benefit system programming. You will also explore how to program file input and output and learn about POSIX sockets. This book will help you get to grips ...
C++ is a general-purpose programming language with a bias toward system programming as it provides ready access to hardware-level resources, efficient compilation, and a versatile approach to higher-level abstractions. This book will help you understand the benefits of system programming with C++17. You will gain a firm understanding of various C, C++, and POSIX standards, as well as their respective system types for both C++ and POSIX. After a brief refresher on C++, Resource Acquisition Is Initialization (RAII), and the new C++ Guideline Support Library (GSL), you will learn to program Linux and Unix systems along with process management. As you progress through the chapters, you will become acquainted with C++'s support for IO. You will then study various memory management methods, including a chapter on allocators and how they benefit system programming. You will also explore how to program file input and output and learn about POSIX sockets. This book will help you get to grips ...
Advanced R Statistical Programming and Data Models
Carry out a variety of advanced statistical analyses including generalized additive models, mixed effects models, multiple imputation, machine learning, and missing data techniques using R. Each chapter starts with conceptual background information about the techniques, includes multiple examples using R to achieve results, and concludes with a case study. Written by Matt and Joshua F. Wiley, Advanced R Statistical Programming and Data Models shows you how to conduct data analysis using the popular R language. You'll delve into the preconditions or hypothesis for various statistical tests and techniques and work through concrete examples using R for a variety of these next-level analytics. This is a must-have guide and reference on using and programming with the R language. Conduct advanced analyses in R including: generalized linear models, generalized additive models, mixed effects models, machine learning, and parallel processing; Carry out regression modeling using R data ...
Carry out a variety of advanced statistical analyses including generalized additive models, mixed effects models, multiple imputation, machine learning, and missing data techniques using R. Each chapter starts with conceptual background information about the techniques, includes multiple examples using R to achieve results, and concludes with a case study. Written by Matt and Joshua F. Wiley, Advanced R Statistical Programming and Data Models shows you how to conduct data analysis using the popular R language. You'll delve into the preconditions or hypothesis for various statistical tests and techniques and work through concrete examples using R for a variety of these next-level analytics. This is a must-have guide and reference on using and programming with the R language. Conduct advanced analyses in R including: generalized linear models, generalized additive models, mixed effects models, machine learning, and parallel processing; Carry out regression modeling using R data ...
The Joys of Hashing
Build working implementations of hash tables, written in the C programming language. This book starts with simple first attempts devoid of collision resolution strategies, and moves through improvements and extensions illustrating different design ideas and approaches, followed by experiments to validate the choices. Hash tables, when implemented and used appropriately, are exceptionally efficient data structures for representing sets and lookup tables, providing low overhead, constant time, insertion, deletion, and lookup operations. The Joys of Hashing walks you through the implementation of efficient hash tables and the pros and cons of different design choices when building tables. The source code used in the book is available on GitHub for your re-use and experiments. Master the basic ideas behind hash tables; Carry out collision resolution, including strategies for handling collisions and their consequences for performance; Resize or grow and shrink tables as needed; Sto ...
Build working implementations of hash tables, written in the C programming language. This book starts with simple first attempts devoid of collision resolution strategies, and moves through improvements and extensions illustrating different design ideas and approaches, followed by experiments to validate the choices. Hash tables, when implemented and used appropriately, are exceptionally efficient data structures for representing sets and lookup tables, providing low overhead, constant time, insertion, deletion, and lookup operations. The Joys of Hashing walks you through the implementation of efficient hash tables and the pros and cons of different design choices when building tables. The source code used in the book is available on GitHub for your re-use and experiments. Master the basic ideas behind hash tables; Carry out collision resolution, including strategies for handling collisions and their consequences for performance; Resize or grow and shrink tables as needed; Sto ...