- 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
710 Views
Have you ever tried to convert a vertical list to a horizontal list, or vice versa, in Excel? Manually doing this can be time-consuming because we must type data into each cell and each new cell. We can complete this task in a faster and simpler way by using the ... Read More
Pradeep Kumar
3K+ Views
A matrix is rectangular array with n rows and m columns. Sometimes in excel when we have a data in single column or single row you would want to convert them into a matrix. If you try to solve this manually, then it can be a time-consuming process, as we ... Read More
Pradeep Kumar
2K+ Views
Sometimes you may have observed that the dates in the sheet are not in a valid format. If the dates are not valid, we will not be able to perform any operations. So, it is very important for us to know different ways in which we can convert them into ... Read More
Pradeep Kumar
833 Views
Have you ever tried to convert a text to a hyperlink in Excel? If you are facing any difficulty, this article will help you complete the task. The HYPERLINK function creates a shortcut that jumps to another location in the current workbook or opens a document stored on a network ... Read More
Pradeep Kumar
2K+ Views
Sometimes when we have True or False values in Excel, you would have needed to change them to checkboxes for better and accurate analysis. We can solve this task using the VBA application, as it cannot be completed directly in Excel. Read this tutorial to learn how you can convert ... Read More
Pradeep Kumar
1K+ Views
Have you ever wondered if Excel has an inbuilt translate function that can assist us in converting between languages without the use of any external applications, such as uploading the content to the internet and performing the operations? The translator can be used to convert between the languages. Sometimes in ... Read More
Pradeep Kumar
5K+ Views
An "Integer hour" is a time that is represented as a number. Sometimes in Excel, you may have needed to convert the given time to integer values. If we try to do this task manually, then it can be a time-consuming process, however we can solve this task using the ... Read More
Pradeep Kumar
1K+ Views
In Excel, you may need to convert times that are longer than 24 hours to decimal to facilitate our understanding. For example, 25:00:00 will be represented as 25. Manually completing this task can be a time-consuming process. Read this tutorial to learn how you can convert time to decimal over ... Read More
Pradeep Kumar
1K+ Views
Sometimes in Excel, you may have observed that the time is represented as a string. So, it is very important for us to know the different ways in which we can convert a time string to time or time and data. Read this tutorial to learn how you can convert ... Read More
Pradeep Kumar
6K+ Views
Generally, in Excel, converting time can be one of the most common tasks. If we try to do it manually, then it can be a very time-consuming and complex process. A 12-hour clock has two sets, namely AM and PM, whereas the 24-hour clock has only one set. As almost ... Read More