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 76 of 119
How to get the current workbook name in Excel?
A workbook is a type of document used to organize and manage data or information in a structured format. MS Excel is also an example of a workbook. It is categorized as a software application used to process and manipulate data. This tutorial provides two examples to obtain the current workbook name. The first method is based on the use of VBA code. This method allows the user to define a module, to obtain the required output. On the other hand, the second method is based on the use of Kutool plus extension. Example 1 − To obtain the current ...
Read MoreHow to Generate Random Yes or No in Excel?
Random values are used to obtain results. These results can be used to perform simulations, to understand the pattern of different system components. It is useful when users require a large data set to evaluate some common feature. Generating random yes or no can be useful for pole or opinion-related services. This article allows users to use two methods to generate random Yes or No. The first method is based on the use of predefined formulas presented in Excel. On the other hand, the second method is focused on using the kutool to make the work easier. Example 1: To ...
Read MoreHow to generate random weekday or weekend date in Excel?
This tutorial is designed to help learners to understand the technique to generate random weekday or weekend date in excel. In this tutorial, the user will understand three possible methods to perform this task. First method is based on using predefined formula, to generate random date. Second method allow user to use kutool to generate the random dates, and last method allow user to use the VBA code to generate the date randomly. Same method can be used to generate both weekday and weekend dates. Example 1: Example to generate random weekday date in excel. Step 1: To understand the ...
Read MoreHow to generate random value from a given list in Excel?
This article is designed to allow users to understand the process and can generate random data values, from the provided list of data that is based on some predefined or provided data set or collection. Here, data can be of any type, for example, string, int, and any other. For this article will assume that the available data is of string type. The article contains two examples, first example performs the provided task by using the predefined formula. While the second example will perform the same task by using the kutool. Example 1 − To generate random value from a ...
Read MoreHow to Generate Random Positive and Negative Numbers in Excel?
Random data is a type of data generated randomly. In this article, the users will learn how to generate random positive and negative numbers by using the predefined available Excel methods, and kutool. Random data can be used for any purpose such as creating a sample data set or evaluating results based on the dataset. This article contains four examples in which the first two examples will allow the user to generate random positive and negative numbers by using available formula methods, while the remaining two examples will allow the user to generate positive and negative numbers by using the ...
Read MoreHow to Generate Random Decimal/Integer Numbers in Excel?
Random numbers are the random values, used to obtain some results. It can be used to perform simulations and to understand the pattern of different system components. It is useful when the user requires a large data set to evaluate some common feature. Decimal numbers are numbers that contain some fractional part. For example, ,1.2, and 3.5 are decimal numbers. While integer data contain numbers without fractional parts. An example of integer value is 1, 2, 5, and many other, that does not contain a decimal value. Example 1: To generate a random decimal number in Excel by using the ...
Read MoreHow to Generate Lottery Numbers in Excel?
Generating lottery numbers by using Excel is an easy and time-saving process. The described task can be done by using two different examples. The first practice involves using the VBA code. The user needs to create a module and execute the module to generate the lottery number. The second example is based on the use of kutools. In the kutools example, the user is required to use a random value function to implement the required functionality. Since the lottery number should be an integer data. Therefore, this tutorial is generating the lottery number with an integer type. To generate the ...
Read MoreHow to highlight values that appear X times in Excel?
In the article, the users are going to highlight the numbers that are present many times or X times in Microsoft Excel. There are several features in the excel sheet including conditional formatting, and format cells that the users have to fill any type of color according to their needs. We can use the formula for changing cell values in the new formatting rule dialog box. To highlight values that appear X times in Excel Step 1 Deliberate the excel sheet with the data. First, open the excel sheet and create the data one by one. In this sheet, type ...
Read MoreHow to highlight winning lottery numbers in Excel worksheet?
In the article, the users are going to highlight the lottery numbers for winning in Microsoft Excel. There are the several features in the excel sheet including conditional formatting, format cells that the users have to fill any type of color according to the need. The users can use the formula for changing cell value in the new formatting rule dialog box. The users can use select the range in which you want to fill the color in any cell. Step 1 Deliberate the excel sheet with the data. First, open the excel sheet and create the data one by ...
Read MoreHow to highlight whole numbers in Excel?
In the article, the users are going to highlight the whole numbers in Microsoft Excel. There are several features in the excel sheet including conditional formatting, and format cells that the users have to fill any type of color according to their needs. The users can use the formula for changing cell values in the new formatting rule dialog box. The users can use select the range in which they want to fill the color in any cell. To highlight whole numbers in Excel Step 1 Deliberate the excel sheet with the data. First, open the excel sheet and create ...
Read More