1 / 2

# Step-by-Step Procedure on How to Use Variables in Excel - PowerPoint PPT Presentation

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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'Step-by-Step Procedure on How to Use Variables in Excel' - abhishekcis

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

+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

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

+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