Found 159 Questions for Advanced Excel Function

How to add a scrollbar to a chart in Excel

Pradeep Kumar
Updated on 10-Sep-2022 07:54:12
You can use the scrollbar feature to show a chart with lots of data, just by dragging the scrollbar, you will see the data changing continuously while it's being displayed in the chart. If a lot of data needs to be shown, you can add the scrollbar. However, there is a tricky part in Excel when it comes to adding a scrollbar to a chart, so follow these steps step by step to finish this task. Add a Scrollbar in Excel You have the following data range wherein you want to add the scrollbar chart to the Excel worksheet. ... Read More

How to add a right hand/side Y axis to an Excel chart

Pradeep Kumar
Updated on 10-Sep-2022 07:54:44
The Y axis is automatically added to the left-hand side of an Excel chart while it is being created. You may need to switch it to your right hand in some circumstances, but how would you go about doing that? You will learn about the workarounds in this article. Add a right hand/side y axis to an excel chart Let’s understand step by step with an example. Step 1 In the first, we must create a sample data for chart in an excel sheet in columnar format as shown in the below screenshot. Step 2 Then, select the cells ... Read More

How to add a character before each word in a cell in Excel

Pradeep Kumar
Updated on 10-Sep-2022 07:55:28
The purpose of this article is to show you how you can use a formula in Excel in order to add a specified character before each word in a cell. Add a Character before each word in a cell with the Formula The following instructions will help you to add one or a few characters before each word that appears in an Excel cell. Step 1 Open an Excel workbook, select a cell blank cell and enter the below formula mentioned formula into the formula bar and then press Enter key. =”Character”&SUBSTITUTE(cell reference, ’’ “, “character”) Consider you ... Read More

How to add 1 to a specified cell if the cell contains certain text in Excel

Pradeep Kumar
Updated on 10-Sep-2022 07:55:55
Consider that you have a list of names in which one name is repeated multiple times. Now you need to scan the column for the name which is repeated multiple times and add 1 if another repeated name is entered in the specific cells to show the total number of the repeated name. Below shows an example of how to do this. Add 1 to a specified cell if the cell contains certain text with an array formula The array formula below can help you add 1 to a specified cell if a cell range contains certain text in the ... Read More

How to activate cell for editing with single clicking in Excel?

Pradeep Kumar
Updated on 10-Sep-2022 07:56:25
When we need to make changes to anything in any cell, editing is a typical practice. Therefore, it is really necessary to get some practice using the shortcut key for this particular activity. There are times when we have to change the content of the cell. Because we frequently need to amend the formula or debug the formula, the shortcut is quite useful. Often, we may need to edit the formula. In addition, it is essential to practice shortcut keys in order to reduce the amount of time required for particular tasks when you are a new learner. Because of ... Read More

How to accept or reject all changes in Excel?

Pradeep Kumar
Updated on 10-Sep-2022 07:56:59
When you enable change tracking for a workbook, you will have the ability to choose which changes to accept and which to reject. You can make this decision by selecting the Accept/Reject Changes option from the drop-down menu of the Track Changes command button on the Review tab of the Ribbon. Excel will analyze all of the highlighted changes that have been made to the shared file by you and anybody else who has worked on it, and it will give you the option to either accept or reject specific modifications. Excel will show you a warning dialogue box before ... Read More

Generate random numbers by giving certain mean and standard deviation in Excel

Pradeep Kumar
Updated on 10-Sep-2022 07:57:23
There may be times when you need to generate a series of random numbers based on specific mean and standard deviation for some scenarios. Below are some guidelines that will help you. Generate random numbers by given Mean and Standard Deviation To solve this, you need to follow the below step-by-step process. Step 1 To begin with, you need to enter your needed mean and standard deviation into two empty cells, in this case, I have selected A1 and A2 as shown in the below screenshot. Step 2 Afterwards, in cell B3, type this formula =NORMINV(RAND(), $B$1, $B$2) and ... Read More

Generate a random number with the given specific length in Excel

Pradeep Kumar
Updated on 10-Sep-2022 07:57:47
Nowadays most of them use multiple passwords in our day-to-day work. The password may contain different lengths. If you are not willing to set a password then you can use formulas or a tool that is handy to generate random passwords for you. This article gives you some tricks to generate random numbers of your desired length in an Excel workbook. Random Number in a given specific length using Formula Random number in a fixed length Assume that you want to generate a random number string in a 7-digit length using a formula for this you can use the below ... Read More

Find the lowest common denominator or greatest common factor in Excel

Pradeep Kumar
Updated on 10-Sep-2022 07:58:11
We have used the lowest common denominator and greatest common factors we are students. However, if there are more big numbers, doing this will be complicated. Greatly Excel provides some functions to get the lowest common denominator or greatest common factor of numbers. Finding the Lowest Common Denominator of some numbers in Excel Lowest Common Multiple The Lowest Common Multiple or LCM of a set of numbers is the smallest common multiple of those integers. This means all those numbers to be divisible by the LCM giving an integer value. LCM is useful for calculating problems related to gears and ... Read More

Excel tutorial: split text, number, and date cells (separate into multiple columns)

Pradeep Kumar
Updated on 10-Sep-2022 07:58:38
It's possible that, for certain reasons, you'll need to divide the text in a single cell into many cells. This lesson is broken down into three sections: dividing text cells, dividing numeric cells, and dividing date and time cells. You will have a better understanding of how to approach the task of splitting when you are presented with a variety of examples, which are provided throughout each section. Split text You may use any one of the following techniques to divide a single text cell into numerous columns based on a certain delimiter, such as a comma, a space, a ... Read More
Previous 1 ... 3 4 5 6 7 8 9 ... 16 Next