- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Pradeep Kumar has Published 1236 Articles
Pradeep Kumar
2K+ Views
When we want to change the size of a specific shape in Excel based on the value present in any cell, we can use VB code to do it. Read this tutorial to learn how you can automatically change the shape and size based on a specified cell value in ... Read More
Pradeep Kumar
1K+ Views
When we want to add the current date or time in Excel multiple times, it can be a time-consuming process, so we can make it very simple by adding a short cut to finish the process. Read this tutorial to learn how you can use doubleclicking in Excel to automatically ... Read More
Pradeep Kumar
629 Views
When we added the comments to the cells in Excel, you may have noticed that the comment will only contain the name of the user, but we can also customise the comment to add the date and time to the spreadsheet. We can use the process mentioned below to automatically ... Read More
Pradeep Kumar
12K+ Views
Assume we have a problem where we want to give students grades based on their grades, such as if they got 90 to 100 percent, give them an "O", and if they got less than 50 percent, give them "L" grades. If we try to do this manually, it could ... Read More
Pradeep Kumar
23K+ Views
Let us assume we have collected the data from a public source and you want to add the ID to each result. To do that, first we need to know how many unique items are present in the sheet. This tutorial will help you understand how you can assign a ... Read More
Pradeep Kumar
114 Views
A macro in Excel is used to automate the process that we use repeatedly. Using macros helps save time by solving the repeated process very rapidly. This article helps you understand how we can assign a hotkey to a specified macro in Excel. Generally, we find macros under ... Read More
Pradeep Kumar
9K+ Views
Filters can be applied to a single sheet in Excel, but applying the filter to multiple sheets at once is not possible by default. But we can make it happen with the help of the VBA application. Read this tutorial to learn how you can apply the same filter to ... Read More
Pradeep Kumar
3K+ Views
Generally, when we try to find a particular sentence, we always try to find it by using the first words of the text, but if we clearly understand the data, we can see most of the sentences will start with the same words, but they always end with different words. ... Read More
Pradeep Kumar
535 Views
We frequently use the "spell check" feature in Word, but have you ever tried to apply spell check for textboxes in Excel? This is not an inbuilt process for Excel; hence, we need to modify the textbox in order to complete our process. The spell check can’t be applied to ... Read More
Pradeep Kumar
367 Views
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 colour ... Read More