![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
405 Views
Excel is a powerful tool that allows users to perform a wide range of data analysis tasks with ease. One common task is to count the number of rows in a spreadsheet until a certain sum value is reached. This can be useful for various applications, such as calculating the ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
2K+ Views
The worksheet tabs are automatically positioned at the bottom of the window by Excel, making it simple to navigate between sheets horizontally. This article is for you if you favour a vertical arrangement of worksheet tabs, though. When working with a lot of sheets or when you want to see ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
207 Views
Excel is a powerful tool for data analysis and management, and one of its useful features is the ability to filter and count records based on specific criteria. If you have a large dataset with dates and other attributes, you may need to count the number of records that fall ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
4K+ Views
Powerful spreadsheet software like Excel provides a number of formulae and functions to manage and organize data. Excel may be a useful tool for everyone, whether you're a professional working with financial data, a student maintaining a calendar, or just someone who needs to keep track of weekdays or business ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
756 Views
You can frequently find yourself in a position where you need to combine and analyse data from other worksheets if you work with large Excel workbooks with numerous pages. One frequent task is to remove any duplicate values from numerous sheets and generate a list of the unique values. This ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
4K+ Views
Excel is a powerful tool that allows users to perform a wide range of tasks, from simple calculations to complex data analysis. One of the many features that makes Excel so versatile is the ability to use formatting to help organize and analyse data. In this tutorial, we will focus ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
96 Views
If you're working with a team or tracking your own work hours, calculating the number of hours worked can be a time-consuming task. Fortunately, Microsoft Excel has built-in functions that can help you quickly and easily calculate the total number of hours worked between two specific times. In this tutorial, ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
133 Views
Accessing and managing worksheet names is an important skill because Excel is a potent tool for data analysis and organisation. Regardless of your level of Excel proficiency, this tutorial will walk you through the procedure step-by-step. Have you ever struggled to remember the names of all the worksheets in a ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
205 Views
Excel is a widely used spreadsheet software that offers numerous features for data manipulation and analysis. One of the most common tasks that users perform in Excel is counting the occurrences of a specific character within a cell. This can be useful in a variety of situations, such as when ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
287 Views
Tracking changes in Excel is important when you want to monitor the history of a specific cell or range of cells, especially in a collaborative environment where multiple users have access to the same workbook. By counting the number of times, a cell has been changed, you can easily keep ... Read More