Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The situation where you need to count or add the cells that are more than one number but less than another will be the main emphasis of this instruction. When working with huge datasets and need to swiftly extract specific information based on established criteria, this expertise is quite helpful. By the end of this session, you will have a firm grasp on how to use Excel's functions and formulae to effectively count and sum cells that fit the required criteria, streamlining and improving the accuracy of your data analysis activities. Count/Sum the Cells Greater than but Less than a ... Read More
You can visually highlight cells using the strong tool of conditional formatting based on certain criteria, such as colour. Utilising this function allows you to calculate depending on the colours assigned to certain cells, as well as highlight key data points. We will walk you through the process of counting or adding cells based on their colours step by step in this lesson. Whether you're a novice or a seasoned Excel user, this article will show you how to fully utilise conditional formatting to effectively analyse and work with data. Make sure you have a fundamental understanding of Excel and ... Read More
In this tutorial, we will discuss TypeScript, a great option for programmers who have experience with static typing languages like C# and Java. We can benefit from TypeScript's type system, which offers improved code completion, earlier error detection, and clearer communication between different parts of our program. It's essential to remember that TypeScript is based on JavaScript, which has some fundamental differences from traditional OOP languages. By understanding these differences, we can avoid common mistakes that programmers transitioning from C#/Java to TypeScript might make. Syntax Users can use the following syntax to create variables using TypeScript − let variableName: type ... Read More
One common task in software development is filtering objects based on specific criteria. In this tutorial, we will explore how to filter all matching objects in an object and its exactly the same children using Typescript. This technique can be particularly useful when working with complex data structures or when extracting specific information from nested objects. We will utilize TypeScript's powerful features, such as type annotations and object manipulation, to achieve this. Recursive Function with Type Guards for Filtering Matching Objects and Their Children We can use a recursive approach to filter all matching objects in an object and it ... Read More
In this article, we'll look at a useful tool that lets you make calculations depending on the colour of spreadsheet cells. Utilising this feature will allow you to swiftly analyse and draw conclusions from data that has been visually distinguished by colour coding. Google Sheets offers a variety of built-in functions and custom scripts to complete these tasks, whether you want to count the number of cells that are a given colour or calculate the total of values connected to a particular colour. In order to accommodate a range of user preferences and ability levels, this lesson will cover a ... Read More
In data analysis and spreadsheet management, keeping track of the frequency of specific values in a column is a typical activity. When it comes to effectively counting occurrences, Google Sheets offers robust features that can be used with both enormous datasets and straightforward lists. In this article, we'll show you step-by-step how to count the occurrences of a particular value in a column using Google Sheets functions and formulas. From simple counting to more complex filtering and criteria-based counting, you'll master a variety of methods that can be used in a variety of situations. This information will enable you to ... Read More
TypeScript, a superset of JavaScript, introduces static typing to JavaScript, allowing developers to catch potential errors and enhance code quality. One of the key features that set TypeScript apart is its support for structural typing. While other statically typed languages often rely on nominal typing, TypeScript embraces the concept of structural typing, which provides a more flexible and intuitive approach to type checking. In this tutorial, we will explore the concept of structural typing in TypeScript and its benefits and provide relevant examples to illustrate its usage. Understanding Structural Typing Structural typing is a type system that focuses on the ... Read More
Access modifiers are essential because they allow us to enforce encapsulation and define the boundaries of class member accessibility. With access modifiers, we can restrict access to certain members, ensuring they are only accessible within the class itself. We can also make members public, allowing them to be accessed from anywhere in our codebase. Furthermore, protected members enable access within the class and its derived classes. In this tutorial, we will explore the private, public, and protected access modifiers in TypeScript. Syntax Users can follow the syntax below to apply access modifiers to class members in TypeScript − class ClassName ... Read More
If you have ever worked with JavaScript libraries in your TypeScript projects, you may have encountered situations where you needed type information for those libraries. TypeScript declaration files, denoted with the .d.ts extension, provide type information for JavaScript code, enabling better static type checking and editor support in TypeScript projects. In this tutorial, we will explore different scenarios and methods for generating TypeScript declaration files from JavaScript libraries. We'll cover scenarios such as generating declaration files for existing JavaScript libraries, generating declaration files for your own JavaScript code, and leveraging tools like dts-gen and tsc to generate declaration files automatically. ... Read More
In TypeScript, the Record type is a powerful tool that allows you to define an object type with specific keys and corresponding value types. This tutorial will guide you through the fundamentals of using the Record type, providing syntax explanations and practical examples along the way. Whether you're a beginner or already familiar with TypeScript, this tutorial will help you understand how to leverage the Record type effectively in your projects. Syntax The syntax to create a Record type in TypeScript is straightforward. The type definition starts with the keyword Record, followed by angle brackets () containing the key and ... Read More