- 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
222 Views
What is Static Method? In PHP, a static method is a method that belongs to the class itself rather than an instance (object) of the class. It can be accessed directly using the class name, without the need to create an instance of the class. Example ... Read More
Pradeep Kumar
1K+ Views
Excel is a powerful tool that offers a variety of functions for data manipulation and analysis. To extract bold text only from a list in Excel, you can use a VBA macro. Extracting Bold Text Only from a List in Excel Here, we will first create a formula ... Read More
Pradeep Kumar
800 Views
Negative values can occasionally interfere with data analysis or calculations, and deleting them might help you focus on the good parts of your data. Excel provides effective options for filtering out undesired rows with negative values, whether you're working with financial records, survey results, or any other type of data. ... Read More
Pradeep Kumar
1K+ Views
Extraction of certain filename components, like the extension, might be helpful when working with filenames in Excel. The file type is indicated by the extension; for example, ".xlsx" stands for Excel files, ".docx" for Word documents, and ".jpg" for image files. You may simply categorise and analyse files depending on ... Read More
Pradeep Kumar
1K+ Views
You've come to the right place if you're using Excel to work with matrices and need to extract only the diagonal elements. A matrix's diagonal elements are those that are located on the major diagonal, which runs from top left to bottom right. When performing calculations or data analysis, extracting ... Read More
Pradeep Kumar
208 Views
This tutorial will show you how to extract particular decimal values that are embedded within text strings in Microsoft Excel. It can be difficult to work with data that combines language and numbers, especially when you need to separate and extract particular numerical figures for additional research or calculations. Excel ... Read More
Pradeep Kumar
3K+ Views
Visual data representations, such charts and graphs, offer a useful approach to comprehend and analyse data. To obtain the underlying data points from a chart or graph, however, may be necessary in some circumstances for reporting or additional analysis. Whether you work with data as a researcher, student, data analyst, ... Read More
Pradeep Kumar
282 Views
Millions of people and organisations use Excel, a robust spreadsheet programme, to organise and analyse data. The capacity of Excel to execute calculations using formulae is one of the primary characteristics that contribute to its versatility. Excel formulas let you work with data, conduct a variety of mathematical operations, and ... Read More
Pradeep Kumar
2K+ Views
To extract duplicate values from a column in Excel, you can use the COUNTIF formula combined with conditional formatting. First, apply the formula "=COUNTIF(A:A, A1)>1" to identify duplicate values in a new column. Then, use conditional formatting to highlight the cells that meet the condition. This will visually highlight the ... Read More
Pradeep Kumar
2K+ Views
Excel is a powerful tool that offers a variety of functions for data manipulation and analysis. To extract all but first /last word in Excel, you can use a combination of text functions like FIND, LEN, and SUBSTITUTE. Here's a step−by−step guide: Extracting All But First Word in Excel Let ... Read More