Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
MS Excel Articles
Page 74 of 119
How to group adjacent columns or rows separately or independently in Excel?
In this article, learners will understand the process of grouping the adjacent columns in Excel, and its associated benefits. The first and most important benefit of grouping data is that it improves the organization and makes it easier to read and analyze. Users can quickly collapse or expand the group to view the data according to the use and requirement, this will save time and make the spreadsheet professional and more efficient. Another major factor is that it makes the data manipulation easy. This means that modification and alteration of data become easy. For example, if the user wants ...
Read MoreHow do group (two-level) axis labels in a chart in Excel?
Excel is a popular spreadsheet software that allows users to develop, organize and analyze data, by using different available options such as tables, charts, and graphs. The most common benefit of using the chart is that it allows the user to analyze data easily, compare data becomes easy, and make conclusions fast and easy to understand by all. Nowadays, many interactive ways are available in Excel to make a presentable chart within a few seconds. In this article, grouping axis labels in a chart by using Excel, can be done by using two examples. The first example uses a chart, ...
Read MoreHow to go to the specific rows in a worksheet?
An Excel spreadsheet is a combination of rows and columns. Rows are the horizontal lines, on the other hand, groups are the vertical column of the worksheet. This article contains two examples. The first example is based on the use of a name box, and the second example is based on the use of a go-to dialog box. Both examples will guide the user about the process to move to any required cell and location. This example will make the provided cell location active for user editing. Users can write and use the cell according to their requirements. Example 1: ...
Read MoreHow to go back to the previous/last sheet with a shortcut in Excel?
Moving to the previous and last sheet is required when the user wants to search for any data or is willing to understand the data written on the previous and last sheet. Reconciling data from all sheets is good as it allows the user to use the whole data to generate the result. This will make data consistent and accurate. In this article, two examples are provided for the user. The first example is based on the use of VBA code, while the second example is based on the use of Kutool. Using kutool is more efficient and consumes less ...
Read MoreHow to get a week start and end date based on a specific date in Excel?
In this article, the user will learn how to obtain week start and end date based on a specific date in Excel. The two examples are depicted in this article. Both examples are based on the starting and end date of the provided week. The first example uses a formula to obtain the start and end date for the week. This example briefs the use of weekday and weekend methods to perform the same task. On the other hand, the second example will allow users to understand the use of VBA code. VBA code example also allows users to use ...
Read MoreHow to get the opposite of an ABS value in Excel?
ABS in Excel stands for "Absolute Value". This function takes only one argument, as a cell reference or number directly, and then determines the required absolute value. This article guides learners about the process to generate the opposite of an ABS value in Excel by using the formula, and VBA code method. The formula method contains two basic formulas, to convert the value directly to the opposite value. While the VBA code method is a code-based method, that uses the VBA code to solve the provided task. Example 1: To get the opposite of an ABS value in excel by ...
Read MoreHow to get the next sheet name in Excel?
In this article, the user will learn the process of obtaining the name of the next sheet, by using the VBA code in Excel. This article briefs users about the method to open the code area. Write the developed code in the code area, and finally, call the code to generate the required output. The provided VBA code is detailed and accurate. This article also guides users about the possible shortcuts, that can be used to make the task consume less time. For example, to open the code area use the key combination “Alt” +F11, instead of manually selecting ...
Read MoreHow to generate random character strings in a range in Excel?
Random data can be identified as random values, used to obtain some results. It can be used to perform simulations, to understand the pattern of different system components. It is useful when a user requires a large data set to evaluate some common feature. This article allows the user to generate a random string with three possible methods. The first method is based on the user-defined formula, the second method is based on the use of VBA code, and the final third method is based on the use of kutool. Example 1: To generate random character string in a range ...
Read MoreHow to generate all combinations of 3 or multiple columns in Excel?
This article describes the user with 3 possible ways to generate the possible combination of 3 or more available columns in Excel. The first example is based on using the user-defined formula, to generate the possible combination. The second example is based on the method to use the VBA code, to generate the required combination. While the last example is based on using the Kutool to generate the same data. All three methods are completely accurate and can generate valid and unique results. Example 1: To generate the combination of 3 or multiple columns in Excel by using the formula ...
Read MoreHow to match dates by month and year only in Excel?
Sometimes we need to find the similar dates in dataset of multiple dates to identify the frequency of occurrence of any activity in a month/year or day. For this we have a formula in excel using which we can instantly find out the dates falling under a specific year and/or month even for a single day. We will be using the following two methods to identify the dates by month and year only from a dataset. Comparing adjacent dates by month and year only through a formula Finding dates by month and year only through Conditional Formatting Finding ...
Read More