Excel 2021 / Microsoft 365 Programming By Example. A Comprehensive Guide to Mastering Excel VBA

Mercury Learning and Information, Julitta Korol

Updated for Excel 2021, this book is a practical guide for those proficient with the Excel user interface and looking to automate routine tasks. It introduces programming concepts through numerous hands-on exercises, progressing to advanced topics via custom projects. The journey begins with recording and editing macros, writing VBA code, and extends to programming the Ribbon interface and working with XML documents. The course covers automating operations on files, folders, and other Microsoft Office applications. It also delves into event procedures, testing, and debugging. Advanced features include working with VBA classes and raising custom events in standalone class modules. By mastering these skills, users can significantly enhance their productivity and efficiency in Excel.The book's structure, with 29 chapters and over 275 examples, ensures comprehensive learning. Companion files with source code, projects, and figures further support the user. This course is essential for anyone aiming to streamline their Excel tasks and harness the full power of Excel programming.

Data Science Tools. Comprehensive Guide to Mastering Fundamental Data Science and Statistics Techniques

Mercury Learning and Information, Christopher Greco

This book introduces popular data science tools and guides readers on how to use them effectively. It covers data analysis using Microsoft Excel, KNIME, R, and OpenOffice, applying statistical concepts such as confidence intervals, normal distribution, T-Tests, linear regression, histograms, and geographic analysis with real data from Federal Government sources.The course begins with the basics, including importing data and conducting various statistical tests. It progresses to specific methods for each tool, ensuring a comprehensive understanding of data analysis. Capstone exercises provide hands-on experience, reinforcing the concepts learned throughout the book.Understanding these tools and concepts is crucial for effective data analysis. This book takes readers from the basics to advanced statistical methods, combining theoretical insights with practical applications. Companion files with source code and data sets enhance the learning experience, making this book an essential resource for mastering data analysis with popular software applications.

TensorFlow 2 Pocket Primer. A Quick Reference Guide for TensorFlow 2 Developers

Mercury Learning and Information, Oswald Campesato

As part of the best-selling *Pocket Primer* series, this book introduces beginners to basic machine learning algorithms using TensorFlow 2. It provides a fast-paced introduction to TensorFlow, covering core features and machine learning basics with Python code samples. An appendix includes Keras-based code samples and explores MLPs, CNNs, RNNs, and LSTMs. The chapters illustrate how to solve various tasks, encouraging further reading to deepen your knowledge.The journey begins with an introduction to TensorFlow 2, followed by essential APIs and datasets. You'll explore linear regression and classifiers, learning to apply TensorFlow to practical problems. The comprehensive appendix covers advanced topics like NLPs and deep learning architectures, enhancing your understanding of machine learning.Understanding these concepts is crucial for modern AI applications. This book transitions readers from basic TensorFlow use to advanced machine learning techniques, blending theory with practical examples. Companion files with source code and figures enhance learning, making this an essential resource for mastering TensorFlow and machine learning.

Industrial Automation and Robotics. A Comprehensive Guide to Automated Systems and Robotics

Mercury Learning and Information, Jean Riescher Westcott, A.K. Gupta, S.K. Arora

This course offers an introduction to automation and robotics for industrial applications. It begins with essential concepts of hydraulics and pneumatics, explaining their roles in industrial automation. Next, it delves into circuits and their applications in hydraulic, pneumatic, and fluidic design. The latter part focuses on electric and electronic controls, ending with robotics, robotic programming, and their industrial applications. Understanding these concepts is crucial for anyone looking to work in automation, as they provide the foundation for designing and maintaining automated systems. The course covers everything from basic laws and principles to advanced topics like the use of UAVs and AI in industrial automation.Throughout the course, you'll explore real-world applications and see how these principles are applied in industry. This structured approach ensures you gain a comprehensive understanding, from fundamental concepts to advanced automation and robotics techniques, preparing you for a career in this dynamic field.

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.

C Programming Pocket Primer. An Essential Guide to C Programming Basics

Mercury Learning and Information, Oswald Campesato

As part of the Pocket Primer series, this book provides an overview of major concepts in C programming. It covers essential techniques, including up-to-date information on the C11 standard and comprehensive chapters on pointers. Companion files with source code and figures from the book are included.The course begins with an introduction to C, moving through conditional logic, loops, and arrays. It then delves into functions and provides detailed coverage of pointers, essential for mastering C programming. Miscellaneous topics are also addressed to ensure a well-rounded understanding.Understanding these concepts is crucial for developing efficient C programs. This book transitions readers from beginners to proficient C programmers, combining theoretical knowledge with practical skills. Companion files enhance the learning experience, making this book an invaluable resource for mastering C programming.

Python for TensorFlow Pocket Primer. A Quick Guide to Python Libraries for TensorFlow Developers

Mercury Learning and Information, Oswald Campesato

As part of the best-selling *Pocket Primer* series, this book prepares programmers for machine learning and deep learning with TensorFlow. It begins with a quick introduction to Python, followed by chapters on NumPy, Pandas, Matplotlib, and scikit-learn. The final chapters provide TensorFlow 1.x code samples, including detailed examples for TensorFlow Dataset, crucial for TensorFlow 2.The journey starts with Python basics and progresses through essential data manipulation and visualization libraries. You'll explore machine learning fundamentals with scikit-learn before diving into TensorFlow, learning to construct data pipelines with TensorFlow Dataset APIs like map(), filter(), and batch().Understanding these concepts is vital for modern AI applications. This book transitions readers from basic programming to advanced machine learning and deep learning techniques, blending theory with practical skills. Companion files with source code enhance learning, making this an essential resource for mastering Python, machine learning, and TensorFlow.

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.

Computer Graphics Programming in OpenGL With C++ (Edition 3). Mastering 3D Graphics and Animation Techniques

Mercury Learning and Information, V. Scott Gordon, John L. Clevenger

This edition provides step-by-step instruction on modern OpenGL 4.0+ GLSL shader programming with C++, covering theoretical foundations of 3D computer graphics. Every shader stage is explored, from basics like modeling, textures, lighting, and shadows, to advanced techniques such as tessellation, noise maps, water, and stereoscopy. Expanded coverage includes camera control, refraction, and ray tracing with bounding volume hierarchies. Companion files include source code, shaders, model files, and skyboxes for all examples in the book.Understanding these concepts is crucial for creating sophisticated 3D graphics applications. The course begins with OpenGL basics and pipeline understanding, followed by mathematical foundations and managing 3D graphics data. It covers texture mapping, 3D models, lighting, shadows, enhancing surface detail, and advanced topics like parametric surfaces, tessellation, and geometry shaders. Final chapters delve into simulating water, ray tracing, and stereoscopy for 3D graphics.This book equips readers with the knowledge to master OpenGL programming and 3D graphics, making it invaluable for developers and enthusiasts aiming to advance their skills. The practical approach and comprehensive examples ensure thorough learning, bridging the gap between theory and real-world application.

Surviving A Cyberattack. A Comprehensive Guide to Digital Security for Families and Businesses

Mercury Learning and Information, Todd G. Shipley, Art Bowker

This essential guide empowers individuals, families, and small business owners to secure their digital environments. Beginning with the basics of cybersecurity, it explores practical strategies for protecting social media, safeguarding family members, and securing online transactions. Readers will learn actionable techniques to defend against cyber threats and protect digital assets.With dedicated chapters on small business security, responding to cyberattacks, and navigating future digital trends, this book delivers practical, step-by-step advice. It ensures readers are equipped to tackle the challenges of modern digital security with confidence and clarity.By the end, readers will gain the skills to identify threats, respond effectively, and build a safer digital presence for themselves and their loved ones. This guide is perfect for anyone seeking to enhance their online security, regardless of prior experience.

Game Development Using Python. Mastering Interactive Game Creation and Development through Python

Mercury Learning and Information, James R. Parker

This book guides you through the basic game development process using Python, covering essential topics such as graphics, sound, artificial intelligence, animation, and game engines. Real games are created as you progress through the text, and significant parts of a game engine are built and made available for download. New chapters on card games and a side-scroller are included. The companion files contain all the resources described in the book, including example code, game assets, video/sound editing software, and color figures.The course begins with an introduction to how games work, followed by in-depth chapters on graphics and images, the game loop, and game AI, specifically focusing on collision detection. It then moves on to navigation, control, and sound, guiding you through creating a jet boat race game. Advanced topics such as animation, networking, and platformers are covered, providing a comprehensive understanding of game development.Designed for both beginners and those with some experience, this book equips readers with the skills needed to develop their own games. It emphasizes practical application, ensuring you can implement what you learn. By the end of the course, you will have a solid foundation in game development and the ability to create engaging, interactive games using Python.

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

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

This book, part of the Pocket Primer series, introduces the basic concepts of data science using Python 3 and other applications. It offers a fast-paced introduction to data analytics, statistics, data visualization, linear algebra, and regular expressions. The book features numerous code samples using Python, NumPy, R, SQL, NoSQL, and Pandas. Companion files with source code and color figures are available.Understanding data science is crucial in today's data-driven world. This book provides a comprehensive introduction, covering key areas such as Python 3, data visualization, and statistical concepts. The practical code samples and hands-on approach make it ideal for beginners and those looking to enhance their skills.The journey begins with working with data, followed by an introduction to probability, statistics, and linear algebra. It then delves into Python, NumPy, Pandas, R, regular expressions, and SQL/NoSQL, concluding with data visualization techniques. This structured approach ensures a solid foundation in data science.

Data Literacy With Python. A Comprehensive Guide to Understanding and Analyzing Data with Python

Mercury Learning and Information, Oswald Campesato

This book ushers readers into the world of data, emphasizing its importance in modern industries and how its management leads to insightful decision-making. Using Python 3, the book introduces foundational data tasks and progresses to advanced model training concepts. Detailed, step-by-step Python examples help readers master training models, starting with the kNN algorithm and moving to other classifiers with minimal code adjustments. Tools like Sweetviz, Skimpy, Matplotlib, and Seaborn are introduced for hands-on chart and graph rendering.The course begins with working with data, detecting outliers and anomalies, and cleaning datasets. It then introduces statistics and progresses to using Matplotlib and Seaborn for data visualization. Each chapter builds on the previous one, ensuring a comprehensive understanding of data management and analysis.These concepts are crucial for making data-driven decisions. This book transitions readers from basic data handling to advanced model training, blending theoretical knowledge with practical skills. Companion files with source code and data sets enhance the learning experience, making this book an invaluable resource for mastering data science with Python.

Enterprise Transformation to Artificial Intelligence and the Metaverse. Strategies for the Technology Revolution: Navigating Future Technologies with Agility and Innovation

Mercury Learning and Information, William Kimmerly

This book guides organizations in effectively responding to the metaverse, a rapidly converging collection of advanced technologies, methods, and models. The metaverse is poised to be as disruptive as the personal computer, Internet, and smartphone, impacting personal, social, professional, and business lives. The book covers essential metaverse technologies and concepts, helping organizational leaders plan their transformation strategies.The journey begins with an introduction and key definitions, followed by the evolution of IT governance and responses to disruptive technologies. It delves into AI, machine learning, blockchain, platforms, algorithms, edge computing, quantum computing, and immersive technologies like VR, AR, MR, and XR. Further chapters explore holographic technologies, deep tech, and other metaverse-related technologies, along with organizational structures and governance frameworks for the metaverse era.Understanding these concepts is crucial for navigating the metaverse transformation. The book concludes with a detailed hypothetical case study, illustrating how such a transformation can be achieved. This resource helps executives and professionals chart an effective course to the metaverse, blending theoretical insights with practical applications.

Data Science Fundamentals Pocket Primer. An Essential Guide to Data Science Concepts and Techniques

Mercury Learning and Information, Oswald Campesato

This book, part of the Pocket Primer series, introduces the basic concepts of data science using Python 3 and other applications. It offers a fast-paced introduction to data analytics, statistics, data visualization, linear algebra, and regular expressions. The book features numerous code samples using Python, NumPy, R, SQL, NoSQL, and Pandas. Companion files with source code and color figures are available.Understanding data science is crucial in today's data-driven world. This book provides a comprehensive introduction, covering key areas such as Python 3, data visualization, and statistical concepts. The practical code samples and hands-on approach make it ideal for beginners and those looking to enhance their skills.The journey begins with working with data, followed by an introduction to probability, statistics, and linear algebra. It then delves into Python, NumPy, Pandas, R, regular expressions, and SQL/NoSQL, concluding with data visualization techniques. This structured approach ensures a solid foundation in data science.

3D Printing. The Complete Guide to Mastering 3D Printing Techniques

Mercury Learning and Information, Stephanie Torta, Jonathan Torta

This book offers a comprehensive introduction to the field of 3D printing, covering its applications in industry, education, and the DIY community. It delves into common 3D printers, materials, and software, guiding you through setting up your own printer and performing essential calibration tasks. Through full-color images, you’ll learn about various printing methods, best practices, and how to finish your projects successfully.The book is divided into three parts: the first part provides a history and evolution of 3D printers, highlighting their industrial and personal use. The second part walks you through setting up a 3D printer, from initial hardware calibration to software functionalities and acquiring 3D objects. You’ll also find step-by-step guides for three different projects.The final part helps you choose the right printer, explains common features, and explores post-market modifications. Understanding 3D printing is crucial as it revolutionizes manufacturing and prototyping processes, enabling creativity and innovation in various fields. This book ensures a smooth journey from a novice to a confident 3D printing enthusiast, equipped with practical skills and knowledge. Companion files with videos, printable objects, and additional lessons enhance your learning experience.