![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
261 Views
Follow the steps given below to understand clearly how to calculate the median in a range in a Microsoft Excel sheet. Step 1 Open a Microsoft Excel sheet, and enter the data as shown in below you can also enter the data as per your wish. Step 2 ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
990 Views
Whenever you work for a certain organization, you need to log in and log out at the starting and end of every workday, and counting the total working hours, minus the lunch time of a day will make it quick for you to calculate the salary based on the amount ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
1K+ Views
Spreadsheets allow Excel's powerful data visualisation and analysis software to manage, store, and display massive amounts of data in a graphical format. Excel is a powerful data visualisation and analysis software. Each individual piece of data is saved inside of a cell, which is a square or rectangular block. ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
836 Views
The Easter celebration is usually celebrated on the first Sunday that follows the first ecclesiastical full moon that falls on or after March 21. Because of this, the date of Easter might vary from year to year. This tutorial may be of assistance to you if you are looking for ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
2K+ Views
How would you find out how many days are left till your next birthday, if it is something you are interested in? Actually, if you are counting down the days till your next birthday with Microsoft Excel, you may utilise the worksheet formulae to make the process much simpler. ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
5K+ Views
At times, you may want to know the working days left in a month or in a year. So, if you want to calculate the remaining days left in a month or to calculate the remaining days left in a year you can follow the below article which is easy ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
164 Views
For you to calculate the compound annual growth rate (CAGR) in an Excel sheet, there is a basic formula that you need to follow =(End Value/Start Value)^(1/Periods)-1 you can easily apply this formula for this kindly follow the below steps − Step 1 Open a Microsoft excel sheet and enter ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
837 Views
You know how to calculate the normal average function which gives the average value of all the selected cells in an excel sheet. But in this article, you will learn how to calculate the average excluding the min and max values or highest and lowest values from selected numbers as ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
4K+ Views
In a typical scenario, we are able to easily calculate the average speed in an Excel worksheet by using the formula Speed = Distance / Hours. However, there are situations in which the hours are not represented by numbers but rather a time format, how would you handle this work ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
15K+ Views
How can we do the calculations needed to determine the average of all the numbers on the various worksheets if we want to accomplish that? This post will show you an easy approach to compute the average for all numbers across several worksheets. Currently, we may know how to calculate ... Read More