Home
Learn
Forum
Others Links
Learn
Microsoft Word
Microsoft Excel
Dictionary
ContactMicrosoft Excel
<<<Previous Page
changing paper size
searching a text
searching and replacing a text
using goto option
changing zoom
inserting date and time
creating a text box
inserting symbol
inserting graphics
inserting pictures
writing equations
inserting page number
inserting header and footer
deleting header and footer
creating password protection
deleting password protection
inserting word art
using format painter
spell check facility of MS Excel
using print area
naming a range
using range name in functions
transposing row and column
creating salary sheet automatically using data table
using VLOOKUP function
recording and running a macro
sorting a database
filtering a database
validating data in database
removing duplicates from database
Next Page>>>
Bookschanging paper size
searching a text
searching and replacing a text
using goto option
changing zoom
inserting date and time
creating a text box
inserting symbol
inserting graphics
inserting pictures
writing equations
inserting page number
inserting header and footer
deleting header and footer
creating password protection
deleting password protection
inserting word art
using format painter
spell check facility of MS Excel
using print area
naming a range
using range name in functions
transposing row and column
creating salary sheet automatically using data table
using VLOOKUP function
recording and running a macro
sorting a database
filtering a database
validating data in database
removing duplicates from database
Next Page>>>
Dictionary
Forum
Others Links
Time -
Clock
Forgot Password?
Chapter 54
creating salary sheet automatically using data table
To create salary sheet automatically using data table follow these instructions :
First create the following table.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | DATA TABLE | |||
| 2 | ||||
| 3 | Name | Basic | H_Rent | Medical |
| 4 | Nasir | 4500 | ||
| 5 | Rimon | 4650 | ||
| 6 | Sharmin | 2540 | ||
Now select the range B4:D6.
Click on DATA and select TABLE.
Or click on What-If Analysis at the right of the DATA TOOLS option from the Data tab and select DATA TABLE.
A stop recording toolbar will appear.
In the dialog box click on COLUMN INPUT CELL.
Select B4 cell.
Click on OK.
Now in C4 write ?=B4*.50?, in D4 write ?500?. The following table will be created.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | DATA TABLE | |||
| 2 | ||||
| 3 | Name | Basic | H_Rent | Medical |
| 4 | Nasir | 4500 | 2250 | 500 |
| 5 | Rimon | 4650 | 2325 | 500 |
| 6 | Sharmin | 2540 | 1270 | 500 |
Was this helpful for you?
