Google Sheets is a cloud-based spreadsheet program developed by Google. It allows users to create, edit and collaborate on spreadsheets online, in real-time with other users. Google Sheets is similar to Microsoft Excel but with added features that make it more collaborative and accessible. Users can create and format cells, ... Read More

In this article the user will understand the process of generating the date of birth from the ID number in excel. This article provides a brief and an easy example to guide the user the way to generate the date of birth from the provided employee ID. Thus, to evaluate ... Read More

In this article, the user will understand how to generate the random data value based on assigned probability in MS Excel. One example is depicted where two simple formulas are used to generate the required results. Random data would be used in multiple experiments and studies, and to analyze the ... Read More

This article is designed for user to group the time data by using the two examples for minutes, and hours. To understand the process in depth it is better to explain both the processes separately by using different example. Interval can be defined as the difference in between two provided ... Read More

Grouping sheet in excel is a good feature. By using this feature users can use the data of multiple sheets simultaneously. This feature will save lots of user time. This feature allows users to properly structure the data with the header names mentioned in the column. Once, the user work ... Read More

Grouping will save a lot of time when users need to perform the same task repeatedly. In more, simple word changes made to the single sheet will be reflected in multiple grouped sheets simultaneously. radio/ open buttons are a type of control buttons available in Excel. A group of multiple ... Read More

This article focusses about the evaluation of the first and last empty rows. To accomplish the provided task, it is better to use VBA code. VBA is an acronym for visual basic analysis. It is a Microsoft programming language used for office applications. It contains a coding script. Code can ... Read More

Nowadays, many tutorials and guides are available, to guide the user about the shortcut or easy ways to access the same work, in a shorter time. This will help user to save time and increases their processing speed. Similarly, this article will try to teach two methods to access specific ... Read More

Sometimes the user is working with multiple worksheets at the same time. While working with a large number of sheets, obtaining current sheet numbers is important to track the current working operations status. To access the worksheet number, for this tutorial, we are using two strategies, the first strategy involves ... Read More

Address of cell in excel generally refers to the location of some cell. Active cell can be defined as the cell that contains some data or can be active due to some user click or any other associated activities. Getting the active cell address can be important to understand the ... Read More