11.70 MB – epub, azw3, pdf

Beschreibung:

NEARLY 90% OF SPREADSHEETS CONTAIN ERRORS AND MANY ARE ALSO HARD TO USE!

Studies show that spreadsheet errors are commonplace. These can cause you huge losses of money, time and reputation. On top of that, spreadsheets are often poorly designed and constructed so that users have a hard time trying to understand and use them. The consequence is, they hinder rather than help you.

Major causes are a lack of best practice training and insufficient error awareness. In this book, we address both these points.

If you develop or use spreadsheets, this book is for you!
You will learn how to excel at creating reliable, user-friendly spreadsheets. You will:
+ learn Golden Ground Rules to make your spreadsheets easier to use and to minimise the risk of error
+ learn how errors can occur – largely based upon real-life horror stories – and how to avoid them
+ fill your tool bag with “how2excel” tips to help you and further improve your spreadsheets

The book is packed with practical examples and screenshots to help you understand. You can also download free bonus material: Excel files containing all the examples in the book as well as a practical checklist to print out and refer to in your work.

In chapter 1 ‘Be prepared’, you will learn what to do before starting to develop a spreadsheet and how best to plan your work.

In chapter 2 ’Follow Gary’s Golden Ground Rules’, you will learn all five of my tried and tested Golden Ground Rules for spreadsheet development. Rules 1 to 3 cover clear spreadsheet structure, calculations and design. Rules 4 and 5 explain how to restrict access and changes to your spreadsheets and make it clear for users how to use them. Follow these to help ensure that your spreadsheets are easy to use and to avoid errors.

In chapter 3 ‘Learn from horror stories’, you will learn about more than 20 real-life spreadsheet errors which had significant, damaging consequences – largely financial but also reputational – for the organisations and the people involved. These horror stories are grouped into categories to get you better acquainted with the kinds of errors that occur. In each case, you will learn how such errors arise and practical techniques to avoid them. These are often illustrated with simple Excel examples to help you better understand them. As a bonus, these examples are all available in Excel files that you can download and review to further improve your understanding.

In chapter 4 ‘Avoid common function errors’, you will understand various errors that can arise when using common functions such as VLOOKUP, NPV and IFERROR and how to avoid them.

At this point in the book, we end the focus on error prevention. Two additional steps are needed to weed out any errors which do manage to slip through, and you will learn these in the next two chapters.

In chapter 5 ’Detect errors’, you will learn how to identify errors, in case prevention fails. You will learn my three-pronged approach to error detection: built-in checks, review and testing by the developer, and independent review and testing.

In chapter 6 ‘Find and correct errors’, you will learn how to find and correct errors, including those that you had not previously detected! This is a vital step that should not be underestimated or omitted if you want to be really sure that your spreadsheets are reliable.

Finally, in chapter 7 ‘How to excel’, you will find advice on how best to apply your new-found knowledge and also a useful checklist of all the major concepts from the book for you to use in your Excel work. As a bonus, you can download and printout a PDF of the checklist for easy reference.

15.61 MB – epub, azw3, pdf

Beschreibung:

You may have looked at coding in the past, and felt it was too complicated and confusing. This comprehensive beginner’s guide will take you step by step through learning one of the best programming languages out there.

10.12 MB – epub, mobi, pdf

Beschreibung:

Become an accomplished Ruby programmer by understanding the design principles, best practices, and trade-offs involved in implementation approaches to keep your Ruby applications maintainable in the long term
Key Features

Understand the design principles behind polished Ruby code and trade-offs between implementation approaches
Use metaprogramming and DSLs to reduce the amount of code needed without decreasing maintainability
Learn Ruby web application design principles and strategies for databases, security, and testing

Book Description

Most successful Ruby applications become difficult to maintain over time as the codebase grows in size. Polished Ruby Programming provides you with recommendations and advice for designing Ruby programs that are easy to maintain in the long term.

This book takes you through implementation approaches for many common programming situations, the trade-offs inherent in each approach, and why you may choose to use different approaches in different situations. You’ll start by learning fundamental Ruby programming principles, such as correctly using core classes, class and method design, variable usage, error handling, and code formatting. Moving on, you’ll learn higher-level programming principles, such as library design, use of metaprogramming and domain-specific languages, and refactoring. Finally, you’ll learn principles specific to web application development, such as how to choose a database and web framework, and how to use advanced security features.

By the end of this Ruby programming book, you’ll have gained the skills you need to design robust, high-performance, scalable, and maintainable Ruby applications.

While most code examples and principles discussed in the book apply to all Ruby versions, some examples and principles are specific to Ruby 3.0, the latest release at the time of publication.

What you will learn

Use Ruby’s core classes and design custom classes effectively
Explore the principles behind variable usage and method argument choice
Implement advanced error handling approaches such as exponential backoff
Design extensible libraries and plugin systems in Ruby
Use metaprogramming and DSLs to avoid code redundancy
Implement different approaches to testing and understand their trade-offs
Discover design patterns, refactoring, and optimization with Ruby
Explore database design principles and advanced web app security

Who this book is for

If you already know how to program in Ruby and want to learn more about the principles and best practices behind writing maintainable, scalable, optimized, and well-structured Ruby code, then this Ruby book is for you. Intermediate to advanced-level working knowledge of the Ruby programming language is expected to get the most out of this book.
Table of Contents

Getting the Most out of Core Classes
Designing Useful Custom Classes
Proper Variable Usage
Methods and Their Arguments
Handling Errors
Formatting Code for Easy Reading
Designing Your Library
Designing For Extensibility
Metaprogramming and When to Use It
Designing Useful Domain-Specific Languages
Testing to Ensure Your Code Works
Handling Change
Using Common Design Patterns
Optimizing Your Library
The Database Is Key
Web Application Design Principles
Robust Web Application Security

22.47 MB – epub, mobi, pdf

Beschreibung:

Discover blueprints that explore various components of Blazor, C#, and .NET to help you build web apps without learning JavaScript
Key Features

Explore complete, easy-to-follow web projects using Blazor
Build projects such as a weather app, expense tracker, and Kanban board with real-world applications
Understand and work with Blazor WebAssembly effectively without spending too much time focusing on the theory

Book Description

Blazor 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 learn

Discover the power of the C# language for both server-side and client-side web development
Use the Blazor WebAssembly App project template to build your first Blazor WebAssembly application
Use templated components and the Razor class library to build and share a modal dialog box
Understand how to use JavaScript with Blazor WebAssembly
Build a progressive web app (PWA) to enable native app-like performance and speed
Understand dependency injection (DI) in .NET to build a shopping cart app
Get to grips with .NET Web APIs by building a task manager app

Who this book is for

This 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.
Table of Contents

Introduction to Blazor WebAssembly
Building Your First Blazor WebAssembly Application
Building a Modal Dialog Using Templated Components
Building a Local Storage Service Using JavaScript Interoperability (JS Interop)
Building a Weather App as a Progressive Web App (PWA)
Building a Shopping Cart Using Application State
Building a Kanban Board Using Events
Building a Task Manager Using ASP.NET Web API
Building an Expense Tracker Using the EditForm Component

~20 MB – pdf

19.02 MB – epub, mobi, pdf

Beschreibung:

Gain in-depth insight into DevOps relative to your field of expertise and implement effective DevOps culture and processes within your organization
Key Features

Packed with step-by-step explanations and practical examples to help you get started with DevOps
Develop the skills and knowledge you need to tackle the deployment of DevOps tools
Discover technology trends such as FinOps and DevSecOps to get more value from DevOps

Book Description

DevOps is a set of best practices enabling operations and development teams to work together to produce higher-quality work and, among other things, quicker releases. This book helps you to understand the fundamentals needed to get started with DevOps, and prepares you to start deploying technical tools confidently.

You will start by learning the key steps for implementing successful DevOps transformations. The book will help you to understand how aspects of culture, people, and process are all connected, and that without any one of these elements DevOps is unlikely to be successful. As you make progress, you will discover how to measure and quantify the success of DevOps in your organization, along with exploring the pros and cons of the main tooling involved in DevOps. In the concluding chapters, you will learn about the latest trends in DevOps and find out how the tooling changes when you work with these specialties.

By the end of this DevOps book, you will have gained a clear understanding of the connection between culture, people, and processes within DevOps, and learned why all three are critically important.

What you will learn

Understand the importance of culture in DevOps
Build, foster, and develop a successful DevOps culture
Discover how to implement a successful DevOps framework
Measure and define the success of DevOps transformation
Get to grips with techniques for continuous feedback and iterate process changes
Discover the tooling used in different stages of the DevOps life cycle

Who this book is for

This book is for IT professionals such as support engineers and systems engineers and developers looking to learn DevOps and for those going through DevOps transformation. General knowledge of IT and business processes will be helpful. You’ll also find this book useful if you are in a business or service role within technology such as service delivery management. Basic familiarity with DevOps and transformational methods such as value streams and process are needed to get the most out of this book.
Table of Contents

Introducing DevOps and Agile
Business benefits, team topologies and pitfalls of DevOps
Measuring the success of DevOps
Building a DevOps culture and breaking down silos
Avoiding cultural anti-patterns in DevOps
Driving process change with value stream maps
Delivering process change to your organization
Continuous improvement of processes
Understanding the technical stack for DevOps
Developing a strategy for implementing tooling
Influence of tools on the DevOps lifecycle
Keeping up with key DevOps trends

37.70 MB – epub, mobi, pdf

Beschreibung:

Build end-to-end industrial-strength NLP models using advanced morphological and syntactic features in spaCy to create real-world applications with ease
Key Features

Gain an overview of what spaCy offers for natural language processing
Learn details of spaCy’s features and how to use them effectively
Work through practical recipes using spaCy

Book Description

spaCy is an industrial-grade, efficient NLP Python library. It offers various pre-trained models and ready-to-use features. Mastering spaCy provides you with end-to-end coverage of spaCy’s features and real-world applications.

You’ll begin by installing spaCy and downloading models, before progressing to spaCy’s features and prototyping real-world NLP apps. Next, you’ll get familiar with visualizing with spaCy’s popular visualizer displaCy. The book also equips you with practical illustrations for pattern matching and helps you advance into the world of semantics with word vectors. Statistical information extraction methods are also explained in detail. Later, you’ll cover an interactive business case study that shows you how to combine all spaCy features for creating a real-world NLP pipeline. You’ll implement ML models such as sentiment analysis, intent recognition, and context resolution. The book further focuses on classification with popular frameworks such as TensorFlow’s Keras API together with spaCy. You’ll cover popular topics, including intent classification and sentiment analysis, and use them on popular datasets and interpret the classification results.

By the end of this book, you’ll be able to confidently use spaCy, including its linguistic features, word vectors, and classifiers, to create your own NLP apps.

What you will learn

Install spaCy, get started easily, and write your first Python script
Understand core linguistic operations of spaCy
Discover how to combine rule-based components with spaCy statistical models
Become well-versed with named entity and keyword extraction
Build your own ML pipelines using spaCy
Apply all the knowledge you’ve gained to design a chatbot using spaCy

Who this book is for

This book is for data scientists and machine learners who want to excel in NLP as well as NLP developers who want to master spaCy and build applications with it. Language and speech professionals who want to get hands-on with Python and spaCy and software developers who want to quickly prototype applications with spaCy will also find this book helpful. Beginner-level knowledge of the Python programming language is required to get the most out of this book. A beginner-level understanding of linguistics such as parsing, POS tags, and semantic similarity will also be useful.
Table of Contents

Getting Started with spaCy
Core Operations with spaCy
Linguistic Features
Rule-Based Matching
Working with Word Vectors and Semantic Similarity
Putting Everything Together: Semantic Parsing with spaCy
Customizing spaCy Models
Text Classification with spaCy
spaCy and Transformers
Putting Everything Together: Designing Your Chatbot with spaCy

17.58 MB – epub

Beschreibung:

Get to grips with the AWS Amplify framework and use it to build scalable cloud-native progressive web apps with React and cross-platform mobile apps with React Native in TypeScript

Key Features

Explore the capabilities of AWS Amplify with popular app frameworks for both web and mobile app platforms
Build your first cloud-native web and mobile applications using AWS Amplify
Leverage AWS Amplify to design GraphQL APIs for your web and mobile applications

Book Description
AWS Amplify is a modern toolkit that includes a command line interface (CLI); libraries for JS, iOS, and Android programming; UI component libraries for frameworks like React, Angular, and Vue.js for web development, and React Native and Flutter for mobile development.
You’ll begin by learning how to build AWS Amplify solutions with React and React Native with TypeScript from scratch, along with integrating it with existing solutions. This book will show you the fastest way to build a production-ready minimum viable product (MVP) within days instead of years. You’ll also discover how to increase development speed without compromising on quality by adopting behavior-driven development (BDD) and Cypress for end-to-end test automation, as well as the Amplify build pipeline (DevOps or CI/CD pipeline) to ensure optimal quality throughout continuous test automation and continuous delivery. As you advance, you’ll work with React to determine how to build progressive web apps (PWAs) with Amplify and React Native for cross-platform mobile apps. In addition to this, you’ll find out how to set up a custom domain name for your new website and set up the AWS Amplify Admin UI for managing the content of your app effectively.
By the end of this AWS book, you’ll be able to build a full-stack AWS Amplify solution all by yourself.

What you will learn

Build React and React Native apps with Amplify and TypeScript
Explore pre-built Amplify UI components for rapid prototyping
Add user management with Amplify authentication to your app
Use Amplify GraphQL to create a blog post
Discover how to upload photos to Amplify Storage
Enable DevOps with the Amplify pipeline for your app
Get to grips with BDD and test automation with Cypress and Cucumber
Set up a custom domain name for your website and manage app content with the Amplify Admin UI

Who this book is for
This book is for developers and tech companies looking to develop cloud-native products rapidly with the AWS ecosystem. Web and mobile developers with little-to-no experience in TypeScript programming will also find this book helpful. Although no prior experience with AWS or TypeScript is required, basic familiarity with modern frameworks such as React and React Native is useful.

25.64 MB – epub

Beschreibung:

Microsoft Lists is an extremely flexible and powerful platform for creating custom data models. Hands-On Microsoft Lists is an easy-to-read guide for those who want to get started with Lists, as well as those who are already familiar with the basic concepts and want to create custom and flexible Lists that are easily available through a web interface.
This comprehensive introduction to Lists will show you how to get up to speed in no time with the help of practical guidance and examples. Complete with hands-on tutorials and projects, you’ll understand how to use and implement Microsoft Lists effectively. You’ll start by covering all the basic concepts that will help you to build your Microsoft Lists and get the most out of the platform. As you progress, you’ll explore how to customize Microsoft Lists layouts and forms. Later chapters will guide you through integrating Microsoft Lists with the Power Platform. Throughout the book, you’ll work with practical scenarios that you can use daily to improve the collaboration in your organization.

By the end of this Microsoft book, you’ll have learned how to create custom data models to improve the way your data is put together, managed, and consumed in your workplace.

What you will learn
[*]Use the Lists platform effectively in the modern workplace
[*]Get to grips with data privacy
[*]Discover how to customize Microsoft Lists data and forms
[*]Automate processes using Microsoft Lists
[*]Extend the default features of Microsoft Lists using the SharePoint framework
[*]Create custom list templates using PnP PowerShell
[*]Extend Microsoft Lists using Power Platform

Who this book is for
This book is for business professionals and end users working with Microsoft 365 tools such as Microsoft SharePoint and Microsoft Teams who are looking to improve the way their data is structured, managed, and consumed inside an organization. Basic knowledge of SharePoint and Excel is assumed.