When working with a large array of cells, manually cross-checking if a specific cell value is repeated in another column in the spreadsheet can be difficult and lead to skewed results. Fortunately, there are several options in Microsoft Excel that allow you to do this quickly and efficiently. In a ... Read More

Many professionals use Google Sheets to keep a record of time and date for HR and other purposes. While manually entering the values can take a lot of time, you can use the in-built features in Google Sheets to combine values in one cell. With this tutorial, we ... Read More

In Microsoft Excel, combining the contents of multiple cells into a single cell with separators like spaces, commas, or other characters can be a valuable data manipulation and analysis technique. This helps the user to create concatenated strings that bring together information from different cells in a structured manner. ... Read More

A useful technique for organising and analysing data scattered in different columns is to combine them to just one column. Whether you want to merge related information or create a consolidated view, Google Sheets provides powerful tools to accomplish this task efficiently. In this tutorial we will explore two easy ... Read More

One of the key content inputs in Excel is strings. Strings refer to a sequence of characters or text like letters, numbers, symbols, and spaces. An Excel string can also represent a name, address, description, or any other textual information. Excel treats it as alphanumeric data rather than just numerical ... Read More

If you enter data from multiple sources in your Excel worksheet, you are likely to enter duplicate information. These duplicate entries of data sets would need to be consolidated in order to rectify the error. ​​In a small dataset, duplicate values are easier to spot and correct; however, ... Read More

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 ... Read More

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 ... Read More

"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 ... Read More

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 ... Read More