Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Sometimes in Excel, for encrypting the data, you have needed to convert letters to numbers based on their position in the alphabet series. For example, a = 1, b = 2, z = 26, and so on. Read this tutorial to learn how we can convert a letter to a number or a number to a letter based on their position in Excel. We can complete this process using the formulas supported in Excel. Mostly, this process is used for encryption and decryption of the data. Both encryption and decryption are used to provide security for data. Converting Letters to ... Read More
In general, we try to grade the test using a letter such as A+, A, B, and many others, and the minimum GPA is always linked to the grade. You may want to display them alongside the letter grade at times. Read this tutorial to learn how you can convert letter grades to numbers in Excel. If we try to do this conversion in a manual way, then it can be time-consuming and sometimes inaccurate. So, we can use the VLOOKUP function to make our process faster and more accurate. Use VLOOKUP when you need to find things in a ... Read More
In general, we always try to measure weight in kilogrammes or grams, but there can be a situation where we need those values in stones or pounds. The metric system of weights and measures is rarely used. Converting the values that are in kilogrammes into stones and pounds can be a complex process if we are trying to do it manually, as those both belong to different categories. Read this tutorial to will how you can convert kilogrammes to stones and pounds in Excel. We can complete this process simply by using the formulas supported by Excel. Some of the ... Read More
Sometimes in Excel, you may have observed that the sentences in the sheet are not in proper format. If we can make our data look ugly, Manually resolving this issue can be a time-consuming and lengthy process. We can solve this process in a faster and more accurate way using the formulas supported by Excel. This tutorial will help you understand how lowercase letters can be converted to proper case or sentence case in Excel. If only the first letter of a sentence is capital, then it is called sentence case, and if the first letters of all words of ... Read More
Sometimes in Excel, you may have needed to convert a matrix-style table to a column-style table. Any table with m rows and n columns is referred to as a matrix style table, and any table with m rows and three columns is referred to as a three column table in Excel. Read this tutorial to learn how you can convert a matrix-style table to a three-column table in Excel. We can complete this process with the help of a VBA application, as it can’t be completed directly in Excel. Converting a Matrix Style Table to Three Columns in Excel Here, ... Read More
Sometimes in Excel, you could have faced a problem where you were provided with image URLs instead of images. If we want to get the images manually, then it can be a lengthy process. So, we need a faster process to complete it. This tutorial will help you understand how we can convert image URLs to actual images in Excel. We can complete this task with the help of a VBA application, as it can’t be completed directly in Excel. Convert Image URLs to Actual Images in Excel Here we will first create a VBA module and then run it ... Read More
Materialize is a CSS framework which is used for designing as it uses the classic principles and combine them with innovation and technology. The creator of materialize is google as they developed a design system which can allow a unified user experience to every user in every type of product, regardless of the platform that the user is using. Breadcrumbs is a component which is built in materialize CSS and is mostly used when there are lots of layers so as to display the current location of the user working on it whether on the website or the web app. ... Read More
You might have seen sliding text reveal animation at different websites like personal portfolio websites and even different video content which gives a different experience to the user as well as the text feels more lively. The sliding text animation can be easily made using HTML and CSS which will catch the attention of the user that visits our website for the website. In this article we are going to have a look at how can we create our sliding text reveal animation using only HTML and CSS How to create the sliding animation? Let's talk about that the approach ... Read More
Styling a website is the most integral part of creating a website, as it serves as a hook-point for the user, who is visiting your website for the first time. We can create many types of designs and interactive experiences using CSS. A text portrait can be created used illustrator or Photoshop to make the design attractive. In this article we are going to have a look at how can we generate and create a text portrait using CSS and some JavaScript function so as to achieve our text portrait. Creating the text portrait A text portrait is an image ... Read More
Selectors are an important part of the CSS styling as all the properties which are applied to the elements are done using the selectors> it is also possible to select the elements on the basis of their relationship with some other element like a element which has a preceding element or any other element in the series. There are sibling combinator, child combinator and adjacent sibling combinator. In this article we are going to have a look at how can we style the element that have an adjacent item right before it Styling elements with adjacent items The elements which ... Read More