
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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 1235 Articles

Pradeep Kumar
635 Views
When faced with a frequent scenario, the majority of us may be required to input arbitrary numbers, dates, or text strings according to our preferences. However, at times, have you ever attempted to insert times into a range of cells in a random range? This function's name is RAND(). Excel ... Read More

Pradeep Kumar
625 Views
If there are only a few workbooks that need to be merged, you can manually move or copy worksheets from the original workbook to the master workbook by making use of the Move or Copy command, which is available if there are only a few workbooks that need to be ... Read More

Pradeep Kumar
1K+ Views
You may find that in many situations, all that is required of you is to extract the useful content from a sentence or a text string contained within a cell. For example, you may need to extract the province from the address, extract the email address from a sentence, or ... Read More

Pradeep Kumar
889 Views
It's possible that, for certain reasons, you'll need to divide the text in a single cell into many cells. This lesson is broken down into three sections: dividing text cells, dividing numeric cells, and dividing date and time cells. You will have a better understanding of how to approach the ... Read More

Pradeep Kumar
4K+ Views
We have used the lowest common denominator and greatest common factors we are students. However, if there are more big numbers, doing this will be complicated. Greatly Excel provides some functions to get the lowest common denominator or greatest common factor of numbers. Finding the Lowest Common Denominator of some ... Read More

Pradeep Kumar
685 Views
Nowadays most of them use multiple passwords in our day-to-day work. The password may contain different lengths. If you are not willing to set a password then you can use formulas or a tool that is handy to generate random passwords for you. This article gives you some tricks to ... Read More

Pradeep Kumar
7K+ Views
There may be times when you need to generate a series of random numbers based on specific mean and standard deviation for some scenarios. Below are some guidelines that will help you. Generate random numbers by given Mean and Standard Deviation To solve this, you need to follow the below ... Read More

Pradeep Kumar
436 Views
When you enable change tracking for a workbook, you will have the ability to choose which changes to accept and which to reject. You can make this decision by selecting the Accept/Reject Changes option from the drop-down menu of the Track Changes command button on the Review tab of the ... Read More

Pradeep Kumar
1K+ Views
When we need to make changes to anything in any cell, editing is a typical practice. Therefore, it is really necessary to get some practice using the shortcut key for this particular activity. There are times when we have to change the content of the cell. Because we frequently need ... Read More

Pradeep Kumar
11K+ Views
Consider that you have a list of names in which one name is repeated multiple times. Now you need to scan the column for the name which is repeated multiple times and add 1 if another repeated name is entered in the specific cells to show the total number of ... Read More