Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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
The user’s history of visited web pages is represented via the window.history object. A history of the pages that have been loaded is stored in an array called the history object. The history object only provides a finite amount of information. The history object only has a few properties and methods since it is impossible to know where the current URL is located within the history object. The previous URL in the history list is loaded using the history.back() method. The second method of history is the forward() method, which loads the following URL in the history list. It is ... Read More
Introduction When working on TypeScript projects, organizing and managing module dependencies is essential for maintaining a clean and scalable codebase. Absolute imports offer a convenient way to reference modules using a fixed path relative to the project's root directory. However, configuring and fixing absolute imports can sometimes be challenging, especially for beginners. In this tutorial, we will explore various scenarios where absolute imports may encounter issues and discuss practical solutions to resolve them. By the end, you'll understand how to fix absolute import problems in TypeScript effectively. Scenario 1: Missing TypeScript Configuration Before utilizing absolute imports, we must ensure that ... Read More
In TypeScript, interfaces provide a powerful way to define the shape of objects and enforce type constraints. They allow us to specify the required properties and methods that an object must have. One interesting feature of interfaces is the ability to extend them, allowing us to create a combination of interfaces. In this tutorial, we will explore how to extend interfaces to create new ones that inherit properties and methods from existing interfaces. Syntax interface NewInterface extends ExistingInterface { // Additional properties and methods } interface NewInterface extends Interface1, Interface2, ... { // ... Read More
Sparklines are charts that demonstrate trends in the sheet data graphically. They can be set in individual cells. For instance, Excel's sparkline function enables users to place compact charts within individual cells. They provide an overview of data trends and patterns in a visual representation. Sparklines are often utilized to compare multiple points of data within a set or to depict trends over time. Sparklines are particularly handy when users want to display trends and patterns with your actual data without taking up plenty of space in the spreadsheet. They offer users an instant visual summary of the information. ... Read More