![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
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](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
836 Views
Microsoft Excel is a powerful tool that has revolutionized the way we process and analyze data. One common task that you may encounter when working with Excel is counting the number of cells that meet a certain criterion, such as being above a certain value or above the average of ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
1K+ Views
Displaying specific text based on numbers in another column is a common activity in Excel, a powerful tool for organising and analysing data. This functionality can be quite helpful in a variety of situations, including data categorization, conditional formatting, and report generation. You may automate the process of displaying particular ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
762 Views
Excel macros are useful tools that you may use to automate repetitive tasks and save time. We'll demonstrate how to construct a macro code in this article so you may find certain text in your Excel worksheets and replace it with new data. The search and replace feature is incredibly ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
198 Views
Excel is a powerful tool that allows users to perform various calculations and data manipulations. One common task in Excel is to count the occurrences of certain strings or values in a range of cells. However, sometimes the strings in question may have leading zeros, which can cause problems when ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
1K+ Views
In Excel, message boxes are a terrific method to present users with prompts or essential information, but occasionally it's necessary to shut them automatically after a set amount of time. The process of creating a message box timer using Visual Basic for programmes (VBA), a programming language created primarily for ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
353 Views
A variety of tools and capabilities are available in Microsoft Excel, a robust spreadsheet programme, to help you with your data management and analytical activities. The Selection Pane is one of these capabilities, allowing you to arrange, manage, and regulate the visibility of objects inside your Excel spreadsheet. The Selection ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
3K+ Views
In order to efficiently organise and present data in Microsoft Excel, row heights and column widths are quite important. For a variety of reasons, such as altering formatting, aligning content, or examining data patterns, you may frequently need to know the precise dimensions of rows or columns. Although Excel offers ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
1K+ Views
When working with large datasets in Excel or any other spreadsheet software, it is common to come across a column containing multiple occurrences of the same value. However, in some cases, you may only be interested in counting the unique values and ignoring the duplicates. Counting unique values in a ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
2K+ Views
Welcome to this article on using Excel to display or show a date's year. For managing and analysing data, Excel is a robust spreadsheet programme that provides a wide range of features. When working with dates, it's frequently necessary to merely extract or display the year from a given date ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
1K+ Views
With the help of Excel, you may automate monotonous processes and increase your productivity. You can save time and effort by predefining particular actions or functions that can be quickly applied to subsequent workbooks by establishing a macro-enabled template. A file format (.xlsm) known as a macro-enabled template in Excel ... Read More