- Trending Categories
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
Found 2043 Articles for Microsoft Technologies
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
248 Views
Do you often encounter too much data and spend a lot of time selecting and clearing Excel sheets? If so, this tutorial will be helpful to you. When analysing elaborative Excel worksheets, removing non-relevant information often makes it easier to study them. This tutorial explains how to clear an entire spreadsheet and a specified range in MS Excel using two simple methods Method 1: How to Clear The Entire Sheet? This is an easy procedure. If you want to clear the entire sheet, you can use a keyboard shortcut or from the corner cell. We learn how to do ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
4K+ Views
It is commonly known that when you right-click on an Excel file, you can see its properties and size. But what about when you want to know the size of individual worksheets within the file? Accountants and data analysts maintain large Excel workbooks with multiple worksheets. Understanding the file size can help determine the best way to analyze it. Some might want to begin with the heavy worksheet, or some may start with the lighter one. It often turns out that one sheet takes up the majority of the space in the workbook. This tutorial explains how to identify the ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
23K+ Views
"Lost time is never found again." Many organisations and professionals are looking for the best way to make the most of their time. Microsoft Excel has the necessary tools and functions to measure time quantitatively. Using an example dataset, we will demonstrate how to measure time against a specific time in Excel using two formulas mentioned in the steps. Find out how in the following steps. Method 1: Measuring Time with a Logical Function We use an example of 9 students who had to submit their assignments before 03:30 PM. Their submission time is recorded in the spreadsheet below. In ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
25K+ Views
MS Excel is handy when you need to keep track of your time and make the most of your resources. Suppose you want to find out how long it takes employees to complete an assignment. You can log the times in your spreadsheet and run a simple function to check if resources are being optimised or not. In light of the results, you can highlight which reports were submitted after the deadline. With two formulas, this tutorial demonstrates how to determine whether a specific time is within a particular range. Using the Nested “IF” Function A logical function, ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
672 Views
Microsoft Excel has the potential to make your professional life easy. It helps you organise, evaluate, and calculate data reliably. Managers and administrators can make relevant decisions that benefit their organisations using the various tools and functions available on the software. With Excel, you can also check the time difference over a specific period. Using this simple method in this tutorial, you can determine if a time difference is greater than a particular period in any given situation. Comparing Time Difference with a Specific Duration Using an Array Formula Suppose you maintain an employee log-in sheet and must determine ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
5K+ Views
What if you could find out whether a number in your Excel data set is prime or not in less than 5 steps? We will tell you how in this tutorial, but first, let us understand what a prime number is. A prime number is a number which is divisible only by 1 and itself, and the number 1 is not a prime number. Applying this simple definition, you can use the formula described in the steps to determine if a number is indeed a prime number or not. Array Formula For Checking Prime Numbers An array formula ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
11K+ Views
Are you looking for a simple and quick way to find if the numbers in your data set are integers or not? Well, if you are using Microsoft Excel, the answer is here! An integer is a whole number that can be positive, negative, or 0 but cannot be a fractional number. There are formulas in Excel that help professionals identify the integers in data sets. In this article, we explain two techniques and how to use them. Technique 1: Using the INT Function With Excel's INT function =INT(), you can find the integer fraction of a number, and ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
2K+ Views
When it comes to text in MS Excel, one of the most commonly required tasks is to capitalize the first letters in the cells if it contains names, tasks, products, places, or anything else. Unlike Microsoft Word, Excel does not offer the Change Case button, which allows the capitalization of texts. Human errors, such as not capitalizing the relevant letters in the spreadsheet, are common when entering a lot of data. When this happens, one wonders how to quickly check whether a certain cell has a capital letter in the first letter. In this tutorial, we teach how to ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
13K+ Views
Planning to send emails but worried some addresses may be entered incorrectly in your spreadsheet? When mailing your clients, you may often see more than one invalid email. Thanks to Microsoft Excel, you can identify these email addresses and correct them as required. This process is also known as data cleansing. Cleaning your data ensures that your spreadsheet only contains relevant information so you can easily move on to the next task. The goal is to repair any data that is wrong, incomplete, poorly structured, duplicated, or even unrelated to the data set's mission. Find Invalid Email Address ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
924 Views
Often there comes a spreadsheet where you would need to make a preliminary check to see if any row is hidden. Fear not; it is very easy to check. Hiding rows is an interesting feature of MS Excel where not relevant information can be concealed in a spreadsheet without deleting them forever. While working on the file, your teammates may have concealed rows to optimize their visual perspective of the data by removing unnecessary rows, computations, or anything else that might reduce the file's readability. In this tutorial, we explain how to identify hidden rows in your excel ... Read More