Microsoft Excel Functions and Formulas. Master Excel Formulas and Functions for Efficient Data Management With Excel 2021/Microsoft 365

Mercury Learning and Information, Brian Moriarty, Bernd Held, Theodor Richardson

In this updated edition for Excel 2021, Microsoft 365, and previous versions, this book reveals the secrets of Excel through practical examples in a quick reference format. It includes new chapters on data analytics and shortcut keys, making it an essential resource for both beginners and experienced users. The book is designed to help you understand, create, and apply formulas efficiently.The journey begins with an introduction to formulas, followed by chapters on logical, text, date, and time functions. You will explore statistical, mathematical, and financial functions, along with database, lookup, and reference functions. The book also delves into conditional formatting, dynamic array formulas, special solutions, and user-defined functions, providing step-by-step instructions and ready-to-use Excel screenshots.By the end of the course, you will have mastered Excel's advanced formulas and functions, enabling you to perform complex data analysis and enhance your productivity. Companion files include video tutorials, over 250 worksheet examples, and all figures from the text, ensuring a comprehensive learning experience.

Microsoft Access 2021 Programming Pocket Primer. A Comprehensive Guide to Mastering Access VBA

Mercury Learning and Information, Julitta Korol

This book, part of the successful Pocket Primer series, is designed for those who need to master Access programming fundamentals quickly. You only need this concise guide to get started and feel comfortable with VBA. The concepts learned here also apply to Excel programming. The book is divided into nine chapters, each progressively introducing you to programming in Microsoft Access 2021.Beginning with an introduction to Access VBA, the book covers the Visual Basic Editor, fundamental VBA programming concepts, and how to create both built-in and custom functions. You will learn to add decision-making capabilities and repeating actions to your programs, manage multiple values using arrays and collections, and utilize built-in tools for testing and debugging your code.This structured approach ensures that by the end of the course, you will have a solid foundation in Access programming. The companion files provide all the hands-on resources needed to complete chapter projects, making this an essential resource for mastering Access VBA efficiently and effectively.

Data Wrangling Using Pandas, SQL, and Java. A Comprehensive Guide to Data Cleaning and Transformation

Mercury Learning and Information, Oswald Campesato

This book is designed for aspiring data scientists and those involved in data cleaning. It covers features of NumPy and Pandas, along with creating databases and tables in MySQL. It also addresses various data wrangling tasks using Python scripts and awk-based shell scripts. Companion files with code are available from the publisher.Understanding data cleaning and manipulation is vital for data scientists. This book provides a comprehensive introduction to essential tools and techniques. From Python basics to advanced data wrangling, it equips readers with the skills needed to manage and clean data effectively.The journey begins with an introduction to Python and progresses through working with data, Pandas, and SQL. It also covers Java, JSON, XML, and specific data cleaning tasks. The book culminates with detailed data wrangling techniques, ensuring readers gain practical, hands-on experience in data management.

Blockchain, Bitcoin, and the Digital Economy. Unlocking the Future of Financial Technology

Mercury Learning and Information, Len Mei

This book provides a comprehensive introduction to blockchain technology, discussing its fundamentals, development issues, potential applications, security, and use in cryptocurrency. It also delves into fintech, its current status, and related concepts in the digital economy. The rapidly changing nature of these topics makes the book a valuable resource for anyone interested in blockchain and cryptocurrency. Numerous references offer up-to-date information on these subjects.The course begins with an overview of blockchain and its basic concepts, followed by an in-depth look at Bitcoin and its associated issues. The journey continues with consensus mechanisms, exploring altcoins, and mutual distributed ledgers. The book then shifts focus to applications of blockchain beyond cryptocurrency, highlighting industrial uses, payment systems, and lending. Governance, regulation, and future trends in blockchain technology are also covered.Understanding these concepts is crucial for navigating the evolving landscape of blockchain and cryptocurrency. This book ensures a smooth transition from novice to knowledgeable enthusiast, equipping readers with practical insights and comprehensive knowledge. By the end, readers will grasp blockchain technology's impact on various industries and its potential for future innovations.

Data Structures and Program Design Using C++. A Self-Teaching Introduction to Data Structures and C++

Mercury Learning and Information, D. Malhotra, N. Malhotra

This book introduces the fundamentals of data structures using C++ in a self-teaching format. It covers managing large amounts of information, SEO, and creating Internet/Web indexing services. Practical analogies with real-world applications help explain technical concepts. The book includes end-of-chapter exercises such as programming tasks, theoretical questions, and multiple-choice quizzes.The course starts with an introduction to data structures and the C++ language, progressing through arrays, linked lists, queues, searching and sorting, stacks, trees, multi-way search trees, hashing, files, and graphs. Each chapter builds on the previous one, ensuring a comprehensive understanding of data structures.Understanding these concepts is crucial for managing large databases and optimizing web services. This book guides readers from basic to advanced data structure techniques, blending theoretical knowledge with practical skills. Companion files with source code and data sets enhance the learning experience, making this book an essential resource for mastering data structures with C++.

The Creation of a Conscious Machine. The AI Quest: Building Awareness with Advanced Artificial Intelligence Technologies

Mercury Learning and Information, Jean E. Tardy

This book delves into Generative AI and the potential for AI to achieve consciousness. It covers historical and modern perspectives on AI, from ancient myths to the Turing Test and current advancements. The book explores the theoretical and practical aspects of creating a conscious AI, including specifications for synthetic consciousness and integrating AI with human cognition. It questions whether generative AI can meet traditional criteria of consciousness.The journey begins with understanding consciousness, tracing AI's origins, and clarifying human cognition through AI. It examines early AI failures, fears of success, and the engineering of consciousness. The book also explores archaic AI representations, the intelligence of automatons, and the relevance of the Turing Test, concluding with strategies for achieving synthetic consciousness.These concepts are crucial for advancing AI towards synthetic consciousness. This book transitions readers from historical perspectives to modern AI challenges, blending theory with practical insights. It is an essential resource for understanding the future of AI and its potential to achieve consciousness.

WORKING WITH grep, sed, AND awk Pocket Primer. A Quick Guide to Mastering Powerful Command Line Tools

Mercury Learning and Information, Oswald Campesato

This book introduces readers to three powerful command-line utilities—grep, sed, and awk—that can create simple yet powerful shell scripts. Using the bash shell, it focuses on small text files to help readers understand these tools. Grep searches for patterns in data, sed modifies data, and awk performs tasks on pattern matches. Aimed at those new to the bash environment, the book is also valuable for those with some experience.The journey starts with grep, teaching how to search for specific words or patterns in data. It then moves to sed, showing how to change or modify data efficiently. Finally, it delves into awk, a versatile programming language for searching and processing data files. The book also includes a chapter on using regular expressions with these tools, enhancing your scripting capabilities.Mastering these utilities is crucial for efficient data handling and automation in a bash environment. This book transitions readers from basic to advanced command-line skills, blending theory with practical examples. It is an essential resource for anyone looking to harness the full power of bash scripting.

Computational Physics. A Comprehensive Guide to Numerical Methods in Physics

Mercury Learning and Information, Darren Walker

This updated edition introduces computational physics for performing experiments on the computer. It provides a grounding in scientific programming with examples in the context of physics problems. Using C++ as the primary language, it covers interpolation, integration, and solving differential equations, from simple concepts to advanced topics. The book includes a chapter on high-performance computing and parallel programming.Understanding computational physics is crucial for data manipulation and real-world simulations. The book starts with introductory topics and progresses to advanced material, including a C++ library and sample programs. Readers will learn problem-solving methods and constructing models.This journey equips readers with skills for scientific tasks, demonstrating efficient problem-solving and model construction. The practical approach ensures users can apply these concepts in real-world scenarios, making it an essential resource for those interested in computational physics.