Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Assume we have a list of texts where each cell contains multiple words and another list that contains words from the other list, and you want to highlight the cells where these words are present so we can use conditional formatting searches for multiple words to solve the problem in Excel. This tutorial will help you understand how you can apply conditional formatting to a search for multiple words in Excel. Applying Conditional Formatting Search for Multiple Words in Excel Here, we will first name a list and then use the name in the formatting formula. Let us ... Read More
Have you ever tried comparing the data on two different work sheets? Yes, it is possible to compare data from two different sheets in Excel. Let us assume we have two lists that contain the current prices of stocks and the price of a stock last month for a list of stocks, and you want to compare them to know where the price is high. In this tutorial, we will help you understand how you can apply conditional formatting based on VLOOKUP in Excel. Applying Conditional Formatting based on VLOOKUP Here we will apply the conditional formatting to ... Read More
You could have used conditional formatting in Excel very frequently, but have you ever tried applying conditional formatting across different work sheets in Excel? Yes, it is possible to apply conditional formatting across worksheets or workbooks in Excel; it is a very simple process. This tutorial will help you understand how we can apply conditional formatting across worksheets in Excel. Applying Conditional Formatting across Worksheets/Workbooks Here, we will first get the data into one sheet and then apply the conditional formatting to the acquired data. Let's look at a quick way to apply conditional formatting to multiple worksheets ... Read More
You could have added different colours to cells in Excel, but have you tried adding different shades of the same colour to the cells? It is possible to add shades of the same colour to the spreadsheet cells. Adding shades of the same colour will look better than using different colours. This tutorial will help you understand how you can add a colour gradient across multiple cells in Excel by following some simple steps. Applying Colour Gradient Across Multiple Cells in Excel Here, we will first apply the conditional formatting to cells and select gradient colours. Let us ... Read More
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