Step-by-Step Procedure on How to Use Variables in Excel

1. ExcelTutor.com Call Us +1-561-542-2338 Step-by-Step Procedure on How to Use Variables in Excel! Excel is a well-known spreadsheet application. Spreadsheets allow you to handle numerical data and perform Calculations, Analysis, and Forecasting. So is that all it does? No, Excel allows you to do a lot more than this. You can perform many versatile tasks and functions and also a wide range of spreadsheet-related tasks. Step 1 Open excel and create a new workbook, and type the values given below in any column of your spreadsheet. Keep in mind that all values need to be entered in the same column: r i l g Step 2 After you’ve entered the aforementioned values in the column, type any number in the cell directly to the right of the “r” cell. This number is the value variable “r” will take on. Type any number you want for the next 3 cells directly below the preceding cell. Step 3 Now after you’re through with the above process, take your mouse over the cell that contains “r,” then press and hold the left mouse button. Simply drag down “r” until your mouse is over the last number you typed, then release the mouse to select the two columns you typed! Step 4 ExcelTutor.com “GetThe Most Experienced Microsoft Excel Training & Guidence Online With ExcelTutor.com – Happy Learning” http://exceltutor.com/ | (+1) 561-542-2338

2. ExcelTutor.com Call Us +1-561-542-2338 Now click the “Formulas” tab in the ribbon and left click the “Create from Selection” command in the defined names group. Now you’ll see that Excel displays a dialog, specifying which group of cells contains text, from which you’d like to make variables. Step 5 Simply click the “left column” option to specify the first column into which you’ve typed as the range holding the variable names. Step 6 After this click any empty cell in the current spreadsheet, enter the formula given below into the cell. This particular formula uses the variables you created with the “Create from Selection” command. After you’ve entered the formula, Excel will display its result, i.e., the sum of the numbers you entered in the column to the right of the variable names! “=r+i+l+g” Step 7 In the formulas tab, click the “Name Manager” button. Now what this does is displays the “Name Manager dialog box.” Furthermore, this lets you Edit and Create Excel variables! Step 8 Click the “r” variable from the dialog’s list of variables, and click the “Delete” button and close the dialog. The formula you typed now displays “#NAME?” because this is simply an error in the formula because you’ve deleted the “r” variable. Step 9 Finally, click the “Name Manager” button once again, and then click the Dialog’s “New” button to indicate that you want to make a new variable. Type “r” in the “Name control” of the “New Name dialog,” then click in the “Refers to” control. Now simply click the cell directly to the right of the cell containing the “r” to specify the cell that the new variable represents. Close all dialogs and notice that the formula cell no longer displays the “#NAME” error; as it contains the sum of all the numbers in the right column as it did before! Follow these simple steps and you’ll know how to use Variables in Excel in no time! Reference: http://exceltutor.com/ Source:https://medium.com/@knightcis/step-by-step-procedure-on-how- to-use-variables-in-excel-b4f1ac925baf#.ewte689b2 ExcelTutor.com “GetThe Most Experienced Microsoft Excel Training & Guidence Online With ExcelTutor.com – Happy Learning” http://exceltutor.com/ | (+1) 561-542-2338