Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
When we are using Excel, we want to add different colours to cells to create a design that can improve the neatness of the data. This also makes the excel sheet look nicer and allows for faster data analysis. This article will help you understand how we can apply color-banded rows or columns in Excel. This can be done using a simple method in Excel by using conditional formatting and applying different colours. Read this tutorial to learn a simple process to apply color-banded rows or columns in Excel. Applying Colour Banded Rows or Columns Using Conditional Formatting ... Read More
We could have created many types of charts in Excel and customised them to get our output, but the customization of charts could be a time-consuming process. If there is any type of chart that we will be using more frequently and which is not the default type in Excel, we can save the template of it in order to access it very quickly. We can save a template by selecting the existing chart and right-clicking and selecting "Save as template" from the menu box. Read this tutorial to learn how you can apply a template to an ... Read More
Have you ever tried to access the data in two workbooks at once? You could have compared data in two sheets of the same workbook using the VLOOKUP function. We can also connect the two worksheets in Excel. This process can’t be completed using the formulas; we will need to use the VBA code. This tutorial will help you understand how we can apply a button to open another workbook in Excel. Applying a Button to Open Another Workbook in Excel Here we will first insert a shape and then assign a macro to it. Let us see ... Read More
The array stores the elements of the different data types in TypeScript. It is a collection of elements we can use it to store and access data whenever required. While working with multiple arrays, we need to combine two or more arrays. There are several ways to combine multiple arrays in TypeScript, and we will look through all ways in this TypeScript tutorial. Also, we will discuss when we should use which way is the best at last. Uing The For Loop to Join The Two Arrays We can follow the traditional way of using the for-of loop to join ... Read More
In TypeScript, while working with the array, we often require to search for a particular element. To search for an element, either we can use the naive approach using the for loop or some built-in method such as the find() or indexOf() method. Also, we will learn to find the particular object in the array based on the object property. Using the for-of Loop to Search a Particular Element in The Array The naive approach to searching for an element is using linear search. In linear search, we need to iterate through the array using the for loop and check ... Read More
This tutorial demonstrates multiple ways to reverse a string in TypeScript. At first, reversing the string problem looks easy, but what if someone asks you to explain the different approaches to reversing a string in TypeScript? For example, what if the interviewer asks to reverse the words of the string rather than reversing every character of the string? Here, we will learn to reverse every character or word of the string in TypeScript. Using the for-of Loop to Reverse a String in TypeScript The naive approach to reverse the string uses the normal for loop or for-of loop. Here, we ... Read More
Sometimes, we need to replace a substring with a new string or any particular character while working with TypeScript. The simple way to replace the substring or part of the string is to use the replace() method. Here, we will create a custom algorithm to replace the string for the interview purpose of the beginners. However, we will also see the replace() method at last in this tutorial. Create the Custom Algorithm to Replace the Substring We will use the for loop to iterate through the main string in this part. We will use the substr() method of the string ... Read More
Type assertion is a mechanism in TypeScript that informs the compiler of the variable type. We can override the type using a type assertion if TypeScript finds that the assignment is wrong. We must be certain that we are correct since the assignment is always legitimate when we employ a type assertion. If not, our program might not operate properly. Declaratively informing the compiler that we intend to regard the item as a distinct type is known as type assertion. Using this, we can regard any as a number or a number as a string. When moving code from JavaScript ... Read More
In TypeScript, the typeof is one of the most helpful operators and keywords to check the types of variables or identifiers. However, TypeScript is a type-strict language. So, we need to define the type of the variable or object while defining the identifier itself. Still, sometimes we need to check the type of the variable. For example, we are taking the data from the user via forms and handling it via TypeScript. Then we have to validate the data and perform some database operations. Also, the identifier can have multiple types in TypeScript. So, using the typeof operator, we can ... Read More
We will learn to specify the option properties in TypeScript. The true meaning of the optional property is that properties can be undefined or null, and we can initialize them whenever required. In real-time development, the importance of optional properties is very much. For example, we are fetching the data from the API and performing some operations on the data. If you try to use the data without getting it due to the database server being down or if there is any other problem, it will raise an error. In such case, we can make the data property optional and ... Read More