VBA Automation for Excel 2019 Cookbook. Solutions to automate routine tasks and increase productivity with Excel and other MS Office applications

Mike Van Niekerk

Visual Basic for Applications (VBA) is a programming language developed by Microsoft to automate tasks in MS Office applications. This book will help you to focus on the essential aspects of your role by automating mundane tasks in Excel and other Office applications. With comprehensive coverage of VBA delivered in the form of practice problems and bite-sized recipes, this book will help you to hit the ground running.Unlike most books that assume prior programming experience, this book starts with the fundamentals and gradually progresses to solving bigger problems.You’ll start by becoming familiar with VBA so that you can start recording macros right away. With this foundation in place, you’ll advance to using the full capabilities of the language as you apply loops, functions, and custom dialog boxes to design your own automation programs. You'll also get to grips with embedded macros and other advanced tools to enhance productivity and explore topics relating to app performance and security. Throughout this VBA book, you’ll cover multiple practice projects in Excel, Word, and PowerPoint while exploring tips and best practices to hone your skills.By the end of this book, you’ll have developed the skills you need to use VBA to create your own programs that control MS Office applications.

Modern Network Observability. A hands-on approach using open source tools such as Telegraf, Prometheus, and Grafana

David Flores, Christian Adell, Josh VanDeraa, Eric Chou, ...

As modern IT services and software architectures such as microservices rely increasingly on network performance, the relevance of networks has never been greater. Network observability has emerged as a critical evolution of traditional monitoring, providing the deep visibility needed to manage today’s complex, dynamic environments. In Modern Network Observability, authors David Flores, Christian Adell, and Josh VanDeraa share their extensive experience to guide you through building and deploying a flexible observability stack using open-source tools.This book begins by addressing the limitations of monolithic monitoring solutions, showing you how to transform them into a composable, flexible observability stack. Through practical implementations, you’ll learn how to collect, normalize, and analyze network data from diverse sources, build intuitive dashboards, and set up actionable alerts that help you stay ahead of potential issues. Later, you’ll cover advanced topics, such as integrating observability data into your network automation strategy, ensuring your network operations align with business objectives.By the end of this book, you'll be able to proactively manage your network, minimize downtime, and ensure resilient, efficient, and future-proof operations.

IBM WebSphere Application Server v7.0 Security. For IBM WebSphere users, this is the complete guide to securing your applications with Java EE and JAAS security standards. From a far-ranging overview to the fundamentals of data encryption, all the essentials are here

Omar P Siliceo (USD), Omar Siliceo

In these days of high-profile hacking, server security is no less important than securing your application or network. In addition many companies must comply with government security regulations. No matter how secure your application is, your business is still at risk if your server is vulnerable. Here is how you solve your WebSphere server security worries in the best possible way.This tutorial is focused towards ways in which you can avoid security loop holes. You will learn to solve issues that can cause bother when getting started with securing your IBM WebSphere Application Server v7.0 installation. Moreover, the author has documented details in an easy-to-read format, by providing engaging hands-on exercises and mini-projects.The book starts with an in-depth analysis of the global and administrative security features of WebSphere Application Server v7.0, followed by comprehensive coverage of user registries for user authentication and authorization information. Moving on you will build on the concepts introduced and get hands-on with a mini project. From the next chapter you work with the different front-end architectures of WAS along with the Secure Socket Layer protocol, which offer transport layer security through data encryption.You learn user authentication and data encryption, which demonstrate how a clear text channel can be made safer by using SSL transport to encrypt its data. The book will show you how to enable an enterprise application hosted in a WebSphere Application Server environment to interact with other applications, resources, and services available in a corporate infrastructure. Platform hardening, tuning parameters for tightening security, and troubleshooting are some of the aspects of WebSphere Application Server v7.0 security that are explored in the book. Every chapter builds strong security foundations, by demonstrating concepts and practicing them through the use of dynamic, web-based mini-projects.

Building Python Real-Time Applications with Storm. Learn to process massive real-time data streams using Storm and Python—no Java required!

Kartik Bhatnagar, Barry Hart

Big data is a trending concept that everyone wants to learn about. With its ability to process all kinds of data in real time, Storm is an important addition to your big data “bag of tricks.” At the same time, Python is one of the fastest-growing programming languages today. It has become a top choice for both data science and everyday application development. Together, Storm and Python enable you to build and deploy real-time big data applications quickly and easily.You will begin with some basic command tutorials to set up storm and learn about its configurations in detail. You will then go through the requirement scenarios to create a Storm cluster. Next, you’ll be provided with an overview of Petrel, followed by an example of Twitter topology and persistence using Redis and MongoDB. Finally, you will build a production-quality Storm topology using development best practices.

Feature Engineering for Modern Machine Learning with Scikit-Learn. Mastering data preparation and transformation for robust ML models

Cuantum Technologies LLC

Feature engineering is essential for building robust predictive models. This book delves into practical techniques for transforming raw data into powerful features using Scikit-Learn. You'll explore automation, deep learning integrations, and advanced topics like feature selection and model evaluation. Learn to handle real-world data challenges, enhance accuracy, and streamline your workflows.Through hands-on projects, readers will gain practical experience with techniques such as clustering, pipelines, and feature selection, applied to domains like retail and healthcare. Step-by-step instructions ensure a comprehensive learning journey, from foundational concepts to advanced automation and hybrid modeling approaches.By combining theory with real-world applications, the book equips data professionals with the tools to unlock the full potential of machine learning models. Whether working with structured datasets or integrating deep learning features, this guide provides actionable insights to tackle any data transformation challenge effectively.

Pro Tools HD: Advanced Techniques and Workflows. Using Pro Tools HD is not always easy, but with this book you'll be on the fast track to achieving optimum quality audio. Learn to use Pro Tools at the highest professional level

Edouard Camou

Pro Tools HD is a digital audio workstation platform for Microsoft Windows and Mac OS X operating systems. It is the leading audio software when it comes to professional audio work. Working effectively with audio and producing professional music with Pro Tools HD is not an easy task.Beginning with what the software is about, we will take you all the way through to the steps required to efficiently record your audio. You will discover how to improve the workflow of Pro Tools software and receive innovative tips to enable flawless editing in music production, film scoring, film, and television post-production.Packed with concise and clear instructions on using Pro Tools HD: Advanced Techniques and Workflows, this book starts with different possible hardware and software combinations to help you understand the strengths and limitations of each, before taking you through powerful editing and advanced mixing techniques.When it comes to choosing a ProTools HD system there are different technologies available and therefore, many ways to use the system optimally so, you will learn about some digital audio concepts for better software optimisation. You will then learn editing using Beat detective, as well as covering excellent workflow and routing concepts to take full advantage of ProTools mixing capabilities, integrating both hardware analogue units with your favorite plugins. Finally, you will see how you can export your project safer, faster and better.This guide shows you the framework to enable you to take your usage of ProTools to the next level by explaining and discussing new and advanced features to achieve industry standard techniques.

Elevate Your Audio Production with REAPER. An extensive guide to recording, editing, and mixing with a powerful DAW

Marco Galvan, Christopher Bolte

Among the digital audio workstations (DAWs) revolutionizing the way we create and manipulate sound, REAPER stands out as a comprehensive and customizable solution. Written by two professional sound engineers with extensive credentials, this book helps you make the most of this DAW by guiding you through each step of using REAPER, from initial setup to advanced professional techniques, to produce high-quality audio content.Starting with the basics, you’ll learn how to install and configure the software to suit your specific needs. Through practical examples, you'll explore REAPER’s extensive features, covering everything from initial recording sessions to the final stages of mixing and mastering. You'll also be guided through creating a complete musical production, learning how to utilize REAPER's tools to capture the best takes and edit them to perfection. Whether you're working on music, podcasts, or sound design for video, you will discover techniques for mixing and mastering your projects, ensuring they achieve optimal sound quality and volume for distribution.By the end of this book, you’ll have gained a thorough understanding of how to harness REAPER’s full potential.

Building a Game with Unity and Blender. Learn how to build a complete 3D game using the industry-leading Unity game development engine and Blender, the graphics software that gives life to your ideas

Gustavo Vitarelli de Queiroz, Lee Zhi Eng

In the wake of the indie game development scene, game development tools are no longer luxury items costing up to millions of dollars but are now affordable by smaller teams or even individual developers. Among these cutting-edge applications, Blender and Unity stand out from the crowd as a powerful combination that allows small-to-no budget indie developers or hobbyists alike to develop games that they have always dreamt of creating.Starting from the beginning, this book will cover designing the game concept, constructing the gameplay, creating the characters and environment, implementing game logic and basic artificial intelligence, and finally deploying the game for others to play. By sequentially working through the steps in each chapter, you will quickly master the skills required to develop your dream game from scratch.

Embedded Linux Development with Yocto Project. Develop fascinating Linux-based projects using the groundbreaking Yocto Project tools

Otavio Salvador, Otavio R Salvador, Daiane Angolini

Soar with Haskell. The ultimate beginners' guide to mastering functional programming from the ground up

Tom Schrijvers

With software systems reaching new levels of complexity and programmers aiming for the highest productivity levels, software developers and language designers are turning toward functional programming because of its powerful and mature abstraction mechanisms. This book will help you tap into this approach with Haskell, the programming language that has been leading the way in pure functional programming for over three decades.The book begins by helping you get to grips with basic functions and algebraic datatypes, and gradually adds abstraction mechanisms and other powerful language features. Next, you’ll explore recursion, formulate higher-order functions as reusable templates, and get the job done with laziness. As you advance, you’ll learn how Haskell reconciliates its purity with the practical need for side effects and comes out stronger with a rich hierarchy of abstractions, such as functors, applicative functors, and monads. Finally, you’ll understand how all these elements are combined in the design and implementation of custom domain-specific languages for tackling practical problems such as parsing, as well as the revolutionary functional technique of property-based testing.By the end of this book, you’ll have mastered the key concepts of functional programming and be able to develop idiomatic Haskell solutions.

Embracing Microservices Design. A practical guide to revealing anti-patterns and architectural pitfalls to avoid microservices fallacies

Ovais Mehboob Ahmed Khan, Nabil Siddiqui, Timothy Oleson, Mark Fussell

Microservices have been widely adopted for designing distributed enterprise apps that are flexible, robust, and fine-grained into services that are independent of each other. There has been a paradigm shift where organizations are now either building new apps on microservices or transforming existing monolithic apps into microservices-based architecture.This book explores the importance of anti-patterns and the need to address flaws in them with alternative practices and patterns. You'll identify common mistakes caused by a lack of understanding when implementing microservices and cover topics such as organizational readiness to adopt microservices, domain-driven design, and resiliency and scalability of microservices. The book further demonstrates the anti-patterns involved in re-platforming brownfield apps and designing distributed data architecture. You’ll also focus on how to avoid communication and deployment pitfalls and understand cross-cutting concerns such as logging, monitoring, and security. Finally, you’ll explore testing pitfalls and establish a framework to address isolation, autonomy, and standardization.By the end of this book, you'll have understood critical mistakes to avoid while building microservices and the right practices to adopt early in the product life cycle to ensure the success of a microservices initiative.

Unity 5.x 2D Game Development Blueprints. Explore the features of Unity 5 for 2D game development by building three amazing game projects

Abdelrahman Elsayegh, Francesco Sapio

Flexible, powerful, and full of rich features, Unity 5 is the engine of choice for AAA 2D and 3D game development. With comprehensive support for over 20 different platforms, Unity boasts a host of great new functions for making 2D games. Learn how to leveragethese new options into awesome 2D games by building three complete game projects with the Unity game tutorials in this hands-on book.Get started with a quick overview of the principle concepts and techniques needed for making 2D games with Unity, then dive straight in to practical development.Build your own version of Super Mario Brothers as you learn how to animate sprites, work with physics, and construct brilliant UIs in order to create a platformer game. Go on a quest to create a RPG game discovering NPC design, event triggers, and AI programming.Finally, put your skills to the test against a real challenge - designing and constructing a complex strategy game that will draw on and develop all your previously learned skills.

Quantum Computing Experimentation with Amazon Braket. Explore Amazon Braket quantum computing to solve combinatorial optimization problems

Alex Khan, Matthew R. Versaggi

Amazon Braket is a cloud-based pay-per-use platform for executing quantum algorithms on cutting-edge quantum computers and simulators. It is ideal for developing robust apps with the latest quantum devices.With this book, you'll take a hands-on approach to learning how to take real-world problems and run them on quantum devices. You'll begin with an introduction to the Amazon Braket platform and learn about the devices currently available on the platform, their benefits, and their purpose. Then, you'll review key quantum concepts and algorithms critical to converting real-world problems into a quantum circuit or binary quadratic model based on the appropriate device and its capability. The book also covers various optimization use cases, along with an explanation of the code. Finally, you'll work with a framework using code examples that will help to solve your use cases with quantum and quantum-inspired technologies. Later chapters cover custom-built functions and include almost 200 figures and diagrams to visualize key concepts. You’ll be able to scan the capabilities provided by Amazon Braket and explore the functions to adapt them for specific use cases.By the end of this book, you’ll have the tools to integrate your current business apps and AWS data with Amazon Braket to solve constrained and multi-objective optimization problems.

Ansible for Real-Life Automation. A complete Ansible handbook filled with practical IT automation use cases

Gineesh Madapparambath

Get ready to leverage the power of Ansible’s wide applicability to automate and manage IT infrastructure with Ansible for Real-Life Automation. This book will guide you in setting up and managing the free and open source automation tool and remote-managed nodes in the production and dev/staging environments.Starting with its installation and deployment, you’ll learn automation using simple use cases in your workplace. You’ll go beyond just Linux machines to use Ansible to automate Microsoft Windows machines, network devices, and private and public cloud platforms such as VMWare, AWS, and GCP. As you progress through the chapters, you’ll integrate Ansible into your DevOps workflow and deal with application container management and container platforms such as Kubernetes. This Ansible book also contains a detailed introduction to Red Hat Ansible Automation Platform to help you get up to speed with Red Hat AAP and integration with CI/CD and ITSM.What’s more, you’ll implement efficient automation solutions while learning best practices and methods to secure sensitive data using Ansible Vault and alternatives to automate non-supported platforms and operations using raw commands, command modules, and REST API calls.By the end of this book, you’ll be proficient in identifying and developing real-life automation use cases using Ansible.

Fast Data Processing Systems with SMACK Stack. Click here to enter text

Raúl Estrada

SMACK is an open source full stack for big data architecture. It is a combination of Spark, Mesos, Akka, Cassandra, and Kafka. This stack is the newest technique developers have begun to use to tackle critical real-time analytics for big data. This highly practical guide will teach you how to integrate these technologies to create a highly efficient data analysis system for fast data processing.We’ll start off with an introduction to SMACK and show you when to use it. First you’ll get to grips with functional thinking and problem solving using Scala. Next you’ll come to understand the Akka architecture. Then you’ll get to know how to improve the data structure architecture and optimize resources using Apache Spark. Moving forward, you’ll learn how to perform linear scalability in databases with Apache Cassandra. You’ll grasp the high throughput distributed messaging systems using Apache Kafka. We’ll show you how to build a cheap but effective cluster infrastructure with Apache Mesos. Finally, you will deep dive into the different aspect of SMACK using a few case studies. By the end of the book, you will be able to integrate all the components of the SMACK stack and use them together to achieve highly effective and fast data processing.

Simplifying 3D Printing with OpenSCAD. Design, build, and test OpenSCAD programs to bring your ideas to life using 3D printers

Colin Dow

Want to bring your 3D designs to life with OpenSCAD, but don’t know where to start? Simplifying 3D Printing with OpenSCAD will teach you the key skills so that you can focus on your ideas, not troubleshooting your 3D printer.With the help of this book, you’ll build a solid foundation in 3D printing technology, the software used for designing your objects, and an analysis of the G-code produced by the 3D printer slicer software. You’ll also get to know your 3D printer and find out how to set up a printing job effortlessly — from configuring the parameters to build well-defined designs.Consider yourself a practical learner? Use real-world examples such as designing and printing a 3D name badge, model rocket, and laptop stand, to dive into the world of 3D printers build your skillset.By the end of this 3D printing book, you'll be ready to start designing and printing your own 3D printed products using OpenSCAD and being your ideas into reality.