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 118 of 119
Generate random numbers by giving certain mean and standard deviation in Excel
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 MoreHow to accept or reject all changes in Excel?
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 MoreHow to activate cell for editing with single clicking in Excel?
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 MoreHow to add 1 to a specified cell if the cell contains certain text in Excel
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 MoreHow to add a character before each word in a cell in Excel
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 MoreHow to add a scrollbar to a chart in Excel
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 MoreExcel cell conversion tutorial – Convert units, text and number, currencies, time zones, etc
When dealing with data in Excel, there are instances when you may find that you need to do certain data conversions on cells, such as converting units, converting currencies, converting time zones, and so on. Convert Units In most cases, when we need to convert a number from one unit of measure to another, we will utilize the CONVERT function. However, the CONVERT function will not operate properly for some of the unit conversions that you attempt. Step 1 You may use the CONVERT function to convert the inches specified in the range to the corresponding values in feet, centimeters, ...
Read MoreHow to Convert Date Stored as Text to Date in Excel?
When we need to conduct trend analysis, dates act as essential elements. Dates play an important role and you need to make sure that they are conveyed in the best possible way. There are times when dates might end up being formatted as text and saved in the cells.You may have, for instance, placed a date into a cell in text format, or the date may have been imported or pasted from an external data source as text.Convert Text Dates with Two-Digit Years by Using Error CheckingIn this tutorial, we will discuss two methods to convert text formatted dates to ...
Read MoreHow to Combine Data from Multiple Excel Worksheets into One?
There are situations when the data that you require is scattered across numerous sheets in Microsoft Excel, or even multiple files. How wonderful it would be if you could collect all this data in a single document?When you are in a hurry, you can save time by simply copying and pasting the necessary cells onto the same sheet. However, the amount of time and effort required to complete this task may be quite substantial, depending on the data that you are analyzing. Instead, you could think about some of the more intelligent approaches to complete the same task.In this tutorial, ...
Read MoreHow to Calculate Age in Excel from Birthday?
Suppose you have compiled a list of the student’s dates of birth in an Excel spreadsheet, and at this point, you need to figure out how old each one of them is. Excel has a number of useful functions, like DATEDIF and YEARFRAC, that can make it easy to figure out a student’s age based on their birth date.Using the DATEDIF FunctionThe DATEDIF function can convert the birth date to the current age. The general syntax for this is as follows −=DATEDIF(birthdate, TODAY(), "y")Where, Birthdate − The date that corresponds to the student's actual birthday.TODAY() − The current date is ...
Read More